The .twb file you attached wants to connect to your live Database. Please extract the data and post as a packaged workbook (.twbx) as Prashant has suggested, so we can access the data as well as the workbook. Cheers
See packaged workbook attached.
I am trying to identify the type of transaction i.e 3 Types
- Order that is Cash only
- Order that is Credit only
- Order that is Mixed Cash & Credit
I kind of followed your sample but for some reason its still not splitting the transactions and is only giving me mixed.
IF ISNULL([Cash_Num]) then 'Credit'
ELSEIF ISNULL([Credit_Num]) then 'Cash'
ELSEIF NOT ISNULL([Credit_Num]) AND NOT ISNULL ([Cash_Num]) then 'Mixed'
Can you help?
Can you upload a sample packaged workbook, with the calculation you've tried to use in the view? I don't see it in your workbook, and don't see "Cash_Num" or "Credit_Num" in the view.
1 of 1 people found this helpful
It's most likely that your data has no null values for either cash or credit.
I used the Superstore data for my example and had the same problem ending up with Mixed only, so I added nulls to the values to confirm.
Tableau handles NULL values differently from 'Blank' values--this could be what is causing you problems.
Thank you Matthew & Don ! Issue has been resolved.