Hi!
I have created two running sums - which don’t use the same date value column, as the reference; however both are set to “DD” in aggregation.
Let’s name them RS1 and RS2
- Now, I want to depict %RS1 by a certain date column in the data by Day as a line trend.
where %RS1 = RS1/RS2 - On trying point 1, Quicksight gives the following error:
What to be done in the circumstance?
Error:
Table attribute calculation reference(s) are missing in the field walls<<<<
region: | ap-south-1 |
---|---|
timestamp: | 1671537477189 |
requestId: | a0d7b6a5-0a58-4013-9ff5-2c0eaf841feb |
sourceErrorCode: | VISUAL_CALC_REFERENCE_MISSING |
sourceType: | SPICE |