How to create a Correlation matrix?
Can someone help me with instructions on how to create a correlation matrix card in domo?
I am attaching an example for a correlation matrix.
Thanks
Sirisha
Comments
-
I am making the assumption that you already have the data for the Correlation Matrix, therefore you need help putting it in a card with the color mechanism.
You can do that by using a Table Card and then creating a Beast Mode for each column. Here is the code for the MPG column:
(CASE
WHEN `MPG` >0 and `MPG`<.5
THEN CONCAT('<div style="background-color:lightblue; color:black; width:100%; height:100%; position:relative; margin:-50px;padding: 50px">',`MPG`,'</div>')
WHEN `MPG` >=.5 and `MPG`<.75
THEN CONCAT('<div style="background-color:darkblue; color:white; width:100%; height:100%; position:relative; margin:-50px; padding:50px">',`MPG`,'</div>')
WHEN `MPG` >=.75 and `MPG`<1
THEN CONCAT('<div style="background-color:red; color:black; width:100%; height:100%; position:relative; margin:-50px; padding:50px">',`MPG`,'</div>')
WHEN `MPG` >= 1
THEN CONCAT('<div style="background-color:lightgray; color:black; width:100%; height:100%; position:relative; margin:-50px; padding:50px">',`MPG`,'</div>')
ELSE
CONCAT('<div style="background-color:white; color:black; width:100%; height:100%; position:relative; margin:-50px; padding:50px">',`MPG`,'</div>')
END)What I am doing here is testing the value of MPG and then creating an HTML DIV that provides the color.
If you create a Beast Mode for each column then you place the Formatted Beast Mode in the Table card and it will render the color from the DIV tag.
See the attachment of the card I built.
0 -
@Sirisha_Sindiri, did @smurray's reply help you out?
0 -
Hi @LizWR,
@smurray 's answer did help me to some extent. I came to know that html tags can be used to improve my cards and thanks to @smurray for that.
However, what I did not understand is how to get the column names in the top row and first column in the table card. Am I missing something here?
Please look below to understand how I have my data. In the below example, I have shown date as an example filter. I really appreciate your help.
From Type To Type Value Date MPG MPG 1 1-Nov MPG MPG 0.8 1-Dec MPG Reliability 0.22 1-Nov MPG Reiability 0.34 1-Dec Thanks
Sirisha
0 -
Hi all,
Can anybody help out @Sirisha_Sindiri?
Thanks!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.9K Visualize
- 2.5K Charting
- 738 Beast Mode
- 57 App Studio
- 40 Variables
- 685 Automate
- 176 Apps
- 452 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 124 Manage
- 121 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