“Show totals” is not showing the totals for all the calculated fields on this table. I want to see the totals for each specific calculated field over any selected time period on the filter.
1 Like
Hello @apark173, welcome to the QuickSight community!
Something to consider here, when utilizing calculated fields, it can often complicate the column to a point that QuickSight is unable to determine a Total value. If you are utilizing LAC-W aggregations with partition fields, it will not return a total. Are you able to provide more information about the calculated field you are utilizing? An alternative option, if the calculation cannot be altered, would be to set a KPI that would display totals and creating a new calculation to sum the values you are wanting.
Another thing you can check would be if that field currently shows an aggregation on the Total calculation. Click the 3 dots on the calculated field in question within the visual field well, and look for an option labelled as Total:. If that appears, you can try altering the selected option to see if that resolves your issue.
Let me know if this helps! I can guide you further with more information.
1 Like
Hello DylanM! thank you for your response, it seems as though these calculated fields are not actually calculated fields but data from the query itself, does this mean that it is probably a LAC-W aggregation?
1 Like
Hello @apark173, I see the issue. You have it listed in your Group By, rather than in a value field. If you add it to your value field well instead, you should be able to return a value in the totals.
1 Like
Hello @DylanM when I put my fields in Group By, rather in a value field I am able to get the accurate daily values when I select “Aggregate: Average”. However this makes it so that when I have “totals” pinned, it shows the average of the viewable totals rather than the sum of the viewable totals.
Hello @apark173, since you are viewing on a table, you can select the 3 dots on the field and alter the aggregation of the total to be different than the aggregation for the field. Once you select the 3 dots, about halfway through the list you will see something like Totals: defalut, select that and switch it to sum. Then you should start getting the values you are looking for.