Burn up graph based on week, total number of tickets created and Total number of tickets closed

Hi @Sushi almeda​ . When dealing with ticket data, it is best to re-shape your data into one row per event, with an event being an open or close action. You can use Custom SQL (UNION ALL) or Tableau's union feature to self-union two copies of your ticket data together.

I exported your Jira data into a CSV and joined it with itself:

Then I aliased the auto-generated Table Name field to distinguish the two identical copies:

Then I created a combined Date field that is either the Created date or the Resolution date.

// can't use aliases except in GUI
IF RIGHT([Table Name],1) != "1" THEN [Created]
ELSE [Resolutiondate]
END

Filter on Date to exclude Null and then it's easy to graph what you want.

You can also graph the number of open tickets at any point in the past using this technique. Create a new field called Delta that is either +1 or -1.

IF RIGHT([Table Name],1) != "1" THEN 1 ELSE -1 END

Now you can plot the Running Total of Delta right up to the current week.

I used to analyze a lot of Jira ticket data.