MarkSnodgrass Coach

You might try forcing a convert to the date data type to make sure MySQL is properly reading them as dates.

@user094816 you can do this very easily in the ETL. See example in the image below. Start with your dataset and then add a Group by tile and do a count of your column you want counted. Add a join tile and connect it to your original dataset and your group by tile. Join on the appropriate key. This will keep all your rows…

Thanks @GrantSmith ! That did the trick. Here is a visual of what it ended up looking like for anyone else who needs to do the same thing.

I extracted the SVG markup from this page http://bl.ocks.org/simzou/6459889 and created a new SVG file. I don't think it is perfect because Domo is picking up 206 regions from it, but you should definitely get you pretty close. Here is the new one. (Note to Domo: Please support SVG as a valid file attachment in the Dojo so…

I found this online. It appears to have all the shapes, but they will likely require some re-labeling. You can do this with Inkscape or any code editor.

You likely can't accept an answer because it was created as a topic instead of a question. I did the same thing earlier because the orange button was initially default to create a topic. @Anna Yardley Can you assist and get this post changed to a question so the person can mark one of these comments as an answer?

@Ashleigh Great idea! Removing the format and changing it to default helped, but didn't quite get it there. See above.

@Ashleigh if you are referring to the y-axis, I am choosing format as number. are you formatting somewhere else?

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…