deeejay

Tableau - LOOKUP() Examples

Apr 11th, 2016
366
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.54 KB | None | 0 0
  1. Get the previous event_start_dt_tm grouped by account number, event, and day
  2. [_PREVIOUS_EVENT_START_DT_TM]
  3. ===
  4. IF
  5. ATTR([FIN]) = LOOKUP(ATTR([FIN]), -1)
  6. AND ATTR([EVENT_CD]) = LOOKUP(ATTR([EVENT_CD]), -1)
  7. AND ATTR(DATETRUNC('day', [EVENT_START_DT_TM])) = LOOKUP(ATTR(DATETRUNC('day', [EVENT_START_DT_TM])), -1)
  8. THEN LOOKUP(ATTR([EVENT_START_DT_TM]), -1)
  9. ELSE NULL
  10. END
  11.  
  12. Calculate event_start_dt_tm difference in minutes
  13. [_LKP_EVENT_START_MINS]
  14. ===
  15. DATEDIFF('minute',[_PREVIOUS_EVENT_START_DT_TM],ATTR([EVENT_START_DT_TM]))
Advertisement
Add Comment
Please, Sign In to add comment