Stacked Bar Combo chart with rolling avg for each value of group/color for bars field

Q&A
, ,
1

image
image1054×1254 131 KB

I am trying to create a rolling average line in a combo chart that shows the rolling average of a metric for each value of a group/color field.

Specifically, I have the following calculated field definition for the rolling average: windowAvg( sum(count), [bucketTimestampLocal ASC], 2, 0, [{ranked_provisioner_name}] )

However, I receive the following error when applying this calculation under Lines (field well):

VISUAL_CALC_REFERENCE_MISSING

Is it possible to calculate a rolling average in Quick Sight for each distinct value of the group/color field (in this case, ranked_provisioner_name)? If so, how should the calculation be correctly defined to avoid this error?

Thank you in advance for any guidance or suggestions.

2

Hello @ayush , welcome to the Quick Sight community!

VISUAL_CALC_REFERENCE_MISSING means that your visual is missing a field it expects because of your calculation. However, based on your screenshots it looks like you have all of the fields from your calculation in the visual.

I have two initial thoughts: 1) The stacked bar chart combo line can’t support that many values or 2) one of your field (count, bucketTimestampLocal, and ranked_provisioner_name) is calculated and exists both on the dataset layer and the analysis layer meaning you could be calculating your new field on a different field than what is in your visual.

My guess is that it’s most likely the first option.