MarkSnodgrass Coach

Domo uses MySQL 5.6, so any time you wonder what syntax you should use, just google the reference docs for MySQL 5.6. Looks like you need to use the LIMIT clause in MySQL, so your query would need to be changed to this SELECT `Item Trim_Fill Rate`, `Trim Whse`, `Ship Date` FROM `copy_of_cuts_w_forecast` JOIN…

Have you tried using the MIN function on the date field you want the earliest date from?

@user048760 If you have the Magic ETL 2.0 beta, you can set as Date when you click on the input dataset configuration. If you have the regular Magic ETL, you would add the Set Column Type tile and select your column and tell it to use the type of Date.

Unfortunately not. I think it is Domo's way to give you a quick glimpse of what the card will look like, even though it rarely correctly selects the fields that you intend to use. You can turn off the auto preview option when in the Analyzer, which will make it quicker for you to change what fields you want to include in…

@user048760 I use that same connector with the append and I use the batch_last_run to identify the groups and when they were added. There are a variety of date format options you can use in the Analyzer and in Magic ET if you want to get rid of the time portion of the batch last run column. In Analyzer, when you add the…

Great work @sem ! Glad I was able to help.

I'm not sure you will be able to do this in Analyzer/Beast Mode, but I will help you as much as I can with the following information. First, you will need to ask your CSM to enable Window Functions in Beast Modes if you haven't already done that. To get your percent of total, you would need to create a beast mode like…

You should look at the Domo Governance / Domo Stats datasets that are available in the app store. Search the app store for Governance or Stats and you will see the different datasets that are available to you. They provide a lot of this information for you as well as some pre-built cards. You can then tweak the cards if…

You should look at the Domo Governance / Domo Stats datasets that are available in the app store. Search the app store for Governance or Stats and you will see the different datasets that are available to you. They provide a lot of this information for you as well as some pre-built cards. You can then tweak the cards if…

Yes. That is the correct way to do it in SQL. I prefer Magic ETL because it tends to run faster.

In Magic ETL, you can use the Group By tile to create a count of courses by staff person. In the Group By tile configuration, select Staff in section 1 as the column to identify the grouping. In section 2, label the column count (or whatever makes sense to you) and choose Course for the column and choose Count Distinct…

@GrantSmith wouldn't that update all rows with the current timestamp rather than just the latest rows that were appended? It seems like you would need to utilize a recursive dataflow to apply the current date to the new rows that were appended. @user048760 Which connector are using to bring your data in? There are a couple…

I would create a basic Magic ETL dataflow and apply your filter in the ETL and then you can export the resulting dataset.

I tried setting color rules on a basic stacked + symbol card and it looks as though the color rules don't apply to symbols. They only apply to the bars. That is an unfortunate limitation. I would submit this in the Ideas Exchange section of the Dojo to make that an option. Not sure why they would limit it.

The Domo Webform is where you would typically maintain information, but unfortunately, it does not have any validation capabilities or ability to create a dropdown list. You could build a custom app if you really wanted to maintain this information in Domo. You might also consider using one of the SharePoint Connectors in…

Yes it is. The filter views don't see beast modes any differently than regular fields that are a part of your dataset.

Have you tried using the pivot table card and see if it allows you to group how you would like and turn off the subtotals?

You can't do a count distinct inside of another count distinct. Also, unique id will always equal unique id because it evaluates by row and so you are comparing the value to itself. Have you tried just COUNT(DISTINCT 'Records')) That actually seems to be what you are after if you have the customer id as one column and then…

Technically, window functions in beast modes aren't totally supported, which is why they aren't enabled by default. Considering you have 3 questions posted in the Dojo and they are all centered around window functions not working beast modes, I think you should strongly consider building an ETL or two that gets the data…

Try changing your Hour beast mode to be the exact same as your partition. You might also want to check the date filter under previous month and make sure it isn't grouping by something that would throw it off.

You could try this: AVG(COUNT(DAYNAME(date))) OVER (PARTITION BY DAYNAME(date)) I would also suggest you consider a different visualization and potentially save yourself a lot of work. The calendar chart type is very useful in showing the most popular days of the week. You likely wouldn't have to do any beast modes but…

Does avg(COUNT(DISTINCT `Permalink URL`) OVER() work? I tested AVG(COUNT(DISTINCT field)) in my instance and that failed until I added the OVER() clause and then it returned a result. If that works, then it seems like the issue is narrowed down to the PARTITION BY statement. Also, I'm assuming yes since you are writing a…

Last 3 years will include the year you are currently in. So, it would currently be 2021, 2020 and 2019.

@nj-John-mirc Yes, they can. See screenshot

There is not a way to preserve the color in an SVG file that I am aware of. However, you may want to look into color rules and the new diverging colors feature and see if that works for you. https://knowledge.domo.com/Visualize/Adding_Cards_to_Domo/KPI_Cards/Building_Each_Chart_Type/Heat_Map

@Gor_Gonzalez , you're welcome! If you can mark the answer as accepted, it will help others in the community.

@user052846 when a result is blank, that can often mean one of your fields has blank values. Are both of the fields populated in every row? If not, I would add some additional logic to handle that. Another troubleshooting step is to break apart your calculation and see if you are getting what you anticipate. Try just doing…

@faisalnjit I came across this KB article that might work for you. Read the section called "controlling chart colors using beast mode". You might be able to create a calculation that determines what 25% of your other number is and enter that as a goal and then set a color if it is below the goal.

@user000253 To handle the sorting, create a second beast mode with the exact same logic, but replace your when statement with numerical values. Drag this new beast mode into the sorting area and make sure aggregation is off and it is sorting ascending.

For the text search, have you tried CASE WHEN 'Note' LIKE '%Bankruptcy Record Dismissal%' THEN 'Dismissal' ELSE 'Other' END' For the number masking, you can probably do it with regex. You could also use multiple replace functions to replace each number with a #, such as this:…