Get Free Trial

How to analize two date columns in one dimension

Ignacio Chertcoff 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?

2 answers

Mykhailo Halaida Mykhailo Halaida Flexmonster 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:
Please let us know if this helps.
Best regards,

Ignacio Chertcoff February 9, 2020

Hi Mykhailo, interesting approach, it could work.
Thanks, Regards,

Please login or Register to Submit Answer