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
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 293 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 96 SQL DataFlows
- 607 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 705 Beast Mode
- 49 App Studio
- 39 Variables
- 667 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 44 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 115 Manage
- 112 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive