topic Re: How to add a color to the different timings field in the dashboard. in Dashboards & Visualizations

How to add a color to the different timings field in the dashboard.

Anud — Mon, 27 May 2024 18:49:20 GMT

Hi Team,

Please let me know how to add a color to time format as below.
Below one is not matching with the requirement.
<colorPalette type="expression">if(strptime(value,"%H:%M:%S")>"25200", "#A2CC3E", "#F58F39")</colorPalette>

Time	expecting this color in Time field
25-05-2024 19:06	Red
25-05-2024 22:10	Red
25-05-2024 22:16	Red
26-05-2024 06:50	Green
26-05-2024 06:52	Green
26-05-2024 11:50	Green
26-05-2024 11:52	Green
27-05-2024 07:09	Red
27-05-2024 07:10	Red
27-05-2024 11:52	Green
27-05-2024 11:57	Green

Thanks in Advance!

Re: How to add a color to the different timings field in the dashboard.

ITWhisperer — Mon, 27 May 2024 22:27:42 GMT

If your Time field is actually an _time field then it will be in epoch format (number of seconds since 1970), if that is the case, then you could try formatting (rather than parsing) - something like this for later than 12:30 pm

<colorPalette type="expression">if(tonumber(strftime(value,"%H%M%S"))>123000, "#A2CC3E", "#F58F39")</colorPalette>

Re: How to add a color to the different timings field in the dashboard.

Anud — Tue, 28 May 2024 06:12:56 GMT

Yes, i agree with you.
But i was looking for time frame colors After 7 AM, 12 PM, 7 PM, 9:35 PM - Red and Before 7 AM, 12 PM, 7 PM, 9:35 PM - Green

Time	expecting this color in Time field
25-05-2024 19:06	Red	After 7PM
25-05-2024 22:10	Red	After 10 PM
25-05-2024 22:16	Red	After 10 PM
26-05-2024 06:50	Green	Before 7AM
26-05-2024 06:52	Green	Before 7AM
26-05-2024 11:50	Green	Before 12 PM
26-05-2024 11:52	Green	Before 12 PM
27-05-2024 07:09	Red	After 7AM
27-05-2024 07:10	Red	After 7AM
27-05-2024 11:52	Green	Before 12 PM
27-05-2024 11:57	Green	Before 12 PM

Re: How to add a color to the different timings field in the dashboard.

ITWhisperer — Tue, 28 May 2024 07:56:35 GMT

I am not sure what your question is now or is this solved?

What colour is 10am? It is after 7am but it is also before 12pm!

Re: How to add a color to the different timings field in the dashboard.

Anud — Tue, 28 May 2024 08:00:59 GMT

I have a cycle so data will come in between 6-7 AM, 11-12 PM, 6-7 PM, 9-9:35 PM.
So i want to display the color for the time After 7 AM, 12 PM, 7 PM, 9:35 PM - Red and Before 7 AM, 12 PM, 7 PM, 9:35 PM - Green.

Re: How to add a color to the different timings field in the dashboard.

ITWhisperer — Tue, 28 May 2024 08:12:31 GMT

Would it be better to say anything outside the time ranges 6-7 AM, 11-12 PM, 6-7 PM, 9-9:35 PM is red and anything inside the ranges is green?

Re: How to add a color to the different timings field in the dashboard.

Anud — Tue, 28 May 2024 08:41:05 GMT

Exactly!

Re: How to add a color to the different timings field in the dashboard.

ITWhisperer — Tue, 28 May 2024 10:16:53 GMT

Try something like this

<colorPalette type="expression">if(tonumber(strftime(value,"%H")) == 6 OR tonumber(strftime(value,"%H")) == 11 OR tonumber(strftime(value,"%H")) == 18 OR (tonumber(strftime(value,"%H")) == 21 AND tonumber(strftime(value,"%M")) < 35), "#A2CC3E", "#F58F39")</colorPalette>

Re: How to add a color to the different timings field in the dashboard.

Anud — Tue, 28 May 2024 12:52:05 GMT

Its working giving proper results only red color is coming on every time

Re: How to add a color to the different timings field in the dashboard.

ITWhisperer — Tue, 28 May 2024 13:36:58 GMT

It looks like it might not work with _time fields - try assign a new field to the formatted value e.g.

| eval Time=strftime(_time,"%F %T")

Then change to formatting to take this new field into account

<colorPalette type="expression">if(tonumber(strftime(strptime(value,"%F %T"),"%H")) == 6 OR tonumber(strftime(strptime(value,"%F %T"),"%H")) == 11 OR tonumber(strftime(strptime(value,"%F %T"),"%H")) == 18 OR (tonumber(strftime(strptime(value,"%F %T"),"%H")) == 21 AND tonumber(strftime(strptime(value,"%F %T"),"%M")) < 35), "#A2CC3E", "#F58F39")</colorPalette>

Re: How to add a color to the different timings field in the dashboard.

Anud — Tue, 28 May 2024 14:36:03 GMT

Awesome, Its working!
Thank you very much!