Forum Discussion
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 Non-dev tickets in my report.
Now I want to create a graph like shown below, how can I proceed with it? I'm confused like how will I show the months in common for the created and closed tickets where as I have different dates for both.
Total number of Non DEv tickets
Created Date
Closed Date
I have these 3 column available in my report.
Expected Chart:
Regards,
Himanshu
17 Replies
Anonymous , Based on first look, I think you need a common date table and use userealtionship
Refer this blog
Hi amitchandak I have created the common date table and made the relationship also. one active with created date and one inactive with closed date. But confused how to proceed further.
Anonymous , Create measures.
Measure you create will have a filter on the created date and that is active.
Use userelationship(Table[Closed_date], Date[Date]) In calculates to use close date as the date.
In the date table have month year and plot measure against the month year of date table.
Refer to Hire and Termination in my blog.
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:
no of tickets by closed date = calculate(countrows('DAX Date Table'), userelationship('devops-query-spr2'[Closed Date],'DAX Date Table'[Date]))no of tickets by open date = calculate(countrows('DAX Date Table'))But where does my Non-Dev column goes? Sorry but I'm really confused here.How to check my Non-Dev ticket values. For closed and created.I have a calculated Column for non-Dev tickets which gives me 375 ticketsI'm still not able to show the closed and created together. Seperately they are working fine.if you provide some sample date i think it will be much easier to demonstrate (make sure its in text format)
also can you show what result you arae expecting
