Pivot tile returning results slightly less than expected
I have a dataflow with 2 outputs. I branched off some appended data to one dataset, and then I took the same appended data and applied a pivot tile (initially I was joining to achieve the values in columns, but that was coming out way off). The dataset that is taking just the appended data is coming out correct, but the pivoted data is around $300k less from a total of $26 million. I reviewed the pivot documentation and am following it exactly how the example shows.
I have 3 columns I am using for row values that are basically the market, the week sold, and the item sold. The only column that is not a measure value is the period, but that is what I am trying to pivot to the columns so that I can easily subtract prior period from the latest week to find the variance.
Is there a setting in the pivot tile that I am missing? Is it possible that there are two same values that are being de-duplicated? I like having the ability to create an appended dataset with the time period in rows and a pivoted dataset with the time period in columns, but why would these differ slightly from each other?
- 10.7K All Categories
- 13 Getting Started in the Community
- 38 Beastmode & Analytics
- 2.1K Data Platform & Data Science
- 59 Domo Everywhere
- 2.7K Charting
- 2.5K Ideas Exchange
- 1.3K Connectors
- 362 Workbench
- 303 Use Cases & Best Practices
- 501 APIs
- 118 Apps
- 48 News
- 753 Onboarding
- 1.2K 日本支部
- Private Company Board