Tacometro

[#1]

hi,

i have the following data:

SITIO	CAPACIDAD TANQUE GL	SUMINISTRADO
BOGOTA	500	400
CALI	700	600
MEDELLIN	600	550
BUCARAMANGA	800	400

i wanna plot the following:

i want used this chart

i need  show  the capacity free

example:

bogota:  400/500= 80%

i wanna that this value to be indicated

this is posible?

thank you

sorry my english

[Anonymous]

If you want to make a gauge specifically for BOGOTA you could use an expression like:

sum({$<SITIO={'BOGOTA'}>} SUMINISTRADO/[CAPACIDAD TANQUE GL])

[#3]

Hi,

In the requirement your data has 4 SITIO. The gauge(tacho) chart can display only on of them at one time. Hence you will have to slect the particular SITIO.

Else you could display all the SITIO side by side, like a clusture of charts like this

.. For this you will have to use Trellis option at the bottom in the  Dimensions tab of the Chart properties.

You will be able to define the color in the presentation tab.

Attached is an sample qvw.

Hope this helps.

Thanks

SITIOSITIO

[#4]

hi,

thank you  fahadkhanbi

can  you write the expresion?

[#5]

Hi,

The expressiong is the same "=SUMINISTRADO/[CAPACIDAD TANQUE GL]"

It is in the qvw attached in the previous reply.

Thanks