Pivot Table - Blank Column To Segment Data
Hi All
i currently have a pivot on my dashboard with quite a lot of columns, to help users visually i wanted to segment slightly
my thinking was to create a blank beast mode and add to where i wanted a break however it counts the rows does anyone know of a workaround? or another possible solution
See below example (yellow would be where the blank columns would be
Best Answer
-
Yep blank column is the easiest. You can hide totals for any column so just hide totals for the blank field to prevent the counts from showing.
If I solved your problem, please select "yes" above
0
Answers
-
Yep blank column is the easiest. You can hide totals for any column so just hide totals for the blank field to prevent the counts from showing.
If I solved your problem, please select "yes" above
0 -
Thank you just tested and worked as expected - the only issue is still shows at the lowest level of the pivot row hierarchy (as isn't a total or subtotal)
0 -
Can you share a screenshot of what you are seeing?
If I solved your problem, please select "yes" above
0 -
here you go - Week commencing is the last level in the pivot rows
0 -
For the blank field you can copy and paste an empty character as the title so "Blank" wont be displayed. And for the "Blank" field you can just put '' as the value in the beastmode and the 5 shouldn't show.
If I solved your problem, please select "yes" above
1 -
Thanks - i have done the above steps but still get the value at the last level - the issue being the only option is to aggregate by count
another workaround i was thinking is to change the font colour on that particular field as white so wouldnt show - however i dont think thats dobale? i think the font colour can only be set for all and not individual fields/measures?
0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 295 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 608 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 710 Beast Mode
- 50 App Studio
- 39 Variables
- 668 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 45 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 116 Manage
- 113 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive