Interval Issue - Not working when grouping numbers
I have a table with the following in formation:
I am using this interval function to convert Duration into hh:mm - =Interval(Interval#([Duration (seconds)], 's'), 'hh:mm')
However, when i remove Duration (seconds) column from the table chart I expect Break to show as a line with an interval of '00:45' but i just get a blank line. The other 2 'non grouped' columns work as expected.