I've been struggling with building a report in Tableau, Any your input or your advice will be much appreciated.
"Store DB" is a primary data and other data "Tue", "Wed" and "Thur",,,, sales tables need to be joined as 1:N on every day.
* Could you please have a look at attached (File called 'Data Sources')?
In order achieve cumulative way with given tables (pls refer to attached) as below
Store Tue_Transactions Wed_Transations Thur _Transactions .......
A 31 35 92 .......
B 50 44 66 ...
What type of Join type and which Join fields I should use it?
When joining tables in a data source, Some 'Store's displays incorrect numbers for "Total Transactions", so I used the formula of "SUM([Total Transactions]) / COUNT ([Store Id1])" to resolve the issue but some of stores display the wrong figure.
Please refer to attached Test1.twbx
There are two different types in "Service Type" column, one is takeout and other is delivery, and some of stores have two all types on the daily sales, some of them are not so I can not use this "Service Type" as the secondary key to link the tables.
Can you pleases have a look at these attached and advise me what I went wrong?
Your support is much appreciated.