![tableau prep joins tableau prep joins](https://interworks.com/wp-content/uploads/2020/02/setting_tableau_prep_r_integration_2_blog_header-01.png)
If we average the amount in Data Prep 3.0, you may need to add it back to one of the dataflows for reasons mentioned above. Now imagine the Account has a few other fields like Type of Product. An example for this would be Avg Amount by Account and Year. Of course, you can aggregate the data in Recipes/Data Prep 3.0, but then you will need to join it back to the original dataflow either to not create a separate dataset for this or for multi value row level security. That one has really joined to many and some of those should never ever have joined! Example, one weather station that contains weather data but services multiple store locations for a retail chain in a city! But, this works like a charm if your only purpose is to filter!Īnother example of such a challenge would be aggregating the data in the dashboard.
![tableau prep joins tableau prep joins](https://help.tableau.com/current/prep/fr-fr/Img/prep_output.png)
If you perform a one-to-many join in the dataflow and then try grouping it, you will see that the data is all over the place. And we will come across scenarios where we try doing something in the dataflow and then realize, it doesn’t work the way we want. It is not always a matter of which we know better or we think is easier for us to solve. Are we proficient enough to do this in the dashboard where SAQL and Interactions (fka Bindings) maybe required?.Are we proficient enough to do this in the dataflow, if that is the preferred route for this issue?.Should we join ALL our datasets that we intend to use in the dashboard/widget to form a comprehensive dataset in the dataflow and then work with it or should we join these datasets in the dashboard?.Can we perform the calculation in the widget/lens/dashboard (for simplicity, we will call this dashboard) or should this be done in the dataflow?.A question and challenge we always come across and ask ourselves or experts is should we approach the solution to the problem statement using Dataflows or Dashboards or do we need a combination of both? Let’s break this apart today and understand what to use and when. Dataflows/Recipes/Data Prep 3.0 (Let’s call this whole gamut as Dataflows for this post) and Dashboards are an integral part of our work with Tableau CRM (TCRM).