Sum option not appearing in Group Aggregate

Hi, there used to be an option to select SUM under UX>View. All I can see are NONE and COUNT. How can I bring that option back?

Here’s what: I want to create a slice that calculates the running total of hours worked that will be used for a chart. I’m not able to figure a simple way to show that properly.

Any advice?

Thanks!

You can see the SUM option if your field is like number, decimal etc. If it’s like text, the app can only count records from the group.

1 Like

Thanks, Aleksi. I do have some fields that are text, but I also included fields with duration in the slice. Would that work?

Unfortunately duration will not work.

2 Likes

OK, will change one of the columns and hope it works! Thank you!

1 Like

You’re welcome