Help

Why can't I summarise durations in a chart in a interface?

Topic Labels: Data Interface Designer
685 3
cancel
Showing results for 
Search instead for 
Did you mean: 

I've been scratching my head to why this is not possible, and I still have a feeling I'm doing something wrong but I can't figure out what.

I have a bunch of time logs that has been logged over multiple years. Every log has an item linked to them which has a rollup that assign every time log into a category based on the item.

My data looks like this:

Screenshot 2023-08-25 at 15.37.48.png

 In the interface designer I want a bar chart that summarises all this data.

The X-axis should be the years, then the Y-axis should be the amount of time spent.

Each bar should be a total of time spend in that year. Then each bar should further be divide into the rollup categories.

I've set the sourse to Costing tab, and the X-axis to YearsI've set the sourse to Costing tab, and the X-axis to Years

 

The field I'm summarising is the Time field - which is a duration input fieldThe field I'm summarising is the Time field - which is a duration input field

 

In the aggregate I can't choose SumIn the aggregate I can't choose Sum

 

However when I try to summarise the inputted times, every option except from distinct is greyed out - why can I not choose fx the Sum or the Average, which I find weird as a Time input surely is just a bunch of numbers, and its not being computed in a formular field?

 

 

 

 

3 Replies 3
Maya_Bialik
5 - Automation Enthusiast
5 - Automation Enthusiast

Same issue

jessica
4 - Data Explorer
4 - Data Explorer

Same issue

Marc_Weldon
4 - Data Explorer
4 - Data Explorer

Worked this one out. It's because the field you're trying to summarise is a duration, not a number. If you create a new formula field to make it a number (we use this a lot for time fields, just call the column the same thing and add 'DISPLAY' to the field name), by using the field *3600 (as duration fields are stored as number of seconds) then you have a normal number to report on, and then should be able to summarise with SUM etc.