Displaying an expression as text on axis

[bluecarbon]

I have two dimensions, one Country and another a Date, And two expression one Units and other one as action. A country can take some action on a particular date and this field will have a value as 1 whenever an action is taken.

I want to display the 1 on x-axis whenever there is action taken on that particular date regardless of country. But the chart is displaying action for each country.

Is there any way to display only one value regardless of country count?

Thanks,

Rakul.

[Anil_Babu_Samineni]

Text on axis doesn't build for specific filter. Hence, It will apply for all dimension values which are respect or irrespective on field selector

[bluecarbon]

Thanks Anil,

Is there any way to aggregate the expression in text on axis? I want it to display only one 1 rather than many 1's for each dimensions.

Thanks,

Rakul.

[Anil_Babu_Samineni]

I didn't decipher as much. But, marcowedel‌ Have some insights?

[MarcoWedel]

Hi,

I guess you can't aggregate the text on axis values into one single text per month, but maybe you can replace your second (country) dimension with one expression per country each:

hope this helps

regards

Marco