Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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:

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