MarkSnodgrass 🥷

About

Username
MarkSnodgrass
Location
Portland, Oregon
Joined
Visits
3,868
Last Active
Roles
Member, NLC
Points
4,466
Badges
51
Social Media
https://www.linkedin.com/in/mark-snodgrass-bab17968/
Location
Portland, Oregon

Comments

  • In the Data Center, you can click on the Warehouse icon (the cube) which displays the spinning graphic of your data sources. In the upper right corner, it shows the total rows, number of data sets, number of data sources.
  • Make sure your date range is set to graph by month and that you don't have the date field in your sorting properties as that will keep it from aggregating properly. Also, make sure metric is set to Average in the aggregation type.
  • I think Domo's best practice for dashboards is to avoid having a long page that involves a lot of scrolling (and would require a TOC at the top), but have a landing page with some key cards and icons/images that would take you to additional dashboards. You can them them all the same so it feels cohesive. This Domo video is…
  • Assuming you have data in every month, you can accomplish this with a group by tile followed by a rank and window tile. Use a group by tile to group by your month/year (as a date field) and choose Average for your aggregation type. Add the Rank and Window tile and choose the Lag function and create a column called Previous…
  • When you have multiple items to clean, you will have one case statement and multiple when statements, like this: case when Right(`Entry Store`,5) = 'PTO"}' then 'PTO' when Right(`Entry Store`,5) = 'VAC"}' then 'VAC' when Right(`Entry Store`,5) = 'SIC"}' then 'SICK' when Right(`Entry Store`,3) = 'OTH' then 'OTHER' end you…
  • The period over period chart types are pretty limited, which is why people often create other ways to compare periods. Here is a link to a video I did showing another way just by creating a few beast mode fields: https://youtu.be/mDwSQGAjIrs @GrantSmith has also created this post that walks you through creating a date…
  • You could use the Heat Map card type that is found under Popular Charts to create something similar. Here's the KB article for it. https://domohelp.domo.com/hc/en-us/articles/360042924634-Heat-Map
  • @Silambarasan_3008 if you haven't watched this walkthrough on building a dashboard, this is helpful. It's probably the nicest dashboard I have seen. https://www.domo.com/help-center/videos/watch/yXFS2uvD5Es/cat/PLc_JazWEwlVqiRoWcbD5My1Bw0_IpMX8z
  • That's odd as my pivot table cards have the headers frozen at the top as I scroll down through the data. It seems like it automatically does it for you. Did you try it out, or are you just looking for the chart property since it is a property in the mega table?
  • You can actually do this quite easily with beast mode to ensure that you are only showing the same amount in each month. (CASE when DAYOFMONTH(`date`) <= DAYOFMONTH(CURRENT_DATE()) THEN 'Include' ELSE 'Exclude' END) You can then drag this beast mode into your filters and filter on Include. You can let your date range be…
  • I believe there is a glitch right now with the filter tiles. The way I have gotten around it is to use the formula function in the filter and then wrap the date function around each item so that it sees them both as dates. Like this: DATE(`mydatefield`) < DATE('6/30/2021')
  • Is there anything in your Sorting properties? This can affect Domo's ability to aggregate and count distinct records.
  • It appears that the slicer chart type is quite limited on hover text capabilities. There is no option for you to do what you want for that chart type. You can have it display the same name as the slice on hover, but that is it.
  • Have you looked into the dataset via e-mail connector for this process? Using this connector would eliminate the need for the Box connector and you can use your Outlook rule to forward and append or replace the dataset. You can read more about it here:…
  • You would want to use the formula tile in Magic ETL to do this type of conversion. If your list is quite long, another option would be to create a lookup table with a Domo Webform or a spreadsheet that has your IDs and the name you want them to be changed to. You would then use the Join tile in Magic ETL and join your main…
  • That is interesting and does sound like a bug that is worth reporting. You could use the formula tile in the ETL to have one column that is the original name and one column that is named for how you are using it in other places.
  • @lweiler doing some quick testing, it looks like you need to have something in the optional group by field in order for it to calculate the value change correctly. I would drag Company Name into the group by field. As an example, I created a test dataset that had one row with three fields (description, value, target) and…
  • Have you tried dragging one of your zip code fields or the actual fips code into the "select county fips code" field? It is expecting one of those values rather than the state name to properly populate. I would also suggest select the aggregation type to SUM for the field in the "select county value" field. Hope this helps.
  • Agree with @RobSomers that you should submit it to the Ideas Exchange as the gauge should have that feature. I have found the comparative gauge a bit too limited. I tend to use the multi-value gauge, which has a lot more customization options and can show the value or percent difference between two values.
  • Often when a field doesn't come in as the type I expected, I use Magic ETL to cast it to the appropriate type and then use the output dataset for my cards. There are a couple ways to do this in Magic ETL, on the input dataset, you can click on Configuration and then on Data Handling and then change the field to the type…
  • Domo's beast mode doesn't like the BETWEEN clause. Also, you are missing the THEN statement just before 'Large'. Try this: CASE WHEN `Variable Name`<= 1 THEN 'SMALL' WHEN `Variable Name` >= 1 AND `Variable Name` <= 1000 THEN 'MEDIUM' WHEN `Variable Name` > 1000 THEN 'LARGE' END
  • No, you should select Flag. Under my replies, you should see something like this: Click on Yes to accept it as an answer.
  • @Keisuke_n01 that's great to hear. If you can mark accept any answers that helped you, that will help others in the community.
  • You can create a beast mode that will look at the current date and then move it back to the last day of the previous week and then compare it against your date field. CASE WHEN `date` <= /* last day of the previous week */ DATE_ADD(DATE_SUB(CURRENT_DATE(), INTERVAL 1 WEEK) , INTERVAL (7- DAYOFWEEK(CURRENT_DATE())) DAY)…
  • If you want to prevent all lines and bar from showing future dates, you can create a similar beast mode and add it to your filters like this: CASE WHEN `Date` < CURRENT_DATE() THEN 'Historical' ELSE 'Future' END Drag this beast mode into your filters and filter to Historical. This will keep your chart from showing any…
  • One possible solution would be to leverage the fact that you can send a text message via e-mail. See this article here to know how to build the address for your cellular provider. https://www.digitaltrends.com/mobile/how-to-send-a-text-from-your-email-account/ You would also need to create a new user in Domo that has that…
  • You might try using the Transpose option in the General Chart Properties.
  • You could create a beast mode based on your date field by doing something like this: CASE WHEN MOD(MONTH(`date`),2) = 0 THEN CONCAT( DATE_FORMAT(DATE_SUB(`date`, interval 1 month),'%b'),'-',DATE_FORMAT(`date`,'%b')) ELSE CONCAT( DATE_FORMAT(`date`,'%b'),'-',DATE_FORMAT(DATE_ADD(`date`, interval 1 month),'%b')) END You…