1 of 1 people found this helpful
welcome to the forums!
I assume you're talking about data blending? It should have worked if you make the target sales as the primary datasource. Do you have filters set on the achieved revenue datasource? This may be falsely eliminating records.
I just took one of the samples. Yes it is possible as seen below even though there is no sales on January 4 but it does exist in the view :
To achieve, just make sure your date on column shelf has below options:
I picked DAY, but you can change it to MONTH but make sure it is continuous. Please let me know if it does work for you.
Changing the primary data source makes the data appear, but there's another issue.
I have 6 views on the same dashboard. I have quick filters on the dashboard that all work based on the Postgres source being primary. When I change this single view from my question and make the csv the primary data source, the quick filters on the dashboard will apply to 5 views, but one won't be affected. When I edit the quick filters on the dashboard and go to 'Apply do worksheets' > 'Selected workshets' then the worksheet with the csv as the primary source won't show up.
Will I have to change the primary data source on all other 5 views?
is it possible to change all views to have target sales as the primary datasource and also have the quick filters on this? it should fix your issue.
Update: I've changed the primary data source and the views and quick filters all work correctly when viewed locally. However...
Issue: ... after I upload my dashboard to Tableau Online and view the dashboard in my browser I seem to be back to square one. The same figures that were omitted before I reversed the Primary/Secondary data sources are now omitted again. This is only a problem on Tableau Online, the dashboard shows all the figures when viewed locally on Tableau.
Any help much appreciated.