For running sum column, it is correct for the value when I open the collapse but the data does not sum correctly for collapse value. Check the red circle on “Outflow” Collapse value. It should be 2 at May7, 2023.
Here is my caluclations:
runningSum
(
sum({metrics_value}),
[{report_time_value} ASC],
[{region_code},{metric_name},{time_aggregation},marketplace,program]
)
you can change the total from default to sum from here: check the screen shot:
Hi, Thanks for your help, I changed it while it still not correct. For May 28, 2023, it should be (2+44+112+2) for “Metric_value(aggregated)” value while it is 12 instead. The value are correct for dates before May 28, 2023
Hi Quicksight team,
Any updates on this one?
Hi @fangfgao, in case you need further assistance with your problem, please create a sample dashboard with sample dataset showing your problem state using Arena and post it here. (Details on using Arena can be found here - QuickSight Arena
I would recommend filing a case with AWS Support where we can dive into the details so that we can help you further. Here are the steps to open a support case. If your company has someone who manages your AWS account, you might not have direct access to AWS Support and will need to raise an internal ticket to your IT team or whomever manages your AWS account. They should be able to open an AWS Support case on your behalf. Hope this helps!
