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
Are you on my newsletter? If not, signup here so you don't miss out on my Domo tricks, alerts about my webinars, cooking tips and more
Signup here:
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
Are you on my newsletter? If not, signup here so you don't miss out on my Domo tricks, alerts about my webinars, cooking tips and more
Signup here:
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
- Product Ideas
- 2.1K Ideas Exchange
- Connect
- 1.3K Connectors
- 309 Workbench
- 7 Cloud Amplifier
- 10 Federated
- Transform
- 665 Datasets
- 120 SQL DataFlows
- 2.3K Magic ETL
- 827 Beast Mode
- Visualize
- 2.6K Charting
- 90 App Studio
- 46 Variables
- Automate
- 198 Apps
- 489 APIs & Domo Developer
- 97 Workflows
- 24 Code Engine
- AI and Machine Learning
- 23 AI Chat
- 4 AI Projects and Models
- 18 Jupyter Workspaces
- Distribute
- 119 Domo Everywhere
- 284 Scheduled Reports
- 11 Software Integrations
- Manage
- 145 Governance & Security
- 13 Domo Community Gallery
- 49 Product Releases
- 13 Domo University
- Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 117 Community Announcements
- 5K Archive