Issue with linear guage rep in straight table

[#1]

Hi,

I have a small issue/requirement with Linear Gauge in the straight table. I want to show the % along with the representation.

Can anyone help me with this?

A screenshot has been attached.

Thank you in advance.

Regards,

Sachin

[maxgro]

Hope to be wrong but I don't think it's possible in the same column.

You can add a column.

[#3]

Hi,

Can I overlap table on top of table. If yes, can you let me know the rgb() value to make the background color for that expression transparent.

Regards,

Sachin

[maxgro]

green(0)

argb(0,0,255,0)

the bold parameter is opacity

ARGB(alpha, e1, e2, e3)

An alpha of 0 corresponds to full transparency. An alpha of 255 corresponds to full opacity.

[#5]

Thank you.

So as per my understanding I need to overlap chart with actual values on top of chart with linear gauge and then make the background for the required expression as white(0).

[swuehl · Accepted solution]

I would not mess around with overlay charts if not absolutely necessary. In your case, just adding another column like maxgro suggested should give you similar results, but much better maintainable.

A single chart could look like

[veidlburkhard]

Hi Aditya,

there is an easy workaround to achieve your favoured result in one straight table. Look this example:

You have to place the numerical column just behind your linear gauge column. Set the header of the numerical column to =' ' , got to the Presentation Tab and mark the alignment of Data(numeric) to Left. Then go to Chart Properties, Style and uncheck the 'Vertical Expression Cell Borders'. After that you got a result similar to the above.

Happy qliking

Burkhard

[nagarjuna_kotha]

Hi swuehl ,

How did u do that?

Can you tell, How to achieve this? If you share sample file that would be more helpful to me.

Regards,

Nagarjuna

[swuehl]

Attached the sample from my previous post (which has been also explained well by the following poster).