ColemenWilson Coach

You can use: '<strong>' & '</strong>' in your beastmode around the part of the summary number you'd like to be more pronounced. You can also use: '<font size="+3">'

This is what I would use: ROUND(DATEDIFF(CURRENT_DATE(),`INFANT'S DETAILS:\nDate of Birth`)/ 30.437) Note that I've also swapped the order of Infants details and Current date in the DATEDIFF() function to avoid a negative number.

Ahhhhhh okay. So what you'll do is split out the associated IDs column using the split column tile in Magic ETL. Then join the last modified dates to each of the new associated id's columns. Then use the GREATEST() function to find the most recent date across the columns for each row: GREATEST(`Associated ID Date 1`,…

Add a new beastmode to put into your sorting: when DATEDIFF(date,published_date) >0 and DATEDIFF(date,published_date) <=29 then 1 when DATEDIFF(date,published_date) >29 and DATEDIFF(date,published_date) <=59 then 2 etc…

Sure thing! You are on the right track, you just need to partition by ID, as shown below: You'll be left with a ranking by date for each ID. So where there are duplicate ID's, lets say 3 duplicates, you'll have ranks 1,2,3 for the corresponding IDs. Then you can use a filter tile to remove anything that isn't ranked 1 -…

You can use a rank and window tile in Magic ETL to rank the rows partitioned by the ID. Then you can use a filter tile to only keep those ranked 1 (most recent).

@JasonNgaiGPT were you able to get this working?

I've gotten close, but I can't get 100% there. I am using a count of the donation_id field and then this beastmode: (COUNT(DISTINCT donor_id) OVER (PARTITION BY COUNT(donation_id))) I can't seem to figure out why that extra row is there at the bottom of the table: I am guessing it has to do with the fact that there are 4…

You could use FIXED BY function(s) that ignores filters: https://domo-support.domo.com/s/article/4408174643607?language=en_US See "Applying Filter Logic" section, use case #1.

What are you trying to group by? It is not clear in your screenshot example. Is it donation procedure? If so just add that field to the table card next to your 2 beastmode fields.

You would create 2 beastmodes and then bring them into your table card: 1. COUNT(DISTINCT donor_id) 2. COUNT(DISTINCT donation_id)

For me I start with KB articles. If I am still stuck I go to the Domo Community forums. And lastly I go to my CSM and/or AE.

The only way is by deleting the achievement itself, which isn’t possible if it is a system default achievement. I’ve requested this before but it would be good to post in the ideas exchange.

You still need to use the filter tile, not the formula tile. However, within the filter tile there are 2 options for filtering: Formula or Filter rule. The filter tile allows for multiple conditions and even a combination of both formula and filter rules. Remove any other conditions/rules and just leave the: `Marketing…

Filter tiles allow for multiple conditions. Have you removed your other filter rule from the filter tile?

That is odd, you can convert it back using the Alter Columns tile.

Using a formula rule in the filter tile would be: `Marketing Category` != 'Total'

If there is some way to uniquely identify that row, then you can do as you suggested and use the filter tile in Magic ETL. There are two ways to filter rows using the tile, with a formula rule or with a filter rule. Here is a knowledge base article that walks you through how to use it:…

Hi Jason, Apologies on the delayed response - I have been out of office. I would be happy to jump on a quick call with you to troubleshoot why this isn't working for you. If you'd like to, you can schedule a time here: https://calendly.com/cwilsondomo

Yep, so basically you would join your data 1=1 so that it looks like this: Then in your card you have your two values: `data` and `comparison data` Users select a year and a comparison year and the data for each will be displayed. I would suggest setting default values for each, for example: 2022 vs 2023 and then from…

Could you provide a bit more information? This is possible, and I have done this - but I want to better understand the type of content you have on your dashboard and how you plan to compare one year vs another visually. The approach I took was to build a dataflow that had comparison data self-joined to the data and then…

You can use the Domostats report called "Scheduled Report Recipients" to see who is receiving scheduled reports.

Hmm the only time that should happen is if, for example, the current time is 3:49 but there is no quote in your data with 49 as the number value. Could you screenshot your beastmode formula? It is still working for me so I am not sure what is going on.

Yep, you would do what @DavidChurchman said and set each of those 3 conditions as conditions in the filter with "Include rows that meet ALL of the following rules" set.

Can you search for the rows that don't match the current format in a dynamic way? If so you could just apply a filter tile to the ETL to remove the rows that don't match. How do you identify the bad rows?

Could you provide a bit more information as to what you are trying to do?

You could create a slideshow of quotes: https://domo-support.domo.com/s/article/360043437793?language=en_US Or you could do this: create a data table with 2 columns: Quotes, numbers 1-59. Use this case statement as a filter on the card with "In" selected: MAX(CASE WHEN Number = MINUTE(CURRENT_TIME()) THEN 'In' ELSE 'Out'…

Are those two columns mutually exclusive? Is it ever the case that both columns will have values in the same row? If not, then you can use: IFNULL(`Maintenance`,`Disruption`) If there are cases where both columns could have a value on the same row, then I would suggest appending your data in ETL so that both columns are…

Can you use 2 criteria for your remove duplicates tile: 'Site Address' and 'Panel'? If not, you can use the Rank & Window tile and choose 'Latest Update' as the order and set 'Site Address' as the partition - here again you can use multiple fields if needed. Next use a filter tile to only keep rows with the rank value you…

Agreed on DATEDIFF(). Also, adding a *1 to a field will force it to a number: Field*1 or (CASE WHEN Field = 'Cat' THEN ID END)*1