Hi All,
I've got a line chart that shows drama school sales for the current fiscal and is getting to be quite long and not very useful for seeing sales trends. I would like to change it so that it just shows the last 30 days of sales trends. However, if I filter on orders in the last 30 days it doesn't show the proper total.
This is the full chartThis is the chart with a last 30 days of orders filterOther ideas for how I can make this more visually useful? We will continue to add more seasons as time goes on for Winter and Spring classes, so it's only going to get harder to read.
Hi Kanani,
The zoom feature, which does reset when the dashboard is reloaded, only appears with the widget is not big enough to show the full result set without some kind of compression in the axis labels. In other words, if the widget seems big enough to display everything, it doesn't offer the slider/zoom control.
I recommend going ahead with the filter on Last 30 Days, and to use that in combination with a formula that overrides the Last 30 Days and gets the total from prior to that period, and then adds that to every value from the RSUM() result.
RSUM( [Total Ticket Paid Amount] ) + ( [Total Ticket Paid Amount] , [Performance Date Last 360 Days, offset 30] )
Chris Wallingford and Neil Cole thanks for your help. That was in fact what I was trying to accomplish. Neil thanks for all that detail, it helped me understand what Chris's formula was doing. My finished chart below.
Great to hear. Glad to help. I also learned about the Auto Zoom feature that I didn't know. I always wondered why it would show sometimes but not others.