How to create a line with a step change based on date in EazyBI

Lea Williams August 10, 2020

Hi all,

I am working in EazyBI and would like to create a goal line, with a step change. Currently, I have a user defined measure that simply equals 0.7 (or 70%). I would like to update this line to equal 0.7 before 8/1/2020 and 0.8 after 8/1/2020. (Basically, I updated my goal from 70% to 80%.

 

Does anyone know how to achieve this in EazyBI?

Thanks

Lea

1 answer

0 votes
Janis Plume _eazyBI_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
August 18, 2020

Hi,

 

You can create a custom measure checking the period of the Time dimension in the report.

The formula could be like this:

CASE WHEN
DateBeforePeriodEnd(
DateParse("01 Aug 2020"),[Time].CurrentHierarchyMember
)
THEN
0.8
ELSE
0.7
END

 

Then your report looks like this:

GoalChange.png

There can be other ways how to do that. You might wish to check the functions for date and time processing in eazyBI:

https://docs.eazybi.com/eazybi/analyze-and-visualize/calculated-measures-and-members/mdx-function-reference#MDXFunctionReference-DateFunctions

https://docs.eazybi.com/eazybi/analyze-and-visualize/calculated-measures-and-members/mdx-function-reference#MDXFunctionReference-LogicalFunctions

Kindly,

Janis, eazyBI support

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events