Sum option not appearing in Group Aggregate

[Zee_W]

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!

[Aleksi]

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.

[Zee_W]

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

[Aleksi]

Unfortunately duration will not work.

[Zee_W]

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

[Aleksi]

You’re welcome