Hello,
Currently we use the RSUM function to add a set daily goal "line" and display it on a chart, with $ value being Y Axis, and the Date being the X Axis. We then filter it to see just one month at a time (and 1 month per chart), which allows us to compare to set daily revenue goal line (above) to the daily updating revenue calculation "line" on the same chart.
The above works great for us.
We would like to do the same for the "average daily sales this month, last year" but as a "tile" rather than a chart. We have the hard coded the average daily revenue for each month last year, and have it functioning on a line chart using "Date" as the X Axis on this chart.
How do I get the current value of the line into a "tile"?; as the RSUM needs a "Date" in order to add the average daily revenue onto itself everyday.
The above question also creates an issue where current month isn't finished, but last year-current month is, so the current revenue will always be less than "same month-last year" until month end. Is there a way to only include days in "same month-last year" to match how deep we are into "current month-current year"?
Thank you!