Creating Gantt Chart based on Custom-Field

Questions & Answers
1

Hi All,

i am new to eazybi and i would like to create a gantt chart with the following characteristics:

Based on a user defined calculated member called “Integration release” which is either empty or has a three digit value, i want to create a new calculated member formula called “Integration release start date” which - based on the “Integration Release” - assigns a dedicated date to the calculated member “Integration release start date”. The “Integration release start date” shall be the input for my gantt chart.

This is currently my formula for “Integration release start date”:

[Measures].[Integration release start date] =
CASE WHEN [Integration release].CurrentHierarchyMember.Name = “290”
THEN DateParse(“4 JUL 2024”) END

CASE WHEN [Integration release].CurrentHierarchyMember.Name = “300”
THEN DateParse(“29 AUG 2024”) END

CASE WHEN [Integration release].CurrentHierarchyMember.Name = “310”
THEN DateParse(“26 SEP 2024”)END

CASE WHEN [Integration release].CurrentHierarchyMember.Name = “330”
THEN DateParse(“24 OKT 2024”) END

Unfortunaltely all values are currently set to 4 JUL 2024 (even though for the members, which do not even have 290 as Integration release ?

Thank you in advance for you support.
BR
Peter

2

Hi @Peter05
Welcome to the eazyBI Community!

When you have multiple case statements for the same field, I recommend trying the below formula instead and checking if it returns the expected results?

CASE
[Integration release].CurrentMember.Name
WHEN "290" THEN DateParse("4 JUL 2024")
WHEN "300" THEN DateParse("29 AUG 2024")
WHEN "310" THEN DateParse("26 SEP 2024")
WHEN "330" THEN DateParse("24 OCT 2024")
END

Best wishes,

Elita from support@eazybi.com

3

Hi Elita,
thanks a lot for your support - that helped a lot.
Besides the dependency on the Integration release - i would like to add a dependency to a specific label:

[Measures].[Custom Start Date] =
CASE
[Issue].CurrentHierarchyMember.Get(‘Integration-Release’)
WHEN “330” THEN
CASE [Label].CurrentHierarchyMember.Name
WHEN “S” THEN DateParse(“01 JAN 2024”)
WHEN “M” THEN DateParse(“01 FEB 2024”)
WHEN “XL” THEN DateParse(“01 MAR 2024”)
WHEN “2XL” THEN DateParse(“01 APR 2024”)
ELSE DateParse(“01 MAY 2024”) END
WHEN “380” THEN
DateParse(“01 SEP 2023”) END
END

Unfortunately, my mentioned Calculated Member “Custom Start Date” always returns 01. May 2024 for Integration Release 330 - even though it is labled with “2XL”.
What am i doing wrong? Why is my code not considering the label ?
Thank you in advance.
BR
Peter