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.
Correct data
Incorrect data
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?
Comments
-
Please disregard. I can't seem to delete, but this was being caused by a data issue that I was unaware of.
0
Categories
- 10.8K All Categories
- 3 Private Company Board
- 1 APAC User Group
- 12 Welcome
- 39 Domo News
- 9.7K Using Domo
- 1.9K Dataflows
- 2.5K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 343 Workbench
- 260 Domo Best Practices
- 11 Domo Certification
- 464 Domo Developer
- 50 Domo Everywhere
- 105 Apps
- 714 New to Domo
- 85 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 27 お知らせ
- 64 Kowaza
- 299 仲間に相談
- 653 ひらめき共有