Forum Discussion

mattmca's avatar
mattmca
Cloud Apps
01-26-2022
Solved

Dashboard expression for 2 events happening in time period

Hello, I've been struggling to get a dashboard expression to work correctly. I have daily data for customer visits to a website. In this data, I have a column called "UserFirstLogin" which has a va...
  • harikm007's avatar
    01-27-2022

    Hello mattmca ,

    Check whether this formula gives you expected result:

    sum([UserID], 
        case 
        when max([UserInvited]) = 1 and max([UserFirstLogin]) = 1
        	then 1
        	else 0
        end)

    -Hari