-
Conditional Formatting
Hello, I've seen some other posts about conditional formatting, but they involved html and I have extremely limited coding ability. I'll explain what I'm trying to do below in case there is an easier way or I'm not approaching it from the right angle. Thanks in advance! Say I've got two variables: 1. Sales Quota 2. Actual…
-
How to change the data labels in the legend and chart
I don't want the percent values on my pie chart and legend to have any decimals. In "General" I changed the Value Decimal Places and Percent Value Decimal Places to "None" but that only changed the hover labels. Is there a way to change the auto-generated percentages to only display whole numbers?
-
generate url if condition is met
I have 2 fields: * has_preview * Preview_url for the Preview_url field I am using beast mode: CONCAT('<a href=', CONCAT('https://full_url_',`presentation_id`,'.mp4 target="_blank"'), '>','Preview', '</a>') I only want the 'Preview_url' field populated if 'has_preview' field has a value of 'yes'. Any ideas how I can achieve…
-
Using Multiple Summary numbers, Concat() HTML for color rules, how to get all numbers on same line?
See attached screenshot. Trying to use multiple summary numbers and get the numbers to line up alongside each other (KWH KAU DBA ect), rather than stacking. Beastmode to generate numbers: CONCAT( --KWH (CASE WHEN ((COUNT(CASE WHEN `Analyzer_Domo_Property__c` = 'Timbers Kiawah' THEN `Campaign.Name` END)) / MAX(CASE WHEN…
-
Maps not displaying percentages correctly
Has anyone seen issues with displaying Percentage formats in Maps? Specifically, I want the data and the legend to display as a percentage, however, I can not get the format to stick. When I edit the STATE VALUE format to display as a Percentage (and check multiple by 100), it initially displays correctly as a percentage…
-
Gradient Conditional Formatting
Is there a way to do conditional formatting with colors based ont the other values in the column? Excel has an easy way to do this with one click.