-
Any type of "HTML Decoding" built in anywhere?
If I have HTML in a text column, is there any built-in functionality to parse that? For example, if my data field contains "Employee<br>of the Month", can I have it show as Employee of the Month Is that a job for BEAST MODE?
-
How do I create a filter to show only the UPPERCASE records in a spreadsheet?
I am importing a CSV file. It has both UPPERCASE and lowercase entries in a single column. I would like to filter out all the records that are not UPPERCASE. The end result would be that all mixed case and lowercase entries would NOT be displayed.
-
Conditional Formatting Workaround in Pivot Table
Hello, Context: In my organization, my role is cardbuilder. I have built a pivot table and ran into some issues with conditional formatting. In my table, I have Daily Budget and Net Cost as two columns broken out by day. Ideally, I wanted the Net Cost column to turn RED (could be font or background - just something to flag…
-
Color Formatting Pivot table
I have a pivot table that shows the sales by location for each month. I need to highlight the maximum sales month for each location. I have used Html conditioning formatting on a single column, but since this is a row-level comparison I am not sure how it can be done. Here's what I have Here's the desired output I am…
-
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.
-
Customisable Layouts for One-Off/Scheduled Email Reports
Currently, there's the single template generated when wanting to send a dashboard or card to others. It would be great for users to be able to make adjustments to the style and sections of the email, in a preview mode or similar, before sending. Customisation options can include: 1) A catalogue of template options and…
-
Ability to wrap text on header row of mega tables
Would love to see the ability to wrap text on the header row of a mega table. Anyone else?
-
Allow for y-axis scaling on 100% stacked bar
There are occasions when the data that I am looking at doesn't vary much until the top of a chart. Including the entire chart can then make it difficult to differentiate between the changes of a single or multiple bars. It would be helpful to isolate these values by allowing the y-axis of a 100% stacked bar chart to take…
-
Tickbox that when selected, a card requires a page filter to populate
Hi, I'd love an option in chart properties that would mean that a card will not display any data if no page filters are applied to the page. It would simply display as an empty string or possibly, in a similar style to the customisable "No data Message" field; a customisable text could populate the space. Often our users…
-
Poor Format of Emailed Cards/Dashboards
Hi All, Does anyone else struggle with the suboptimal format of emailed reports when viewing on mobile? In particular, there is a lot of dead space at the top of the email. I feel like it discourages recipients from scrolling down and viewing the actual data contained in the report. Attached is an example. I thought that…
-
What does the "Use Raw Numbers" setting for email connectors do?
Recently, we ran into an issue with one of our email connector datasets where a "Currency" column was being formatted as a string which was causing issues down the line in other dataflows. We're not sure how the problem initially started, but we found that enabling the "Use Raw Numbers" setting seemed to fix it and…