VISUAL_CALC_REFERENCE_MISSING for the lag() function

Question & Answer
, ,
1

I want to create a sankey diagram. from the events i had in event_type. I have a calculated field to get the first previous event of the same profile_id.

ifelse(
  isNull(
    lag(
      {event_type},
      [{created_at} DESC],
      1,
      [{profile_id}]
    )
  ),
  'End',
    lag(
      {event_type},
      [{created_at} DESC],
      1,
      [{profile_id}]
    )
)

This formula finds the previous event type for each profile_id , ordered by creation time or else it will be ‘END’.
I have all the fields in the dataset. The profile_id and the event_type are strings and created_at is a date type. I’m not sure why I’m getting the error. I can able to create the calculated field but if i tried use that that’s the error I’m getting. is there a way around?. Instead of creating a new dataset just for this visual?

2

Hi @Yogini and welcome to the QuickSight community!
Whenever you receive the ‘visual_calc_reference_missing’ error, it’s because you’re referencing a field in your calculation that is not being used in your visual, but needs to be. You may run in to this with various visuals. My thought, regarding your situation, is this would be in reference to the date field(s) being used with a sankey diagram. Sankey visuals still have a fair amount of limitations in QuickSight.

How do you envision your visual looking/conveying information, maybe a different visual could be used in place with these fields?

1 Like
3

Hi @Yogini,
It’s been awhile since we last heard from you; do you have any additional questions or were you able to find a work around for your case?

If we do not hear back within the next 3 business days, I’ll go ahead and close out this topic.

Thank you!

4

Hi @Yogini,
Since we haven’t heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new topic in the community and link this discussion for any relevant information that may be needed.

Thank you!