Calculate the total of a calculated field

Question & Answer
, ,
1

Hi There, I have a calculated field that I’m trying to sum up. The column (time required) that I’m trying to sum is a calculated field that I’m showing the max. So far to find the sum of that field, this is the logic I’m using: sumOver({time_required}, [State, County, City], PRE_AGG), but it’s not giving me the right total. Total should be -420, but I’m getting a value in the thousands.

Is there a better way to construct the logic? Thank you!

quicksight sample
quicksight sample1638×615 57.7 KB

2

Hi @bunmis
maybe you can share a Arena analysis?
You want to have the sum for each activity?
BR

1 Like
3

In case you need further assistance with your problem, please create a sample dashboard with sample dataset showing your problem state using Arena and please create a new post, so we can look at it from a fresh perspective. (Details on using Arena can be found here - QuickSight Arena