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.6K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 474 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 478 Datasets
- 214 Visualize
- 259 Beast Mode
- 2.1K Charting
- 12 Variables
- 19 Automate
- 356 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 249 Distribute
- 65 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 191 Product Ideas
- 1.2K Ideas Exchange
- 11 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive