Highlight/Zoom in on last 30 days of a line chart

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 chart

This is the chart with a last 30 days of orders filter

Other 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.

Parents
  • Maybe you can find another one of your dashboards that happens to have that Auto Zoom thing. Then drag it to the dashboard you are working on and then make it the same.
     
    Maybe Chris can think of a way.
     
    Are you looking to keep your grant total amount shown at the right or just the last 30 days total? Those are two different things. I was assuming you wanted to keep the grand total. If so, that auto zoom idea seemed to be the easiest option.
     
    Neil
     
Reply
  • Maybe you can find another one of your dashboards that happens to have that Auto Zoom thing. Then drag it to the dashboard you are working on and then make it the same.
     
    Maybe Chris can think of a way.
     
    Are you looking to keep your grant total amount shown at the right or just the last 30 days total? Those are two different things. I was assuming you wanted to keep the grand total. If so, that auto zoom idea seemed to be the easiest option.
     
    Neil
     
Children
No Data