Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
I have created an expression to calculate something ,now can I do some more calculation on the same expression?
Example:
count(if(abc=0,id))
and named it as "#ids"
Now, can I do
count(if(#ids >1, 'A','B'))
and I want to use this in pie chart.
Pls help on this.
Thanks
Shivesh
Perhaps thuis:
=count(Aggr(if(count(if(abc=0,id)) >1, 'A','B'), <...pie chart dimension here...>))
I suggest that you post a sample qvw to save the guesswork and ensure that you get accurate and useful suggestions.
I agree it would be easier to troubleshoot with a handy sample