Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
The ticket dataset contains created date and solved date. There's also a cast version of both as createdmonth and solvedmonth. What's the easiest way to display created amounts, solved amounts (as bars) and difference of these (as line) on the same chart.
The issue is with the x-axis. I'm having trouble of setting the x-asis to a "general" monthly period (YYYYMM) where the Created and Solved amounts would bind (CreatedPeriod/SolvedPeriod).
the combo chart should do.
is this what you are asking?
Nope, the issue is with the x-axis. I'm having trouble of setting the x-asis to a "general" monthly period (YYYYMM) where the Created and Solved amounts would bind (CreatedPeriod/SolvedPeriod).
both date will need to be in the same field. try 'crosstable' load. which will accomplish this. then x axis can be on this new field.