I have a graph containing week numbers as a dimensional horizontal 'X' axes, separating my financial calculations/expressions to draw calendar comparisons and timelines.
As the weeks turn over my financials are starting to merge, as I run out of graph/screen space.
£123 £456 £789
1 2 3 etc.
1 2 3 etc.
Now that we are in week 23, in an ideal world I would like a rolling 10 weeks to display so that everyone can clearly read the graph without having to expand it. - Filtering out what has now become of less important to the business, week 1-13.
Three options I have explored:
Creating a 'Flag' in the script use in the Set Analysis of my expressions: This works on simple graphs, but I have a 50+ 'conditional' display expressions in one graph covering a wide range of expressions that are further complicated with year-on-year comparison, variances and %age diff etc.
Apply the Scroll Bar to the x axes: This is a little temperamental to use and requires the user to scroll right to see the latest weeks comparison until I sort the weeks z/a - which does not make for conventional reading of a rolling week. (backwards)
Tried the 'Dimensional Limits' within the chart properties which allows me to display
'First' X number of weeks
'Largest' X number of weeks
'Smallest' X Number of weeks
.... BUT NOT 'Last' X Number of weeks.
There has to be an easier way to achieve this over and above the options tried above.