Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi Anonymous 

    Why not adding "Leaving customer" in the "Value" field?

     

    Best Regards
    Maggie

     

    Community 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.

v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi Anonymous 

As tested with this data, it seems bar chart also shows well.

Please show me with your bar charts to let me know what difference.

 

Best Regards
Maggie

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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's avatar
    v-juanli-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    Hi Anonymous 

    Why not adding "Leaving customer" in the "Value" field?

     

    Best Regards
    Maggie

     

    Community 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.

  • v-juanli-msft's avatar
    v-juanli-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    Hi 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