Group aggregate on a slice not available: I have a table view “Staff Times” with grouped by name, group aggregate is sum of total hours.
This works fine.
I created a slice to view only last months times and set the table up exactly as the main table, grouped by name.
But I cannot group aggregate by total hours.
It’s not an option presented to me.
I only have count as an option.
[Total Hours] is a duration column type, is not hidden, is included in the slice, is a group aggregate option in the main table, is not a group aggregate option on the slice using row filter condition month([Date])=month(today())-1.
Are certain aggregates not available on slices, or am I missing something?