chart in pivot table

[francis_gr]

Hi!

In my example pivot table, i have one chart expression,

As you can see, always shows the values just over the limit between values and not inside the section and in dependig the empleado that you select it doesn`t show anything in Total Line.

How can I solve those two problems??

regards!

[#2]

try doing the sum(Tramos_Limite1) in the chart expresiion

and modify the limits of the indicator, since the values exceed 3, you should adjust that limit or use the average instead of sum

[#3]

It looks like you have the autowidth checkbox set for the gauge settings, try unclick that and set your own limits for the colors and you will be all set.

[francis_gr]

Hi Fabián!

Thanks for your reply.

I've tried to follow your suggestions but no avail.

I have change the values in my sample QV "Prueba". Now the values can be in 3 possible ranks.

As you can see, if no selection is done, total line for "tramos" doesn´t show the right value.

Can you suggest to me how to form the chart?? (min and max values, segment configuration, scale...)

Regards

[francis_gr]

Hi John!

Thaks for your reply.

If i unclik the autowidth checbox, the full area in my chart gets red so really don`t know if i'm doing ok.

have you got another option?

Please chek my example. I've changed the values so now I have 3 possible ranks to show

Regards

[#6]

Hi

The entire area turns red due to the limits you have set for the color.

Try to set the limits static first so you see the give you the right colors and make sure the range is high enough to include the last limit.