Difference between the number of days user client has logged into the website

Question

Difference between the number of days user has logged in since his last but one recent visit and the recent visit. If it is greater than 90 days, then mark the user in red.

Answer 1

Hi Rajesh,

Use below code - 

Column 4 = IF(DATEDIFF(LASTDATE[LIDate].[Date]),LASTDATE( LODate].[Date],DAY)>90,"#ff0000","#ffffff")

Now add conditional formating under Format tab and select background color.

Now select Field value under format by,

Click ok.

For ex: 

Hope it helps you.