-
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.
-
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…