Is there a way to aggregate with hiding the dimension in Barchart?

[varunreddy]

Hi Guys,

I am trying to build a bar chart, in which I am aggregating data using a dimension, Country. But I don't want to display dimension . Is there a way to hide the dimension from displaying?

I know, we can hide in straight table. Is there a way to hide in barchart?

Regards,

Varun

[JonnyPoole]

Maybe use the aggr() function to hard code the aggregation level: 

aggr( sum(Sales), Country)

You may need to add additional chart dimensions to the 2nd arguement if you want to be sensitive to the other dimensions in the chart if you have them

aggr( sum(Sales), Country, City, Customer)

[rwunderlich]

Could you clarify what your results you are after? Do you want to display one bar/bar group for each Country, but not display the Country names? Or something else?

[#4]

Hi Varum. I think that do this is not possible.

You can limit some values of your dimension or do a TOP [NUMBER].

For example: You can add a calculated dimension doing this:

if ( COUNTRY='United States' or COUNTRY='United Kingdom' , COUNTRY)

With this you have a Dimension only with United States and United Kingdom. Without the values that you no want it.

I hope that it help you!

Regards, Agustin