Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I saw a post two or three weeks ago with question about how to display value and % on data point bar chart. Sunny solved the problem with using dual function.
I have made a dummy using dual (see below). So i know the dual() function, but in this case, i can't understand how dual () works??
Is there experts can explain how it works?
Regards
If i am not wrong Dual takes Text and a Number. Like Dual(Text, Number) So internally while calculating expressions the Number value will get calculated and plot the Graph accordingly, and the text part plays as a Data value points, in this case your data values on those bars. So the number you see on your bar like 543 & -19.9% they are in text format. Correct me?
If i am not wrong Dual takes Text and a Number. Like Dual(Text, Number) So internally while calculating expressions the Number value will get calculated and plot the Graph accordingly, and the text part plays as a Data value points, in this case your data values on those bars. So the number you see on your bar like 543 & -19.9% they are in text format. Correct me?
Dual() function return a mixed value with
Example:
Dual('True',1) and Dual('False',0) represent boolean values, you 'see' true/false but you can Sum() and find out how many true values you have
more info on dual here
Thanks Vishwarath, it's very clear now.