[VISUAL_CALC_REFERENCE_MISSING] error on custom calculation in values -- bar Graph

[Sravya]

Hello,

I wanted to have a bar chart/waterfall chart which displays the cumulative sum of the users in Y Axis sorted in an ascending order by month in X-Axis.

I created a calculated field:

runningSum(
sum({users_count}),
[{Month_int} ASC]. – As I cannot use Month Display (String)
)

I wanted to sort the X axis (Months) in an ascending order and rename the X-Axis with (Month-Display) instead if Month_int.

Since, I have used custom calculated field in values - I am unable to change the x-axis as Month_display because in calculated field I have used month_int.

Please suggest on how to rename the x-axis labels with custom calculations in values field.

My another question is to hide/remove the total from the waterfall bar graph as I am already calculating cumulative.

Please help.

Dashboard Link - Cumulative_dash
Analysis Link - QuickSight Arena -- An embedded instance of QuickSight within the QuickSight Community

[duncan]

Hey @Sravya , welcome to the Quick Sight community!

You could use your month_display as the x-axis but sort from an off-field visual in your field well:

[Sravya]

Hey, thanks for replying.
As I have mentioned:
I have used custom calculated field in values - I am unable to change the x-axis as Month_display because in calculated field I have used month_int.

Quicksight is not allowing me to use Month_Display because in the calculated field for cumulative sum, I have used month_int.

I am using bar chart.
The same is happening with waterfall chart.

Also, wante dto check on the de-selecting ‘total’ in waterfall chart.

[duncan]

Hello @Sravya !

I was able to make this work by changing your cumulative count calculation to use month display and then sorted by month_int.

Cumulative dash

[Sravya]

Hello Duncan,

Thanks a lot for replying - I saw the analysis.
Unfortunately, Cumulative SUM for October value is wrong — The sort is happening based on String and not on Month INT

Cumulative SUM for October Month will be 19,486 as per the example.

But as per your analysis link - it is showing 4508.

Please let me know