"Include a spreadsheet" with scheduled reports unpivots any pivot tables. Idea: It shouldn't.
Scheduled reports with spreadsheet attachments are incorrectly unpivoting any pivot table data.
I have a card using the Pivot Table report format. If I use the share/export button to download this report as a CSV or xlsx document, it correctly downloads the report in the pivoted format. In this case, that means each person has one row of data and they have three columns of weekly totals indicating hours worked over the last 3 weeks.
In contrast, if I send the card as a report or scheduled report with a spreadsheet attached, the data UNPIVOTS: each person now has up to three rows of data, one row per week. I assume this is unintended but support has told me it's not a bug. If I wanted to report data in an unpivoted format, I could build the Card in that style. So the scheduled report should use the same pivoted style that I designed the card with.
For scheduled reports with attachments, please attach data in the same, pivoted format as the pivot table card, which is the same format that the export button uses. It's undesirable to have this unpivot our reports.
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 296 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 614 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 53 App Studio
- 40 Variables
- 677 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 45 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive