Multiple static values- how to pass

Questions & Answers
,
1

I want to hardcode/ pass multiple static values to each sprint. How do I do it? When I have [Measures.metrics]=1,2,3, etc. It just takes 1(1st value) and inserts it across all sprints. Is there a way to pass it as an array?

2

Hi,

The workaround for providing arrays of values would need to hardcode the sprint names in the formula:

CASE [Sprint].CurrentMember.Name
WHEN "D2 Sprint 1" THEN 1
WHEN "D2 Sprint 2" THEN 2
WHEN "D2 Sprint 3" THEN 3
END

image
image1308×842 68 KB

Alternatively, you can use the additional data import to have additional measures and properties for the sprint dimension members:
https://docs.eazybi.com/eazybijira/data-import/jira-issues-import/additional-data-import-into-jira-issues-cube

Kindly,
Janis, eazyBI support

3

Thanks for the info. I am trying to calculate backlog readiness and want to predict values for future sprints. What measure should I use to get future sprints.

Also, if I get any negative values in my calculated measures I want to replace it with zero. How should I do it?

4

Hi,

Please, send a request to the support for further guidance on how to calculate the backlog readiness. We need more details on this use case for more precise assistance.

The negative values can be overridden using the IIF function or CASE statement:
https://docs.eazybi.com/eazybi/analyze-and-visualize/calculated-measures-and-members/calculated-measures#Calculatedmeasures-Conditions

Kindly,
Janis, eazyBI support