I want to create a timechart as trellis with stacked bars.
I have the following columns:
Workdate, Duration, BookingType, LoginName
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).
|timechart sum(Duration) as Total by BookingType
Do you have ideas on how to solve it?
chart sum(Duration) by BookingType, LoginName
I wouldn't use Trellis because of how you want your chart stacked.
thank you for your respond, but it is a requirement to use trellis (to have a chart like this, splitted by LoginName). I think timechart is a good way, but perhaps I have to do some extra work before or after it