Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
I have one pivot table with the background color logic as below
if(Coordinator_latest_status='SUCCEEDED',Green(255),if(Coordinator_latest_status='FAILED',Red(255),if(Coordinator_latest_status='WAITING',Yellow(255),Blue(255))))
But it is not working as expected .
I need to get the same logic based on the last ran time(time stamp) of job_Started_ts because some of the jobs will run multiple times in the same day. It should be based on the last refresh of the app like as below
Coordinator_job_name | Coordinator_latest_status | job_Started_ts | job_Ended_ts | |
ClickSteamMapping | SUCCEEDED | SUCCEEDED | 12/18/2019 3:00 | 12/18/2019 3:02 |
ClickSteamMapping | SUCCEEDED | SUCCEEDED | 12/18/2019 11:00 | 12/18/2019 11:03 |
ClickSteamMapping | SUCCEEDED | SUCCEEDED | 12/18/2019 12:00 | 12/18/2019 12:01 |
In the above example it has the latest date with time stamp as 3:00 pm when the app refreshes at 3 pm then it should show as green as the status is succeeded if not it should show as per the above logic.
Here i am attaching the qvf and sample data for reference.
Can anyone help me on this.
Thanks,
Ramya.