Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I HAVE A FIELD CALL FIELD_A
IT HAS 3 VALUES: PRODUCT1, PRODUCT2, PRODUCT3
I CREATE A TABLE. DIMENSION FIELD_A AND EXPRESSION %EVOLUTION1 %EVOLUTION2 %EVOLUTION3 %EVOLUTION4 %EVOLUTION5 %EVOLUTION6
NOW I WANT TO CREATE A PIE CHART AND I WANT TO SEE
%EVOLUTION1 %EVOLUTION2 %EVOLUTION3 %EVOLUTION4 %EVOLUTION5 %EVOLUTION6 IN THE PIE CHART BY PRODUCT
thanks
You need to explain what you mean with "EXPRESSION %EVOLUTION1 ..." etc. An expression must have an aggregation with a field in it, e.g. Count( ID ) or Sum( Amount ).
HIC
Can you attach sample data or app for the same?
%EVOLUTION1, = SUM(EVO1) THE SAME FOR 2 TO 6.
Regards
What you mean %EVOLUTION1 %EVOLUTION2 %EVOLUTION3 %EVOLUTION4 %EVOLUTION5 %EVOLUTION6
A pie chart can either have one or two dimensions with one expression. Or it can have no dimension and one or more expressions. So %evolution1 %evolution2 %evolution3 %evolution4 %evolution5 %evolution6 in the pie chart by product cannot be shown in one pie chart. You could enable the trellis option on the Dimension tab to get a pie for each product.