This content has been marked as final.
Show 5 replies
-
1. Re: Sum Avg - Different groups of products
Luciano Vasconcelos Sep 8, 2016 8:29 AM (in response to Guilherme Lampe)Can you post a twbx file?
You can manipule totals using IF Size() statements.
Probably If Size() = 0 then new calculation else ...
For checking this properly create a calculation Size() and drag on row shelf.
-
2. Re: Sum Avg - Different groups of products
Guilherme Lampe Sep 8, 2016 8:34 AM (in response to Luciano Vasconcelos)Hi Luciano,
Thanks, I attached the twbx.
-
3. Re: Sum Avg - Different groups of products
Luciano Vasconcelos Sep 8, 2016 8:54 AM (in response to Guilherme Lampe)See this one.
-
Sum Avg.twbx 36.1 KB
-
-
4. Re: Sum Avg - Different groups of products
Guilherme Lampe Sep 8, 2016 9:52 AM (in response to Luciano Vasconcelos)Great, thanks a lot!
-
5. Re: Sum Avg - Different groups of products
Guilherme Lampe Sep 8, 2016 10:50 AM (in response to Luciano Vasconcelos)Hi Luciano,
That was a great wrap up to the visualization, but I need to work further on this calculated field.
I will, for example, apply a 8,5% rate over this value, for some products, then apply 12% rate over other products.
Instead of use the acquisition value I would always use the Avg value for different calculations. It's a preparation for the real analysis.
Any other sugestions different than that?