MarkSnodgrass Coach

@RocketMichael to get the date of the last complete week, you can use this formula: DATE_ADD(`dt`, INTERVAL (7- DAYOFWEEK(`dt`)) DAY) to get the rolling averages, I will refer you to this post that goes over it. https://dojo.domo.com/main/discussion/52679/domo-ideas-conference-beast-modes-rolling-averages#latest You would…

Depending on what is available in your salesforce instance, you could leverage the JSON Webhook Connector to push data to Domo in real-time. https://domohelp.domo.com/hc/en-us/articles/360042931494-JSON-Webhook-Connector Using JSON Webhooks, you can get access to real-time data from weather devices, vending machines,…

You could consider using the transpose property on the mega table, which essentially pivots your data without writing beast modes. It would turn something like this: Into this:

You can link to any url by creating a table card in your drill path and then construct the proper html tag to build the hyperlink. Here is one example of how to do it: https://dojo.domo.com/main/discussion/52683/domo-ideas-conference-beast-modes-images-and-hyperlinks#latest

Unfortunately, the header and footer only accept static text. You could leverage the smart text feature and have the date built into the title of the card.

Agree with @ST_-Superman-_ . I believe the Excel plug-in is not very widely used and I'm pretty sure I was told that it is going to be dropped once Domo completes their Microsoft Office Integration that they announced at Domopalooza 2022. I was able to connect and download a dataset via the Excel plug-in, but then when I…

@ST_-Superman-_ LOL! I'm glad it helped you do some cleanup. I agree with you on the documentation. This function and others show up in the formula tile in Magic ETL, but not when you scroll through the list when you are creating a beast mode in Analyzer. Scroll through the list when you are in Magic ETL and you will see…

I would suggest using the split_part function to extract this. split_part( split_part(`Profile Picture URL`,'/',4) ,'?',1) The innermost split_part will get the information after the slash that is after the base domain name. The outer split_part will then extract everything before the question mark. Hope this helps.

I'm assuming 2021 is a value and not a column. If so, you put single tics around it, which domo thinks is a column called 2021. Remove the tics around 2021 and it should work. Alternatively, you could rewrite it as this: CASE WHEN YEAR(DATE(`end_date__c`)) = 2021 THEN 2021 ELSE 0 END

The closest I have gotten to this is to put a single underscore (_) in the label to make it next to invisible. It would be nice to have more options and to optionally hide this if you want.

I did a quick test before posting and it worked. It's assuming your lookup_code column is numeric. If it is a string column, you would need to put single quotes around each value like this: ('1000','1001')

@mhouk to further simplify your case statement, you can use the IN clause so that you have just one line per city. Something like this: Case WHEN `lookup_code` IN (1024,1026) THEN 'Charlotte' WHEN `lookup_code` IN (1009,1020,1023) THEN 'Raleigh/Durham' WHEN `lookup_code` IN (1010,1016,1019,3001) THEN 'Dallas' WHEN…

Once you drag in your file and it previews the data for you, if there are multiple tabs, the first tab will be selected and there will be a dropdown arrow next to it for you to select a different tab. This will be just above your preview, above column A.

I don't see that connector listed when I search for it in the connector page. Did someone in your organization make it as a custom connector by chance?

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.