runningsum function limitations

Question

Hi team, I just finished QS training and have a question regarding the runningsum function.

I know there’s a limitation of using it on top of sumover , can runningsum not be used on any LAC-A functions?

For example, the below calculation doesn’t give a subtotal value (while the distinct_count function works):

Calc - Dist:  runningSum(
     distinct_count({uid[wh_monthly_facts]}),
     [{lifeline_months_tenure} ASC],
     [{Approval_Month}]
)

https://docs.aws.amazon.com/quicksight/latest/user/level-aware-calculations.html

Answer

Hello,

In this context, I would like to inform you that I had replicated the scenario with a sample data - 'SaaS-Sales.csv' from the below link

[+] https://ee-assets-prod-us-east-1.s3.amazonaws.com/modules/337d5d05acc64a6fa37bcba6b921071c/v1/SaaS-Sales.csv

I first loaded my sample data in QuickSight and created the below distinct count function. Please find the logic for the same below.

Column name : My_Distinct_calculation -
distinct_count({Order Date})

I further tried using runningSum() function and created the below calculated field.

Column name :My_Running_Sum -
runningSum
(
 distinct_count({Order Date}),
 [{City} ASC],
 [Country]
)

Once I created the above two fields, assuming that you are using the "Pivot Table" as you have mentioned "subtotals" in your question, I went ahead and added all the columns in the field wells and further I could observe that the subtotals is shown for the column "My_Distinct_calculation" but not for the "My_Running_Sum" column. Please find the screenshot of my replication below.

Therefore upon further analyzing I could not completely understand the usecase of calculating subtotals of the running sum of the column therefore it would be difficult to provide any workaround at this point of time if there are any.

That being said, if you would like to further know about the above please raise a support case with AWS for further information along with the sample dataset to replicate. If a support case has already been created please be assured that we will get back to you and assist you in the best way possible.

Reference:

[+] https://docs.aws.amazon.com/quicksight/latest/user/supported-applications.html

Attachment :

![Image](/media/postImages/original/IMmRcHiIvuRiWZRjujnAf5Ag)

runningsum function limitations

Relevant content