I have a table containing the load of a start- and an endtime, aswell as the duration.
TIME(STARTTS, 'hh:mm:ss') AS StartTime,
TIME(ENDTS, 'hh:mm:ss') AS EndTime,
INTERVAL#(TIME(ENDTS, 'hh:mm:ss') - TIME(STARTTS, 'hh:mm:ss'), 'hh:mm:ss') AS Duration,
The data is supposed to be displayed in a bar-chart.
The dimension is a cyclic group which allows you to switch between sortation of the data by year, month, quarter, week, day, hour and minute.
The expression should be the duration of an entry.
Now the problem:
I want to split an entry if the timespan oversteps an used time-interval.
For example:
One entry has
Starttime: 09:58:04
Endtime: 10:03:12
Now we choose e.g. "sortation by hour".
It would show 5 minutes and 8 secounds at hour 9.
But the desired resultat is, that 1 minute and 54 seconds are displayed at hour 9 and 3 minutes and 12 seconds are displayed at hour 10.
Does anyone know a solution for my problem?
I hope you understand the scenario I tried to explain 😕
Thanking you in anticipation!