My events have the following fields
[timestamp, instrument_name, event_type, …]
I have the following definition for a calculated field “latestInstrumentStatus”
firstValue
(
{event_type},
[timestamp DESC ],
[{instrument_name}]
)
The Idea is to get the latest “event_type” for each “instrument_name” and display it in a tabular format like below
InstrumentName | Latest Status |
---|---|
ABC | OK |
DEF | ERROR |
The table display(Group by column - InstrumentName, Value - LatestInstrumentStatus) visual tries to apply some grouping for the latestInstrumentStatus and errors out with the error message “VISUAL_CALC_REFERENCE_MISSING”.
Any suggestions on how to achieve this in QuickSight appreciated.