Jira date table and Created vs closed table

[bzagata]

I am making a dashboard for Jira. I have multiple reports on one page and want to set it up with a slicer to filter by relative date. Most of the tables use the created column in the jiraissue table, except for my Created vs Resolved table, which uses the changegroup table with changeitem.newstring filtered to show only ticket closed dates, along with the created column from jiraissue to show the date a ticket was created. The Created vs Resolved table will show tickets created before the relative date in the slicer or not show all the closed tickets in a day when using jiraissue.created. I have tried to make a date table but have not been successful. Does anyone have a way to filter so I can show only the created tickets with a relative date slicer that also shows all tickets closed in that time frame, even if the ticket was created before the time frame or just the best way to create a created vs closed chart with changegroup, changeitem, and jiraissue table?

[danextian · Accepted solution]

Hi @bzagata 

If you want to show the tickets within the a date range based on either creation or resolution date, use USERELATIONSHIP to invoke an inactive relationship in a measure.

Please see the attached pbix.

If this isn't what you're looking form please provide a workable sample data (not an image because who wants to be manually typing data), your expected result from the same sample data and your reasoning behind. You may post a link to Excel or a sanitized copy of your PBIX stored in the cloud.

[bzagata]

Thank you for the help, it took me a few trys but I got it work using your example