Forum Discussion
JIRA Created vs Resolved
Hello,
After multiple tests and many researches, I appeal to you.
I extracted JIRA data in excel format and use this data on power bi.
My last problem is to create a graph that compares tickets created and tickets solved like on JIRA.
I thought I understood that it was necessary to create a date table, link the 2 tables and use the elements of the date table to compare the 2 fields.
I consulted the few topics on this forum where some had the same problem as me but I don't know why, I'm the only one for whom it doesn't work, the following topics:
- https://community.powerbi.com/t5/Desktop/Trend-Created-Vs-Resolved/m-p/1667582
- https://community.powerbi.com/t5/Desktop/Jira-Dashboard-Created-vs-Resolved/m-p/1770615
- https://community.powerbi.com/t5/Desktop/Count-Weekly-Created-Resolved-tickets/m-p/806946
My last attempt is made in this direction:
- Creation of a date table
- Formatting created and resolved fields
(Created1 = DATE(Day(..),MONTH(...),YEAR(...)) - One-to-many link with the 2 previous fields with the date table (one active and one inactive)
- Axis: Date and values Created1 and Resolved1
Either the graph displayed nothing or it displayed a total with marked (empty) in the x axis
The expected result :
The result obtained :
Bests Regards
1 Reply
- amitchandakSuper User
Anonymous , refer if the two attached files can help on a similar topic
or