0

How to use "Custom Colors" in the "Color" Drop zone to set a specific color to a specific value in a grid.

1) Create a new formula in the formulations app

 

2) Create an "IF" statement based on a measure using the "RGB"  function and save it.

Use an RGB Color picker such as the one here to get the correct values for the colors you need.

 3)  In your report, find and drag and drop your custom formula into the Color Drop Zone>Background(or foreground)>Custom Colors 

 

4) As can be seen below the grid foreground is now coloured according to color and value. 

  

Reply

null
Login to reply

Content aside

  • 5 yrs agoLast active
  • 363Views
  • 1 Following
Related Articles
Learning Hub Use Case: Finance Business Analyst
Blog: Superbowl 2024 - Interactive Football Dashboard
Learning Hub Use Case: Retail Business Analyst
Blog: The Data Shark Podcast - Omri Kohl
Pyramid 2023.10: Issues Addressed
Upgrading a Pyramid Oracle repository
Pyramid 2023.10: Your Product Ideas Delivered
Pyramid 2023.01: Your Product Ideas Delivered
Decision Intelligence Blog: How to choose the right calculation method in Pyramid
Pyramid 2023 Issues Addressed
Pyramid 2023: Your Product Ideas Delivered
Decision Intelligence Blog: Leveraging Pyramid Analytics to Migrate to Data Mesh Architecture (Guest Blog)
Decision Intelligence Blog: Reports, Dashboarding and Color Blindness
Pyramid's Product Development Process
New Features – 2020.23
Parent-Child Hierarchy Security
Persisting Visualization Colors
Custom Subtotals
Troubleshooting User Setup and Access Issues
Custom Data Connectors
Multiple Chart Types in a Single Report
Multi-Factor Authentication
Actionable Analytics & Custom Workflows
Numeric Formatting in Pyramid
Report Personalization
Automated Key Driver Analysis
Maintaining Data Models
Creating Parent Child Hierarchies
Cumulative Totals
Pyramid 2020.20 Issues Addressed
Implementing row level security on any database
Time Intelligence: How date lists and ranges accelerate insights
Time intelligence: Custom calculations for greater perspective
Time intelligence: Date-time calculations made simple
Time intelligence: Date-time groupings for better visibility
Time intelligence: A critical element in all analytic projects
Calculating differences without code
Pareto Analysis: Using the 80/20 Rule
Stop Writing Code: Running Totals Made Easy
Amplify your feedback: Pervasive Collaboration with Pyramid
Actionable data insights in minutes—not hours
Learn and predict with Python and Pyramid
Forecasting with Python and Pyramid
Fine tune your forecasts with advanced controls
Comprehensive forecasting with Pyramid
Data-driven dynamic tooltips that add even more context to Pyramid dashboards and reports
How to deploy enterprise-grade “Virtual” Python environments using Pyramid
Data driven messaging to tell a better analytic story
First-class Python integration in Pyramid
How to deliver outstanding analytic performance and scalability on Exasol
“Guided” Analytics using Pyramid
How to build an “analytics lake” using Cross Model Mapping
2020.10 Feature Focus: Content Migration Tools
How to build data-driven infographics that tell a better story
Smart report bursting with triggers and repeaters
Delivering impact: Report bursting and distribution with Pyramid
Dynamic Scaling of Analytics with Pyramid on Kubernetes
Embedding with native HTML5
Hybrid Data Connectivity via Pulse
Smart Insights on ANY Data Source
How dynamic KPIs provide better views into constantly changing datasets
Gaining control of your data with Master Flows
Custom Maps and Coordinate Systems
Pyramid's game-changing NLQ Chat Bot lets users analyze data in whole new way
Faster processing and reduced resource consumption with incremental data refreshing
Pyramid 2020.13 Issues Addressed
2020.10 Feature Focus Datavard Glue: SAP ERP Data Modeling
2020.10 Feature Focus: Audit Trail Framework
2020.10 Feature Focus: Present Lite
2020.10 Feature Focus: Flow Grids and Flow Charts
2020.10 Feature Focus: Data Catalog - Toolkit (Part 2)
2020.10 Feature Focus: Data Catalog – Self-Building Capabilities (Part 1)
2020.10 Feature Focus: Ragged Asymmetric Queries
2020.10 Feature Focus: Calendar Slicer
Creating an IMDB Time column in the Model designer
How to create a Week to Date or Parallel Periods list, for a week that starts on Sunday when using a sql data source
Creating a Date Time intervals in Data modeling tool
How to apply Cumulative Function (Percent of Total) of rows/columns in Charts.
Pyramid 2020.10 Issues Addressed
Real self-service BI for SAP BW and HANA for Pyramid Customers
Database Write Back
Improving Windows Authentication and Kerberos Delegation
The seven success factors of time intelligence
Pyramid 2020.02 (Service Pack 2) Addressed Issues
Pyramid 2020.01 (Service Pack 1) Addressed Issues
Pyramid 2020 Addressed Issues
How to connect Google Sheets to Pyramid
Pyramid Usage Model and Analysis
Analysis of streaming data with Kafka.
Calculating Moving Averages in Pyramid IMDB
Union: Adding Attributes to a Node
How to leverage URL and Email Attributes in Actions
De-Duplicating Data Sets with Pyramid
De-Duplicating Data Sets with Python
Reading HTML Tables from Web Pages using Pyramid and the Python Source Connector
Cube design tip
Pyramid's Calculation Engine Explained
Setting up security roles for Analysis Services with Pyramid
How to use "Custom Colors" in the "Color" Drop zone to set a specific color to a specific value in a grid.
Pyramid 2018 Geospatial Shapes summary