Skip to main content

Hello Everyone,

I am a beginner at using Tableau and I am trying to get the count distinct of people who had did both ordered more and spent less. In better words I'm trying to see the count of people that did both ordered more and spent less. As of right now this is my calculation:

 

{INCLUDE [Customer Name]:[Ordered_More(calc)] + [Spentless_(calc)]}

 

The [Customer Name] is the dimension variable that I am using to get the count distinct of people who had did both order more and spent less. The [Ordered_More(calc)] is the variable is that I am using that gets the people that have ordered more and the [Spentless_(calc)] is the variable that I am using to gets the people who spent less. What I am trying to do is get the number of people who did both ordered more and had spent less but the calculation I have now is just adding the individual people who ordered more and the individual people who spent less and instead of counting only the individual people that did both ordered more and spent less.

1 answer
  1. Nov 11, 2022, 9:46 AM

    sharing with @Newbie, Tableau Desktop​ 

    Ciara Brennan

    Senior Program Manager | Tableau Community Forums

0/9000