Forum Discussion
Equipment Running or shutdown
Hi Fati99
As your data has a single value you can either replace the value in the query editor to Running/shut down and use the colour formatting. Attaching the sample file for your reference.
Super UserHi Fati99
As your data has a single value you can either replace the value in the query editor to Running/shut down and use the colour formatting. Attaching the sample file for your reference.
So the only visual I can use would be the table visual?
I wanted to use a nicer visual to show if the pump is running or not in a certain time.
- Anand24
Hi Fati99 ,
I guess the best and simplest way to represent would be through table visualization with conditional formatting.
To make it visually better, you can apply same conditional formatting for font color and background color and then provide a legend somewhere indicating what green and red would mean.
Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!!
Proud To Be a Super User !!!
LinkedIn - AnkitKukreja
You can try with other visuals but a table/matrix would give you the best result showcasing date and pump data as well. I have worked on Alexis Olson's advice and I did unpivot this data and have used conditional formatting. Please see if this helps.
