Traffic lights gauge for data refresh indicator

[#1]

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

[vikasmahajan]

see this

Pivot table with a traffic light field

[Anil_Babu_Samineni]

Try to take gauge expression Like below

=If(Today() = ReloadTime(), Green(), If(Today() = ReloadTime()-1, Amber(), If(Today() = ReloadTime()-2, Red(), Yellow())))

[#4]

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

[#5]

Hi Vikas ,

i need to show traffic lights to indicate data refresh date not in pivot table.

Thanks,

Nani

[tamilarasu]

Hi Nani,

Like attached?

[#7]

Hi Nagaraj,

i am not able to open the application. can you pls explain the logic that you have incorporated?

Thanks,

Nani

[tamilarasu · Accepted solution]

Hi Nani,

Kindly check the scrrenshots in the below word document.

[#9]

Thanks Nagaraj. Exactly that is what i am looking for.

Regards,

Nani