asked on February 5, 2020
Hi, we have the following dataset (something similar to tickets) to analyze:
Number, Description, Reported Date, Closed Date
1, 'ticket description', '2/10/2010', '5/11/2010'
2, 'ticket description', '5/10/2010', '5/12/2010'
3, 'ticket description', '2/11/2010', '5/12/2010'
4, 'ticket description', '3/11/2010', '13/1/2011'
And the report should be:
Year 2010 2011
Month 10 11 12 1
---------------------------
Reported (qty) 2 2
Closed (qty) 1 2 1
Is this possible?
⋅ February 7, 2020
Hi Ignacio,
Thank you for writing to us.
At the moment it is not possible to group two date fields in one dimension in the grid.
Therefore, we would suggest rearranging your input data in a way that both date types are contained in one field. This would allow you to display the data in the desired way.
We've prepared a JSFiddle example to demonstrate a potential approach to rearranging the data: https://jsfiddle.net/flexmonster/sq7um9r4/
Please let us know if this helps.
Best regards,
Mykhailo
⋅ February 9, 2020
Hi Mykhailo, interesting approach, it could work.
Thanks, Regards,
Ignacio.
