Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Is there a way to create a gantt diagram with more than one value for each dimension?
My data looks like:
ID | Type | Subtype | From | To |
---|---|---|---|---|
A | A1 | A11 | 01.01.2018 | 13.01.2018 |
A | A1 | A12 | 05.01.2018 | 10.01.2018 |
A | A2 | A21 | 15.12.2017 | 15.01.2018 |
A | A3 | A31 | 03.11.2017 | 18.12.2017 |
A | B4 | B11 | 24.11.2017 | 25.11.2017 |
... | ... | ... | ... | ... |
In my chart I want to show the ID, the type and the calendar info. I followed this example: How to create a Gantt chart using a Pivot table, however it only works for one value per dimension (A1 will not be shown, since it is the aggregation of A11 and A12 subtypes).
My goal:
What I have:
I appreciate any ideas or suggestions?
What is the expression that you use?
I forgot to mention I am using a MasterCalendar. The dimensions are ID, Type, Year, Month, Day. The expression is:
=if([Zeitraum Von]=[Zeitraum Bis],'⚡',
if(date(ReferenceDate)=date(Today()),'T',
if([Zeitraum Von] = ReferenceDate,'⚐',
if([Zeitraum Bis] = ReferenceDate,'⚑',
if([Zeitraum Bis]-ReferenceDate+1>0,'⚊')))))
What is reference date here?
ReferenceDate was defined in the MasterCalendar, it´s a date i.e. 2017.12.04
Are you doing an interval match between your data and master calendar?
No, I have an Events_Dates table:
Events_x_Dates:
Load ID, Type, Subtype, Date(From + IterNo()-1) as ReferenceDate
Resident Events
While IterNo() <= To - From + 1 ;