Create Calculated Measure with "Issues History"

[Ludovic]

Hello,

I would like to create a calculated measure using Issuees History and status.
My objective is to customize the legend name of the field to remplace “Issues history Submitted”, “Issues history Analysed” by “Submitted”, “Analysed”,… So I think that a calculated measure could be used.

I have tried this but it uses the current status (now), but not the status at the concerned date.

( [Measures].[Issues history],
[Status].[Analysed]
)

Thank you,
Ludovic

[nauris.malitis]

Hi @Ludovic

For this, you would need to use the Transition Status dimension that stores the historical status values of the issues: Import issue change history

A formula like this should do the trick:

([Measures].[Issues history],
[Transition Status].[Analysed])

​Best regards,
​Nauris