Forum Discussion
Non Dev Chart
Hi Anonymous ,
Yes, the measure counts the closed tickets. Because there an active relationship between date and create date.
Not very clear about your data model, I used date hierarchy Year and Month as axis.
I'll share my sample data with you. please check the attached file.
Best Regards,
Jay
Hi Himanshu do you have a date table?
what you need to do is create a date table, link both dates to that date table.
The first date will be the active relationship denoted by an unbroken line and you can create your measure easily by, by default this will be the first date you link
no of tickets by open date = calculate(countrows(tablename))
for the second date you link which will be the closed date the relationship to the date table will have a dotted line (please note the first date you link will be the active so link open date first)
the dotted line means this is an inactive relationship which you will need to activate with your measure.
no of tickets by closed date = calculate(countrows(tablename), userelationship(closeddate, date))
let me know if you have any questions
I have created the below two measures as suggested: