ALTERYX & TABLEAU

[suby]

Hi All,

I have a Formula tool with a simple IF ELSE statement and in Metrics Formula tool my first condition satisfies  i get M1 for that row and second condition is not satisfied it false under ' OTHER' bucket.

But when i bring the Metric Column in Tableau and do a count Distinct of ID i get 

Metrics	Count of IDs
M1	5
OTHER	5

and even though my condition for M2 doesn't have any data is there way to display M2 there in tableau or is there way to do a  Data scaffolding in Alteryx to Display 'M2'  and display zero in  Tableau.

Many thanks

[adamweaver39]

Hey @suby --  could you parse your formula out into three separate formulas in order to get a unique count for each column and then utilize a summary function that way? 

[binuacs]

@suby try the attached workflow