Hi,
I want to create a timechart as trellis with stacked bars.
I have the following columns:
Workdate, Duration, BookingType, LoginName
2019-06-03,5,1,User1
2019-06-03,2,2,User1
2019-06-03,1,3,User1
2019-06-03,3,1,User2
2019-06-03,3,2,User2
2019-06-03,2,3,User2
...
My Expectation is to see 2 Charts, one for User1 and one for User2 with a stacked bar for the Workdate 2019-06-01
The Total sum for each is 8, separated by the durations by BookingType
My first approach was to use |timechart sum(Duration) as Total by BookingType , then I get nearly the result I want. But it is not possible to use Trellis (by LoginName).
Do you have ideas on how to solve it?
best regards
Thomas
... View more