“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.
Hello @apark173, welcome to the Quick Sight community!
Something to consider here, when utilizing calculated fields, it can often complicate the column to a point that Quick Sight 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.
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.
Hello @WLS-DM 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.