I have a pivot table but I want to see if is possible to include the shift interval as a value instead of the view below
Shinft interval is calculated as
ifelse(
isNull({Shift Start Hour}) or isNull({Shift End Hour}),
"",
concat(
{Shift Start Hour},
" - ",
{Shift End Hour}
)
)
Where the shift start hour and shift end hour are something like
ifelse(
isNull({ShiftStartTime_TZ}),
"",
concat(
toString(extract('HH', {ShiftStartTime_TZ})),
":",
ifelse(
extract('MI', {ShiftStartTime_TZ}) < 10,
concat("0", toString(extract('MI', {ShiftStartTime_TZ}))),
toString(extract('MI', {ShiftStartTime_TZ}))
)
)
)
I can do something similar with a time field so I want something similar to the following but with those shift interval if possible
in this case the time use this calculation, where date_diff is the difference in seconds of two dates
ifelse(isNull(max({Datediff_MI})),"",
concat(toString(floor(max({Datediff_MI})/3600)),":",
right(concat("00",toString(floor((max({Datediff_MI})/60))-
(floor(max({Datediff_MI})/3600)*60))),2),":",
right(concat("00",toString(floor(max({Datediff_MI})%60))),2)))