Changing color on single number analysis to red/green

Support, Troubleshooting, & Help
1

I’m trying to set up my single number analysis to display red or green depending on logic I want to create. How would this be done? I tried using a trigger for when the app is started, but I’m not able to see the analysis as an option for the If part.

image
image1627×712 47.8 KB

2

Hi, thanks for your question about coloring the Single Number Analysis widget. You can’t reference the Analysis directly in a trigger. Instead, store the same value powering the analysis in a number variable (like TRIR_Value), and write a trigger to set a text variable (like ColorCode) based on that value. In the widget settings, set the color to be controlled by ColorCode. This lets you apply logic like: if TRIR_Value > 2, set ColorCode to “Red”, else set it to “Green”. Let me know if you want help wiring that up.

3

Hi, so far I have done the following:
Created a number variable called TRIR value and set the default value to 2.0. The data source for this TRIR value I’m unsure about. At the moment, I set it as the TRIR table record from the safety table I created.

Next I created a variable called TRIR color.

I made my analysis color be transparent because I have TRIR value behind it.

I made a trigger you see below.

image
image1531×790 47.8 KB

When I test, there is no color change. I’m positive I did not get everything right the first time, so please help me fix where I went wrong.

Thanks for your support!

4

Hi Cody,

You’re close! Here’s what to fix:

  1. Make sure TRIR color is a Color variable, not Text.
  2. Load the actual TRIR value from your Safety table into the TRIR value variable using a Load Table Record + Store action.
  3. Use one trigger to compare TRIR value:
  • If >= 2, store Red into TRIR color
  • Else, store Green
  1. In the widget, set the color to use the TRIR color variable (not transparent).

That should make the color change work. Let me know if you want help setting up the data load.

5

Hi,

  1. Done
  2. Not sure what is meant here by “Load Table Record + Store action”. Please clarify. I added the table record TRIR <2.0 as a variable, but that didn’t do anything.
  3. Done
  4. Done
6

Never mind. I got it now lol.

Thank you very much for your support on this!

1 Like