Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dears.
I want to create a table with the data below:
Ticket | Type | Start Date | Finished Date |
1 | AA | 25/04/2016 | |
2 | BB | 25/04/2016 | |
3 | CC | 25/04/2016 | |
4 | BB | 25/04/2016 | |
5 | BB | 26/04/2016 | |
6 | BB | 26/04/2016 | |
7 | BB | 26/04/2016 | 25/04/2016 |
8 | BB | 27/04/2016 | |
9 | BB | 27/04/2016 | 25/04/2016 |
10 | CC | 27/04/2016 | |
11 | BB | 28/04/2016 | 25/04/2016 |
12 | CC | 28/04/2016 | 25/04/2016 |
My idea is that in only one chart I can show how many tickets were created according to the "Start Date" field in accumulative way, and additional show how many tickets were finished according to the "Finished Date" field also in accumulative way, at the end the result is something like this:
Where the blue line is the chart of start date, and the red one is the chart of the finished date.
Is possible?
Thanks in advance.
BR
It's possible but you need to transform you data so that you have only one date field instead of two.
CrossTable([Date Type], Date,2)
LOAD
Ticket,
Type,
[Start Date],
[Finished Date]
FROM
....source
;
You can then create a line chart with Date and [Date Type] as dimensions.