Highlighting data x location which does not meet a specified target
Hi, I have created a pivot table with a formula 'Weekly Target Flag' which highlights locations which have not met their weekly target of safety Observations.
The problem is to get the data to highlight I need to add the formula as a column. The information then appears in the table. How do I create a formula which does not appear in the table or how do I hide the column information 'Weekly Target Flag'?
(photos: Analyzer and formula attached)
Best Answers
-
Hi @Patricia_Zavisky ,
You just have to go to General under Chart Properties and go to Hide columns and select the column number your formula is in. So I'd suggest making that your first column and just choosing to hide column 1
I made a video for you showing how to do this:
Let me know if it works
John Le
You're only one dashboard away.
Click here for more video solutions:
1 -
Unfortunately, you can't hide a column in a pivot table. You could reformat your data before putting it in the table to use the hidden column feature (in a not-pivot table), or you could go even more manual and apply your color rules using HTML:
You'll also find many feature requests in the idea exchange for the ability to conditionally format cells of a table based on a formula not in the table. Upvote a couple dozen of those, or add your own, and surely it will eventually be implemented.
Please 💡/💖/👍/😊 this post if you read it and found it helpful.
Please accept the answer if it solved your problem.
0
Answers
-
Hi @Patricia_Zavisky ,
You just have to go to General under Chart Properties and go to Hide columns and select the column number your formula is in. So I'd suggest making that your first column and just choosing to hide column 1
I made a video for you showing how to do this:
Let me know if it works
John Le
You're only one dashboard away.
Click here for more video solutions:
1 -
Unfortunately, you can't hide a column in a pivot table. You could reformat your data before putting it in the table to use the hidden column feature (in a not-pivot table), or you could go even more manual and apply your color rules using HTML:
You'll also find many feature requests in the idea exchange for the ability to conditionally format cells of a table based on a formula not in the table. Upvote a couple dozen of those, or add your own, and surely it will eventually be implemented.
Please 💡/💖/👍/😊 this post if you read it and found it helpful.
Please accept the answer if it solved your problem.
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 101 SQL DataFlows
- 623 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 748 Beast Mode
- 60 App Studio
- 41 Variables
- 690 Automate
- 177 Apps
- 455 APIs & Domo Developer
- 48 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 397 Distribute
- 114 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 127 Manage
- 124 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 109 Community Announcements
- 4.8K Archive