Hello,
I have imported one excel file to Tableau which has 3 tables. one of the tables is Owners table. I want to count the number of owners in each state from the owner's table. But, for some states tableau calculates it incorrectly. For example, I have 3 owners in WA state but Tableau only shows 1.
I even tried with #number of records and it still gives the same results.
Any help is appreciated.
thanks for sharing the data
this is the way the data sets are connected
and with the inner joins only the vehicles from a state that are also rented will be in the result set in your chart
in the WA example
there are 3 vehicles in the state
but only 970 was rented
one way to count all the vehicles is to left join the data on the vehicle/owners
and it will count the vehicles by stated
and also let you get this connection to rentals
Jim
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
