MarkSnodgrass Coach

I think there are a lot of possible answers to this, but here a few key things to consider: Know your audience - Are you building a card for an analyst that wants to see a lot of detail? Or are you building this for an executive that may just want to see a positive or negative single number? This will help you decide which…

According to this KB article, participant level users should be able to use the plug-in. Use the Domo PowerPoint plugin to pull Domo cards into a PowerPoint presentation. This plugin provides much more power and flexibility than the other available methods for showing cards in PowerPoint. Notes: The Domo PowerPoint plugin…

I'm using Magic ETL 2.0 and have not seen this happen. Make sure you are not relying on preview to determine if your join is working properly or not. You'll need to run the full dataflow to make sure.

I think you can avoid a lot of this using some of the built-in card functionality in Domo. First, have you tried using the Calendar card? It is great for this type of request as it turns a calendar into a heat map and would quickly show you the highest days of the week.…

Here's link describing the floor and ceiling functions. https://www.mathsisfun.com/sets/function-floor-ceiling.html

Actually FLOOR would replace ROUND and it would be outside the average function. Like this: FLOOR(AVG(DAYOFWEEK(`date`)))

Yes, I thought about including floor or ceiling in my reply, but wasn't sure which way you would want to go. I would do some testing and just see what works best for your situation.

Average doesn't work for words, but you could use the DAYOFWEEK function to get the numerical day, average that and then convert that to the day name. Would look something like this: CASE ROUND(AVG(DAYOFWEEK(`date`)),0) WHEN 1 THEN 'Sunday'WHEN 2 THEN 'Monday'WHEN 3 THEN 'Tuesday'WHEN 4 THEN 'Wednesday'WHEN 5 THEN…

Converting your page to a Dashboard Page will ensure that everyone has the same layout of cards. You can do this by clicking on the wrench in the top right corner of the page and select Design Dashboard.

When you create a beast mode, you have the option to click the checkbox "Share Calculation on Dataset" which is just above the Save button. This will allow you to have one beast mode but be available on any other card that uses that dataset. 

Yes, you can do this by changing the interaction. 1. Edit your dashboard 2. Click the Edit Content button in the top-right corner of the cards that would be used to filter and select Change Interaction 3. On the right-side, click Apply to Selected Cards and choose the cards on your dashboard that should interact with the…

This video provides a nice walkthrough of building a nice story page: https://www.domo.com/help-center/videos/watch/yXFS2uvD5Es/cat/PLc_JazWEwlVqiRoWcbD5My1Bw0_IpMX8z More videos can be found here: https://www.domo.com/help-center/videos/label/dashboards-and-cards Domo created a couple real-life examples regarding COVID-19…

In order to do what you want to do in a Beast Mode, you will have to get a feature turned on by your CSM that isn't on by default. Ask them to turn on Window Functions for Beast Modes. Alternatively, you could accomplish this by using a pivot table card and put your Year field in the columns list. This would break up the…

The Pivot Table card has a chart property called Totals and you can select Show Total Rows as well as Show Total Columns.

Can you post an example of what is in that cell? Is it something like <a href=....>link name</a> ? You could write a beast mode to extract the portion in between the HMTL tags if that is what is in there, but I would need to see an example of what is there for sure. Also, are you using the HTML table card right now? That…

if you are using a table card, just go to the Chart Properties and select Show Total Row. Here is a link to the KB article that tells you all the things you can do. https://domohelp.domo.com/hc/en-us/articles/360043429573-Table-Chart

Domo's version of MySQL doesn't allow for the LAG function. However, you can use Magic ETL and use the Rank & Window tile to accomplish this. It will also likely run much, much faster if you have Magic ETL 2.0 in your instance. Here's a link to the KB…

You can combine multiple datasets in a dataflow (Magic ETL) which would create a single output dataset that you would use for the card. You could certainly have a dataset that has the list of reasons you want to include and then do a left join to your main dataset to develop your include/exclude list and create your totals…

Ah, sorry, I didn't catch that nuance in your example. I'm not sure how dynamic you need it, but you could create a beast mode that sums the rejected quantity based on which reasons you want to look at. It would look like this: CASE WHEN 'Reason' IN (<your list>) THEN 'Rejected Quantity' ELSE 0END You would then drag this…

You can do this very easily at the card level and not need to do anything at the dataflow level, which will give your user the most flexibility. For example, create a table and drag in the date, rejected quantity, and checked quantity into your column list and change the aggregation to sum for both of the quantity columns.…

It looks like they follow the color used for the x-axis. If you create a color rule for you x-axis field, the color you use will also be used for the min, max, average lines. Would be a good idea to allow it to be a chart property like the zero line. You could submit that as an enhancement in the idea exchange section of…

When creating a color rule, you can choose if you want to apply it to just that card, or to all cards that use that dataset. If your story page is only using one dataset, then you could build the rule once on a card and tell it to apply to all cards in this dataset and you would be done. If you have multiple datasets in…

The issue is that you are using double quotation marks in your then statement. It should be single quotes like this: CASEwhen `Active days` >= 90 then '90+ Days'when `Active days` >= 60 then '60-90 Days'when `Active days` >= 30 then '30-60 Days'when `Active days` < 30 then '<30 Days'end

You should be able to paste your SQL into a basic text editor and make sure word wrap is turned off and then look for position 888. You could also post your SQL in this forum and people are happy to help you find the issue with your syntax.

To add to @GrantSmith 's solution, you may want to use some group by tiles along with the join tiles to get the totals you are looking for (it's unclear to me if data was already aggregated). Here's a screenshot of what that would look like. 

You could do this pretty easily in a beast mode with like this: CASE WHEN `emailaddress` LIKE '%@mydomain%' THEN 'Yes'ELSE 'No' END If you have Magic ETL 2.0, then you can use the formula tile and include this in there and that would work well. If you think you might need to edit this formula often, making it a beast mode…

I would check if you have anything in the sorting properties. That can throw off Domo's ability to count distinct.

I had a similar issue a while back. I believe it is a bug, but I didn't bother to submit a case for it. I wish I could remember exactly how I solved it, but I believe it had to do with row height and sorting. I would suggest making a copy of the card and then click the reset all chart properties button and remove all…

It looks like you didn't complete adding the transform in the workbench. Once you select the Shift Data Timezone Transform, click the + sign next to it. This will open up a new window and have you select which timezone your data is currently in. Select the Eastern Time Zone and then click Apply. It should then be listed…

When Domo receives timestamp data, it assumes it is in UTC time and then applies the necessary timezone shift to match what your company settings are. You can see what time zone your instance is set to by going to More - Admin - Company Settings (assuming you have access to this section). If your Excel file is storing…