Dear visitor, despite the COVID-19 outbreak, our team continues operating at full speed.

Also, here is the form where you can apply for a special discount and we will contact you with possible options. Stay safe and continue achieving your business goals.

Fill the form
Get Free Trial
Get Free Trial

How to analize two date columns in one dimension

Resolved
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

Public
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: https://jsfiddle.net/flexmonster/sq7um9r4/
 
Please let us know if this helps.
 
Best regards,
Mykhailo

Public
Ignacio Chertcoff February 9, 2020

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

Please login or Register to Submit Answer