Hi, I’m having trouble creating a dashboard that shows the priority value of a task in each quarter.
I need to figure out how to display tasks that have had their priority change over time - I need to show this on a graph of quarter - priority in that quarter
It would be great to show it with a line/column to show the priority level in each quarter from the time the task was created until the end of time.
x-axis - time expressed in quarterly intervals. The y-axis is the priority value (blocker, critical, major, regular, minor). The lines are the tasks that have this priority changed, I tried to create a measure that would meet this condition.
I will also attach a screenshot of the dashboard that I got.
I ran into the following problems:
- The dates go from earlier to older, I would like to see the history in reverse - what priority the task had in the beginning and what priority it has now
- This line connects all tasks (Priority changed date), it is necessary that the line connects only points within one task, but it connects all tasks. That is, in QI-4812 it connected only three of its points and did not go to QI-4814 to connect 3 December 2024 and so on for all tasks.
- Sorting (order by on measure) for the first case does not help - the current formatting goes away and it becomes impossible to read the chart
I used these measures to create my report:
CASE WHEN
[Measures].[Transitions to] > 0
THEN
[Priority].CurrentHierarchyMember.Name
END
TimestampToDate(
(
[Measures].[Transition to last timestamp],
[Transition Field].[Priority],
[Priority].CurrentHierarchyMember,
[Time].CurrentHierarchy.DefaultMember
)
)
Colleagues, please help me! Tell me how to implement the outline variant or tell me what I need to do to solve problems with my current variant, please!
