MarkSnodgrass Coach

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

You can do this very easily with the color rules. In the Chart Properties, click on Colors and then create a rule based on y-axis field that if the value is less than 25 then color it read. You can read more about color rules here:…

You would just create multiple WHEN statements. You can have as many WHEN statements as you want in a CASE statement. Yours would look like this: (case when (`Distributors`='DistributorA' and `Country`='CountryA') then 'Distributors' when (`Country`='CountryB') then 'Distributors' else 0 end)

That is a definite shortcoming. That would be worth submitting as an enhancement request to allow for date formatting. In the meantime, I think you can still get your card to work by using the tooltip fields. Create a couple beast modes that have the dates that you want in the format you want and put them in tooltip fields…

They are likely following the format of the time period field. Click on the pencil icon in your time period field and choose format and try date shorthand and see if that changes how it is displayed.

You can create a beast mode that assigns a value to each Job Type and then put that beast mode field into the values field. Then, use the ranges chart properties to assign colors to the values that you created. Example beast mode: CASE WHEN JobType = 'a' THEN 1 WHEN JobType = 'b' THEN 2 .... END Example Range Properties:…

In Magic ETL, you could do a group by tile that calculates your first average, you could then use a rank and window tile and rank by your new average field descending. The row with a rank of 1 would be your highest average.

If you are adding together multiple values and one of them is blank or null, it will not be able to add them all together and just produce a blank value. You would need to do this: IFNULL(likes,0) + IFNULL(shares,0) + IFNULL(comments,0) in order to add them together. If the fields aren't actually null, but blanks, you…

I just created a sample dataflow to confirm what I have been saying. See image below. I have a dataset that has 15 rows. I added a filter tile that filters out 3 rows. Notice that it still says 15 rows processed next to filter rows. This is how many rows came into that tile. The result of the filtering resulted in 12 rows,…

You could test with some sample data by making up a basic Excel file with 10 rows or something and run it through a few of the same steps in your current dataflow and see how the numbers look. When I looked at one my dataflow details, that is what I deduced: that it is telling you how many rows it processed (looked at),…

I played around with a pivot table card on one of my dashboard pages, it looks as though the chart display setting has to be selected in order for the summary number to be displayed. I'm not sure why Domo would decide to require that. It could be viewed as a bug, in which case I would suggest creating a case with support.…