How to lock Time dimension in "Created at" date? Need to sort issues but the Transitions to Status must be unrelated to the date

Questions & Answers
1

I’m checking how many times each issue transitioned to each status.
I tried using Time dimension just to order each Issue, but the Time dimension is affecting the “Transitions to status” measure, so some issues appear in multiple months - because they were created at a certain date, but the transition itself happened in the next month.
I don’t want to COUNT Issues, I want to sort my issues based on the date they were created but I want to get the count of transitions to each status without relating this with time.

All info I found about mentions creating a calculated measure, but that’s because people were interested in the issues count, not just with ordering them… I can’t find anything about how locking which Time dimension you want to focus on just as a sorting asset…

Thanks!

2

Hi @mateus_so,

The proper approach depends on your report setup.

If you do not use the Time dimension at all in your report and you do show individual issues, you might use the issue property “Issue created date” to sort issues.
You might read more about that here - Create reports.

However, if you use the Time dimension to filter and display issues created in different months and you also use Issue dimension in rows to show individual issues, you might create a calculated measure that checks if the issue was created in the specific month and then shows the number of transitions taking place anytime.

The calculated measure might be as follows.

CASE WHEN
-- issue was created in this context
 [Measures].[Issues created]>0
THEN
-- display number of transitions
 ([Measures].[Transitions to status],
--  reseting the Time dimension as that relates elsewhere
  [Time].CurrentHierarchy.DefaultMember)
END

If these still do not help, share more details about your report layout.

Regards,
Oskars / support@eazyBI.com

1 Like