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
You will need to add both date and campaign id to the visual to make this work.
@dbb1 - As @Max mentioned, you need to somehow add those to fields in your visual. If you are suing Table visual, you can easily add them and Hide them as well if those are not required to be shown in the visual. If you are working with other visual (e.g. KPI Visual) this could be tricky and could pose a bottleneck in getting that lastValue calculation working unfortunately!
