Formatting

Is there a way to force a column header to be blank?
When formatting a column "Data Label" in a table chart from the formatting drop down where you would format justification etc. - you are able to override the column name with more plain english. However, in some instances, I've wanted to override the column name with nothing, i.e. have a blank column header, especially if…
Correcting date format in Magic ETL
Hi all, First time posting here. I need to know how to correct date formatting within a dataset. The dataset was pulled from Google sheets. As you can see, in ETL the formatting is wrong and inconsistent. How can I correct the format in ETL and make everything streamlined and compatible in the analyzer? Thanks
Attempting to create unique rows for each possible value in a chosen column
Our business model currently offers multiple product options. I'd like to create brand new rows for each customer, 1 for each product, whether they own that product or not. My thought is to use new columns and then use a dynamic unpivot. Need help creating the new columns first though.. Currently have this: Account Product…
Is it possible to add context to legend entries
Is it possible to add context to legend entries? For example if my legend breaks things down as: pending, in-transit, out for delivery I want to be able to add hover text that says something like: pending: at the warehouse, pending shipping label creation in-transit: with delivery partner, moving between shipping…
How do I change the data from being horizontal to vertical using a calculated field?
My data is currently horizontal so each column has a different month with the totals below (example below). I would like the data to be vertical so that it is easier to display the data visually within domo. I have placed an example below. I am not sure how to make a calculated field to display the date and totals…
ZIP code leading zeros being removed in dataset
I have a dataset and one of the columns is ZIP codes. The leading zeros are being removed when uploaded to DOMO. Any way to change the column's formatting or to prevent the zeros from being truncated?
New Descrition format
Hello all, We use to format our descriptions with some information and was formated in a easy to read format, but in this new version was all tranformed in a 1 row, no spaces, bunch of data. we went from this.- to this.- is there any way to apply formating to this new feature?
Can I nest a Select Distinct function in a beastmode?
Relatively new to all of this, but I'm working on a beastmode that calculates the average tenure of active employees within my company. The data I'm pulling from includes a lot of duplicate system id's (employee id's). I need to filter out these duplicates in order to get an accurate average. I've written the formula in a…
changing a name in ETL
I have an employee name in my raw data shown as >>> last_name, First_name middle_initial Doe, John H. or sometimes shown as >>> Doe, John Dorian H. How can I make it so it would appear as >>> John Doe or John Dorian Doe in DOMO using ETL or beastmode? Thanks
How to fix different number formatting - thousands separator
In my ETL preview, I see the field Case Number as I want it, without Thousands Separator. When I then Run and check the actual Data table or drill in Cards, then the Thousands Separator is there again. Where can I change this setting? I would like to be able to copy the Case Number and paste it in the Search of Salesforce.…
Is it possible to formatting the style of a report that is sent via email?
Hi, I've my domo dashboard with a specific background, however when sent it as a report via email, it's not showing the background in the email. Any ideas if this is something I could change? Thanks
Write a Filter Formula using Magic ETL Filter Tile
Hey guys, so I am trying to utilize the filter formula feature in magic etl, but I can't seem to get it to work. When I run the following formula, no data appears. Using Excel, I performed a concatenate on all 517 websites that I would like to be filtered out from my data in order to build my formula. I've also used AND as…
Red to Green Heat Map
The red to green heat map is the gold standard of color formatting in the business world. The current single color pallets are....not good. It would be great to have this option as a default for any column in any kind of table. Thank you for your consideration!
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.

Formatting

Discussion List