Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Bar Chart > Country vs sum(sales) - how do you show the value on data point for one specific country ignoring other values display (ex: USA) ?
HI
In expression tab, ->'+' -> show value
in that, if(Country = 'USA',1,0)
Then untick the values on data point.
HI
In expression tab, ->'+' -> show value
in that, if(Country = 'USA',1,0)
Then untick the values on data point.
Create flag in the ETL
IF(Country='ABC',1,0) as Country_Flag
Then in create two expressions
1st:
=
SUm({<Country_Flag={1}>} Sales)2nd :
=
SUm({<Country_Flag={0}>} Sales)
Then for the 1st expression show value on the data point
Good Luck..!!