Day over Day

I have weekday’s data and want to find DOD difference.
Sunday = 1, Monday =2 , Tuesday =3, Wednesday =4, Thursday =5, Friday =6, Saturday =7.

My periodoverperiod calculation is breaking when its Monday as no data is present for Saturday and sunday.
How can i write a calculation so that calculation don’t break.

In the below image Jun26 data must be compared with previous available date i.e. 23rd.

image

Hi @Vivek54 - You can look into using either lag or lead function for your use-case. Reference links below:

  1. Lag - Amazon QuickSight
  2. Lead - Amazon QuickSight

Let us know if this does the trick for you? Thanks.

1 Like