Unable to add new columns when uncollapsing dates
Anyone else run into this issue or am I doing something wrong?
I have a table which an end user wants pivoted by date, such that the column headers will be every month in 2018, the rows are expense types, and the values are sums of $.
I am able to get the dataflow preview to run successfully, but am unable to add more columns. In order to select a new column to create, I need to select a date, which is fine, as all the dates in my source are the last days of a given month, no variability. However, the "Add Column" button is greyed out.
Seeing as the preview ran successfully, it's odd that I can't add more columns. Had I done something wrong I would imagine the preview would not run.
Comments
-
Is anyone able to help out with this request?
0 -
You can try converting the date column to text, then uncollapsing, then converting it back to dates.
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 616 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 738 Beast Mode
- 56 App Studio
- 40 Variables
- 684 Automate
- 176 Apps
- 452 APIs & Domo Developer
- 46 Workflows
- 10 DomoAI
- 35 Predict
- 14 Jupyter Workspaces
- 21 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 123 Manage
- 120 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive