Structure -
- One flow with two outputs. One output is a summarized version of the data, the other output is a detailed version containing much more information. The values within each match each other (verified)
- A different flow that uses the summarized output of Flow 1 as an input step and pulled into existing data set (union to establish all common dimensions, then a join using all common dimensions for both datasets).
I created an aggregation at the end of Flow 2 to see my summarized values for a single month. Those values also match an aggregation from the detailed flow data in Flow 1 for the same month (values match = no duplication, etc).
The problem is that I've published Flow 2 and then use the output of Flow 2 in a dashboard. The dashboard value with all the same filters is roughly double that of the aggregated values shown at the end of Flow 2 that I'd expect.
Flow 1 Detail value for x month 623k
Flow 1 Summarized value for x month 623k
Flow 2 Aggregated value off the clean step just prior to the output for x month 623k
Workbook value for x month 1,247k
There's no flow steps etc between the flow and workbook where things could get doubled up. I've refreshed and re-run several times. It seems this must be a legit Tableau back-end problem hosing up values.
Any thoughts or suggestions?
[EDIT] Ok so I checked and values are duplicated 2x (see attached image)
I tried running the flow from desktop and also republishing the workbook from desktop. Neither have resolved the issue
Suggest you attach your packaged workflow so that we can have a look at it and respond.
