how to display actual # in a % barchart expression

[lmonincx]

Hi,

I have a bar chart with an expression like 52,7 % as outcome, i would like to put in that barchart besides the 52,7 % as value on datapoints the actual number for example 600

please attached example

is this possible?

kind regards,

Linda Monincx

[anbu1984 · Accepted solution]

Check this

[jyothish8807]

Hi Linda,

Can you please let us know what is 600? is it a result of a expression or you simply want to put it as a text on the bar?

If it is an expression then you can get it by using the solution given by anbu cheliyan.

Regards

KC

[lmonincx]

600 is just a number I want to show, preferable behind the values expression of the %.

I can't get the formula work from anbu, maybe due to the fact that my calculation is using a count with a lot of set analysis used.

can it be possible to merge text with the outcome of the expression?

I am not that familiar with the settings behind the expression like show value when you click on the + of the expression

[anbu1984]

Dual(Your_expression & ' 600',Your_expression)

[jonathandienst]

Linda

If you change the chart type to a combo chart and then do this:

• Set the display method for expression 1 to a bar
• Add a second expression which calculates the number you want to display
• For this expression clear the line, bar and symbol options and select the display value on data points option
• In the Numbers tab, set the number format you want

HTH

Jonathan

[jyothish8807]

Hi Linda,

Can you share your app?

As per my understanding you require different numbers for differet color bar? Am i right.

try like this:

if(Month='Feb',dual(Sum(sales) & '600',Sum(sales)),Sum(sales))

Hope it helps.

Regards

KC