11 Replies Latest reply: Sep 1, 2016 12:54 PM by Tim Kendrick

Color for a limit area based on a condition in a Gauge

Bijoy B Sep 1, 2016 2:49 AM

Hi,

I have a Gauge Chart, for which I have set a limit. Is there any possibility to set the color for a limit area in the gauge based on a condition??

For instance, I have two Variables(ACTUAL and BUDGET), which generates values based on selection. I set a limit in the gauge using an expression, which identifies whether ACTUAL or BUDGET applies to the limit. If the limit is BUDGET, the area in Gauge from the limit to MAX should be green and if ACTUAL is the limit, then the area from the limit to MAX should be red.

I am attaching the screenshot of my scenario,(Selection values are specified below each)

I have kept a KPI to show the variance for the related items(In another way, my requirement is like when the KPI is green, i want the area in graph to be green and if the KPI is red, i want the area in graph to be red(by default its showing green))

Attaching the qvf for the same also.

Guage Test.qvf 224.0 K

Re: Color for a limit area based on a condition in a Gauge

bruno bertels Sep 1, 2016 4:47 AM (in response to Bijoy B)

Hi

Gauge shart does'nt support custom colors
Like Show 1 Like (1)

Actions
Re: Color for a limit area based on a condition in a Gauge

Shaima Mahmoud Sep 1, 2016 4:52 AM (in response to Bijoy B)

I selected a Cauge
> go to > Appearance > Presentation >
- Select Use segments
- Drag The Scale (1) to customize your GOAL
- Clik the area after the threshold point to give it a color ,and the area below threshold to give it another color
- Select Gradient (2) to be Grading between the two colors.

- But Unfortunatly there is no option to color it by expression

Does this answer your Question ???
Like Show 0 Likes (0)

Actions
- Re: Color for a limit area based on a condition in a Gauge
  
  Bijoy B Sep 1, 2016 5:02 AM (in response to Shaima Mahmoud)
  
  Hi Shaima,
  
  Thanks for your response, I appreciated.
  
  Actually setting up the Gradient will not suit for my requirement. I want it to change the color of the area, from RED / GREEN depending on the Variable(ACTUAL / BUDGET).
  
  Like Show 0 Likes (0)
  
  Actions
- Re: Color for a limit area based on a condition in a Gauge
  
  Shaima Mahmoud Sep 1, 2016 5:11 AM (in response to Shaima Mahmoud)
  
  You can also , add multiple ranges and multiple thresholds , or Limits
  
  by pressing button Add Limit as in the pic,
  and use Gradient at every Limit on its own
  
  - you can use the expression at the Limit Value , for evaluation value , not for evaluating color,
  this makes you do what you want in a reverse way
  
  Like Show 0 Likes (0)
  
  Actions
Re: Color for a limit area based on a condition in a Gauge

Bijoy B Sep 1, 2016 5:34 AM (in response to Bijoy B)

Clarifying my requirement.

I have an expression to set the Maximum Limit of the Gauge, (If ACTUAL is greater, MaxLimit is ACTUAL, if BUDGET is GREATER, MaxLimit is BUDGET).

Now I set a Limit in the Gauge(If ACTUAL is greater, limit is BUDGET, if BUDGET is GREATER, limit is ACTUAL).

Now about the color of Area in Gauge from Limit to MaxLimit. If the limit is ACTUAL, then color of the area should be RED and if the Limit is BUDGET then the color is GREEN.

The variables and expressions I used for my requirement is there in the .qvf
Like Show 0 Likes (0)

Actions
- Re: Color for a limit area based on a condition in a Gauge
  
  Shaima Mahmoud Sep 1, 2016 9:33 AM (in response to Bijoy B)
  
  How about adding 2 Limits
  Actual and Budget and coloring each one of them
  
  Like Show 0 Likes (0)
  
  Actions
  - Re: Color for a limit area based on a condition in a Gauge
    
    Bijoy B Sep 1, 2016 9:40 AM (in response to Shaima Mahmoud)
    
    If we add two limits, then it will be two different areas. Even there won't be any intersected area for both.
    
    Like Show 0 Likes (0)
    
    Actions
- Re: Color for a limit area based on a condition in a Gauge
  
  Shaima Mahmoud Sep 1, 2016 9:58 AM (in response to Bijoy B)
  
  Limit 1 = MIN (Actual , Budget)
  LIMIT2 = MAX(Actaul, Budget)
  
  Like Show 0 Likes (0)
  
  Actions
- Re: Color for a limit area based on a condition in a Gauge
  
  Tim Kendrick Sep 1, 2016 10:24 AM (in response to Bijoy B)
  
  Instead of a gauge, you could use a stacked bar chart with a KPI object underneath and get a similar look. For bar charts you can absolutely set the colors of each of the bar segments conditionally.
  
  Like Show 0 Likes (0)
  
  Actions
  - Re: Color for a limit area based on a condition in a Gauge
    
    bruno bertels Sep 1, 2016 10:34 AM (in response to Tim Kendrick )
    
    Hi
    
    i had the same idea , but how to deal with the dimension ? what dimension should he put in his stacked barshart : i don't find a way to " trick" the dimension
    
    Like Show 0 Likes (0)
    
    Actions
    - Re: Color for a limit area based on a condition in a Gauge
      
      Tim Kendrick Sep 1, 2016 12:54 PM (in response to bruno bertels)
      
      =VALUELIST('KPI') or something like that?
      
      Like Show 0 Likes (0)
      
      Actions

Go to original post