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
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:
There can be other ways how to do that. You might wish to check the functions for date and time processing in eazyBI:
Kindly,
Janis, eazyBI support
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.