Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi!
I am trying to configure a 2D Pie Chart to show some data (see attach). Main problem is the first dimension is not totalized. It shows the individual numbers of the second dimensions which correspond to the first one but I find it impossible to show them summed.
For instance: at the left side of the chart, I don't want the first dimension to show "53 36 37" but the aggregation of those figures. How to do it?
Thanks in advance,
IW
I believe you do it by, =sum(field) in the expression;
Those numbers are the result of a "count" function. I've tried to sum the result of the count, but It doesn´t seem to work. Thanks anyway.
Edit: I add an example in which I found the problem. This is not with a "count" function, but it happens anyway.
I would say to add a column with 1 as flag. With this you can work with the sum(flag). I can help you better with the qvw which has the same problem.
If you can do it in the qvw I uploaded, I'm sure I can take the same idea to the one in which I'm working.
Thanks a lot.