Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
i have a problem with the combo graph that show me double value in the top og the column.
i attach a .JPG that explain the problem.
Oh, I see now.
If you actually need "Show Value" conditional presentation, then I guess the only way is to split the expression. Copy and paste it, leave only "bar" for one copy and "line" for the other, then disable "Values on data points" for both, and leave the "Show Value" expression only for one of them.
Take note, "Show Value" does not show whatever the formula under it evaluates to, beyond true/false (0 or null is false, everything else is true). It's just a switch to decide if the value should be shown for a particular datapoint or not. It's easy to see if you just input any number other than 0 there, and see if it changes anything...
But if you need to show those values always, then "Show Value" is unnecessary, keep the single expression and use "Values on data points" instead.
I'd hazard a guess one value is for the bar and other for the line. Uncheck "Values on datapoints" for one of the expressions on the Expression tab, just see which one will look better.
You have "Value on data point" selected for both the expressions ...
i have only one expression and "Values on datapoints" in unchecked....
if i disable "show value" on the expression and check "Value on data point" the graph snow value only one time.
But when i use "show value" (with a formula inside), the value appears two times.
Could you please share your object?
you are right Jakub, one value is for the bar and one for the line
Oh, I see now.
If you actually need "Show Value" conditional presentation, then I guess the only way is to split the expression. Copy and paste it, leave only "bar" for one copy and "line" for the other, then disable "Values on data points" for both, and leave the "Show Value" expression only for one of them.
Take note, "Show Value" does not show whatever the formula under it evaluates to, beyond true/false (0 or null is false, everything else is true). It's just a switch to decide if the value should be shown for a particular datapoint or not. It's easy to see if you just input any number other than 0 there, and see if it changes anything...
But if you need to show those values always, then "Show Value" is unnecessary, keep the single expression and use "Values on data points" instead.
Thank's Jakub ! you are right !!!!