MarkSnodgrass Coach

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

@user077529 you would do isRegistered IS NULL and isregistered IS NOT NULL when evaluating nulls.

@user027926 I think those numbers are telling you how many rows came into that tile, not how many came out of it. So, there were 484,445 coming into the Remove Duplicates tile and after it completed, there were 468,410 rows. It would be a nice enhancement if they showed both the incoming and outgoing numbers for each tile,…

You can create custom summary numbers with a beast mode field. Create a beast mode like this: SUM(CASE WHEN YEAR(datefield) = YEAR(CURRENT_DATE()) AND MONTH(datefield) = MONTH(CURRENT_DATE()) THEN targetfield END) You may need to tweak slightly to fit your data, but this field should be available in your summary number…

Unfortunately, not that I have seen. Would be a nice enhancement. I have seen workaround for this where you create a dashboard page and create some single value cards to show the counts you want and put them around your main card. The interactive filters will allow you to keep all cards in sync if someone filters on…

I would suggest creating a Magic ETL and clean your data so that you have a numeric column and then you can use the built in chart properties to total different columns. You could also create a beast mode field to do the same thing. Replace your N/As with NULL should allow for proper counting.

You could mask individual fields by doing something like this: CASE WHEN SUM(COUNT(DISTINCT `ratingid`)) OVER () >= 7 THEN `comment` ELSE 'xxxx' END It would be nice if you could do a case statement like this and put it in the filters, but that feature isn't out yet. I believe I saw in DP21 that it is coming soon.

I would check your company's e-mail quarantine and seeing if it is getting stopped there. Sounds like it might be getting falsely identified as spam and is getting quarantined.