Can i use Level-aware aggregation with a windowCount function?

[WLS-D]

Hello @Shiyan !

Are of the fields you are using in the calculation going to be in your target table visualization?

lastValue() returns VISUAL_CALC_REFERENCE_MISSING

Hi, I got a data set with daily campaign data. All these campaigns have a status, like “active”. I’d like to create a calculated field that returns the latest status (string) value for each campaign. So I tried… lastValue({status}, [{Date} ASC], [{Campaign-Id}] ) Unfortunately, I receive an error as soon as I add the new field to a visual sourceErrorCode: VISUAL_CALC_REFERENCE_MISSING sourceType: SPICE Regards, David