MarkSnodgrass 🥷

@Shwane when your string has an unknown amount of phrases you are looking for, you are going to need to use Magic ETL to break it up. I created a video on how to do this. In my case, I am looking for spaces, so you will need to change that and look for the hashtag, potentially. Here is a link to the video:…

Use the CASE statement to do this: CASE WHEN TRIM(LOWER(`email1`)) = TRIM(LOWER(`email2`)) THEN 'Match' ELSE 'No Match' END Using TRIM and LOWER will also help to ensure that it evaluates properly.

Sounds like you have a pretty good handle on it. Have you already played around with the data label settings when you using the custom chart? You can have the value show on top of the cell or a tooltip field value. That might solve your data label issue if you haven't already tried this.

@Stuck I'm glad you have found my videos helpful for you. In this case, I don't think the custom chart is going to work for you as each square in your grid would need to be labeled and the data then has to match it and there would be not sorting capabilities. I wonder if the heat map chart type would work for you. I used a…

Domo added a Risk Heat Map card type a few months ago. Have you tried using it? Here's the KB article. https://domo-support.domo.com/s/article/7506837994007?language=en_US

Since you are sending this every Monday, you can use this beast mode and put it in your filters and then filter to Include. CASE when `date` >= DATE_SUB(CURRENT_DATE(), INTERVAL 14 day) and `date` < CURRENT_DATE() THEN 'Include' ELSE 'Exclude' END You would need to change date in my example to the actual date field in your…

@NateBI even if there are no conflicts, in the Rename To box, you can type whatever you want, so you can type in the tablename.columnname for each column. It is manual, but that is how you would accomplish what you want.

On the join tile, under step 3, you can click the + sign to make as many alterations as you want on column names by choose the rename option. It defaults to the name of the tile before it followed by a period and the column name. You can edit it to however you want.

You will want to use the DATE_SUB function to subtract days from a given date. It would look like this: Case when 'ID' = '1066' THEN DATE_SUB(`Maturity Date`, INTERVAL 45 day) when 'ID' = '1019' THEN DATE_SUB(`Maturity Date`, INTERVAL 55 day) when 'ID' = '2600' THEN DATE_SUB(`Maturity Date`, INTERVAL 66 day) when 'ID' =…

Try putting your actual date field in the row and remove your beast mode one and then in the date range filter, choose to graph by month. This should format it to Month Year and will allow you to sort by date correctly.

I would use the the IP addresses that are listed in this knowledgebase article to add to your whitelist. https://domo-support.domo.com/s/article/360043630093?language=en_US

@gbrown if you are only wanting to show the current month and the next two months and wanting to show the average of those values, I think you could keep it pretty simple by using the last_day function and the date_add function like this: CASE when LAST_DAY(`dt`) >= LAST_DAY(CURRENT_DATE()) AND LAST_DAY(`dt`) <=…

@Ashleigh is a veteran user of CourseBuilder. She may be able to help you.

If you go to the ETL and then click on Versions, you should be able to restore to a previous version where the output dataset existed. https://domo-support.domo.com/s/article/360042923074?language=en_US

You can use the group by tile to sum your quantity by invoice number and then join it back to your original dataset to get the total next to the individual items by joining back on invoice number. Your ETL would look something like this:

@zuchu you are going to need to replace the "date" column with the name of your column that is in your dataset. Also, which card are you using? That may affect if this solution will work for you or not.

You can create a beast mode that you would add to your filters to filter out weekends from your dataset. Your beast mode would look like this: CASE WHEN DAYNAME(`date`) IN ('Sunday','Saturday') THEN 'Exclude' ELSE 'Include' END You would then add this to your filter and filter to Include.

@mlb I believe it lets you choose a date in the date range field when there is no date field added to the list of columns in the table. Once you add a date field to the table, the option to select a field in the date range is greyed out. It is odd behavior and would be worth submitting as an enhancement in the ideas…

@jrtomici I did something similar where I break up words into individual values and then put them on each row. I walk through how to do it in this video. Hopefully this will help you.

That seems like a bug for both of you. I can click on the 3 dots on dataset fields on datasets that I don't own.

@MichelleH and @NathanDorsch I'm curious... in the main data center area, do you have the ability to click on the 3 dots and add additional tags or remove tags on the actual datasets and dataflows themselves? Or is that not there as well?

Very strange. I tested in another instance and I didn't have the issue you are having. Unfortunately, I think you may have to log a support ticket and have them determine what the issue is.

It's worth a test on a dataset you own. I am an admin in my instance, so I can't replicate your issue. @MichelleH and @NathanDorsch are you both non-admins?

Odd... do you have custom roles enabled and possibly don't have the ability to delete tags?

Did you click on the 3 dots next to the existing tag and then choose Add a Tag? You can then remove existing tags in the place where you add tags by clicking on the x next to the tag.

@AndreiA I would try using the str_to_hex function on your id field in the formula tile and then build the rank off of that. This will allow the rank to see those two values as different values rather than the same.

There are a lot of ways to group data in Domo. In your case, I would suggest using the pivot table card to have the months as columns. Here's the KB article that would help you learn how to set it up. https://domo-support.domo.com/s/article/360043429473?language=en_US Hope this helps

@froghunter I did something similar where I am looking at a sentence and breaking it up into individual words and don't know how many spaces are in each sentence. This video walks you through how to do it. You would need to look for \\ instead of spaces in my example. You will also need to do a group by at the end of your…

Those period-over-period cards are kind of different in how they function. I believe your summary number isn't working as you want because your date range filter is set to this year. That keeps anything that would be in the denominator portion of your formula from being counted since that is looking for the previous year.…

@damen what is your date range filter set to? do you have any other filters in place?