Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Hope all are doing good.
I need help on creating a traffic light gauge chart to indicate data refresh.
If the data refreshed to day i have to display green light and if the data refreshed yesterday i need to display Amber and for before yesterday i need to display red light.
To achieve this I have taken ReloadTime() as expression and i have taken three segments for green and amber and red.
For scale i have considered 0 as min and Today() as Max value.Green lower bound is Today() and for amber lower bound is Today()-1 and 0 is lower bound for red.
But i am not able to achieve the functionality.
Any suggestions are highly appreciated.
Thanks,
Nani
see this
Pivot table with a traffic light field
Try to take gauge expression Like below
=If(Today() = ReloadTime(), Green(), If(Today() = ReloadTime()-1, Amber(), If(Today() = ReloadTime()-2, Red(), Yellow())))
Hi Anil,
Thanks for the response.
If have tried your solution but not able to achieve the functionality. What are the segment boundaries that we need to take.
Thanks,
Nani
Hi Vikas ,
i need to show traffic lights to indicate data refresh date not in pivot table.
Thanks,
Nani
Hi Nani,
Like attached?
Hi Nagaraj,
i am not able to open the application. can you pls explain the logic that you have incorporated?
Thanks,
Nani
Hi Nani,
Kindly check the scrrenshots in the below word document.
Thanks Nagaraj. Exactly that is what i am looking for.
Regards,
Nani