Amount for specific product. how to achieve the same using specified gauge

[#1]

Hi All,

I have a requirement to display Amount for specific product. how to achieve the same with below specified gauge type?

tried with select field  under action--> field name (product)--> and under value I gave specific product name. But am getting wrong result.

Regards,

Prajna

[Anonymous]

Pajna

I presume you have created a Chart of type 'Gauge Chart'

Ignore the Actions tab.

Instead go the Dimensions tab and from the pick list on the left add the required dimension to Used Dimensions on the right.

Then go to your Expressions tab and add whatever expressions you need, something like:

     avg(Amount)

Best Regards,     Bill

[Gysbert_Wassenaar · Accepted solution]

Try something like sum({<Product={'Airbus'}>}Amount) as expression. Replace Product with the name of your product dimension, Airbus with the specific product name and replace Amount with the name of your amount field.

[#4]

Thanks for the help

Regards,

Prajna