I draw a chart with combining Gantt and bar.
Little bit complicated to differentiate one time cost.
Consolidate One time and annual.
[Annual Cost 2] // Need to handle Null value with ZN
zn([Annual Cost])+zn([One Time])
Gant chart is consist of start point and size.
Then start point is Running sum and size should be "Negative to the point of last period's running_sum" excluding first plot.
[Annual Cost 2 size]
if index()=1 then -sum([Annual Cost 2]) else
-(zn(running_sum(sum([Annual Cost 2])))-window_sum(sum([Annual Cost 2]),first(),-1))
I don't understand very well about the number of license though.
Server vs Online_SM_10.0.twbx 41.3 KB