Forum Discussion
Sum different values from distinctcount
It seems to be working in a table but it doesn't work when I use a bar chart. My hypothesis is that each company name is different so it does not understand that all the company names should be summe...
Hi Anonymous
Why not adding "Leaving customer" in the "Value" field?
Best Regards
MaggieCommunity Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for your reply!
When I turn the table into a bar chart, it shows all company names per week with value 1.
When I exclude company name in the axis it doesn't show any values at all.
*EC under value = distinctcount of company name
*Blurred out customer names of course
v-juanli-msft
Community Support
Community SupportHi Anonymous
Is this problem sloved?
If it is sloved, could you kindly accept it as a solution to close this case?
If not, please let me know.
Best Regards
Maggie