Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Non Dev Chart

Hi All,   I have a situation here and its confusing for me.   I have two columns in my report i.e Created Date and Closed Date and I have calculated column where i have the distinct count of the ...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
5 years ago

amitchandak can you please help in the measure creation.

 

As per my understanding, i'll be needing 2 measures, one for Created Date and other one for Closed date but i'm not able to get the correct result.

 

Kindly advice what measures to use.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

When using the month year from my date table it is not showing the months when the relationship is active. Also, when i make it inactive it displays data month wise but it seems incorrect.

 

 

 

 

 

this is when relationship is inactive: