Quality index for month

Questions & Answers
1

hi,
thanks to the link How to use start date custom field as Time? I created a similar report, we need to create a Quality index, with the number of days to reach in the month.
we used the Stories in jira and the Value field indicates the number of days while with Start date and end date the time range is indicated. In the stories we have a “Category Type” field in which we identified the Factory. In the report in the rows we inserted Category Type and Time while as Measures we created a new calculated measure called Forecast Days.
I thought of creating a new calculated measure, could you help me?

image

Best regards, Tiziano

Quality Index
Feb Factory1 100
Mar Factory1 90
Apr Factory1 100
May Factory1 80
Jun Factory1 80
Jul Factory1 80
Aug Factory1 50
Sep Factory1 80
Oct Factory1 80
Nov Factory1 80
Dec Factory1 60
Feb Factory2 95
Mar Factory2 92
Apr Factory2 105
May Factory2 80
Jun Factory2 80
Jul Factory2 80
Aug Factory2 50
Sep Factory2 80
Oct Factory2 80
Nov Factory2 80
Dec Factory2 60
2

Hi, I’m not sure I’ve found the best solution, but this works.
CASE WHEN [Category Type].CurrentMember.Name = "Factory1" AND [Time].CurrentMember.name MATCHES "Oct 2024" THEN 80 else CASE WHEN [Category Type].CurrentMember.Name = "Factory1" AND [Time].CurrentMember .name MATCHES "Nov 2024" THEN 80 else CASE WHEN [Category Type].CurrentMember.Name = "Factory1" AND [Time].CurrentMember.name MATCHES "Dec 2024" THEN 60 else 0 END END END