I'm working on a linechart in report studio, where I want to show the balance of an account (In total I want a line for 4 accounts) for all records from 2008 until now.
So I have a linechart with
- balance as measure
- account as series (that will be 4 lines in my case)
- date on the categories and nested (below) ID (this nesting is to make sure that the balances are not rolled-up (a sum is incorrect for balances since it is non-additive))
The chart is working OK, but the x-axis looks like one big mess...
Very "unreadable", report studio prints ALL dates (and seems to skip some)...
What I'd like to achieve is
- that the line prints "all points"
- that on the x-axis, for example per yearmonth a value is printed (e.g. 200801, 200802 etcetera) (or if needed per YearQuarter)
How can I achieve that?
A solution that I do NOT prefer is change the query so only per yearmonth or per yearquarter a value exists, since I like to see the line in the lowest detail...
I built a similar chart earlier in highcharts (http://www.highcharts.com/stock/demo/
) (where the x-axis and the graph in total is very cool). I don't think that is possible, but something a bit better looking would be great.