MarkSnodgrass Coach

Have you tried INITCAP? That function works in beast modes and formula tiles.

See how close this gets you: DATE( REPLACE( REPLACE( REPLACE(`Interview Scheduled Date`,'00','') ,'-','/') ,'.','/') ) This still might not work for 100% of your data because it seems like you have rows with 2 digit years in different spots and Domo won't know if that is a year or a day. You might need to try and thinking…

Can you post your formula? Wrapping the DATE function around everything should normalize the years.

You can wrap a couple REPLACE functions around your field that replaces the hyphens and periods with slashes followed by the DATE function to format these as date. It would look something like this: DATE( REPLACE( REPLACE(`String`,'-','/') ,'.','/') )

Did you try the Shopify Quickstart App in the Domo App Store?

This is available through the Domo Governance datasets. If you haven't used this connector before, it has quite a bit of information about your instance. Go to your data center and then click on Connectors and search for Domo Governance. You can then choose Beast Modes as a report and it will add the dataset with the…

Oh I agree that they should return the 'x'. Just pointing the second way to remove a field for those that didn't know about it yet.

A lot of people are not enjoying the new feature that requires the extra step to remove an item. If they don't return the "x", another way to quickly remove an item is drag it away from the field and that will remove it. This is proving to be quicker than clicking on the down arrow and clicking "remove".

I assume your cc emails are in one string and separated by a comma or semicolon. You are going to need to get them separated so that you have one e-mail address per row. You can do this with a method that I walk through in this video. In the walkthrough, I am separating out strings of words into single words by looking for…

@jaeW_at_Onyx here's a breakdown of how my card is set up that makes it work. I create a "standard date" beast mode field that takes the date field in the dataset that you need to do YoY on and moves it into the current year. DATE_ADD(`datereported`, interval (YEAR(CURRENT_DATE())-YEAR(`datereported`)) year) My year field…

I created a video that shows how you can create a standard date, which then allows you to look at different years next to each other. My video uses a line chart, but you can switch to a pivot table and format the date fields as needed to get the look you want. https://youtu.be/mDwSQGAjIrs

Totally agree with you. It's a bit unfortunate, but I try to limit how often I edit my published dashboards because I can't go around making sure every child instance received the refresh properly. I'm hoping they will continue to improve the process and I can regularly make changes to the dashboard and not be so reluctant…

@Jones01 I will often edit the publish job and click through everything to make sure everything is properly selected and then choose refresh after that is done. I don't completely trust the numbers that show the number of datasets, pages, cards and subscribers. Mostly because I know my subscriber count is incorrect (mine…

I have found that I have to wait 30-60 minutes for a child instance to see the changed charts after the publish refresh job has told me that it is finished. Domo also recently implemented targeted refresh, so it is worth double-checking that all of the appropriate child instances are targeted when refreshing. Hope this…

You can use the formula tile and the concatenate function to build your ratio string like this: CONCAT(`Usedfield`,':',`Newfield`) This would build your string.

@moneyshot glad I could help!

Do you not have a date in your inventory table? You can always add a date in the etl process, such as the first day of the month. There are several different ways you can derive a date dynamically depending on your data. You can give it the same column name as your orders table date column so that the filtering will work.

A second option is to not join your data in the ETL, but union your data with the append rows tile. Choose include all columns when appending. This will keep your inventory rows from repeating and then you should be able to use SUM(orderqty) / SUM(qtyavail) to get the percent sold.

You can get around the fact that the qtyAvail is repeating by using the average function in your beast mode like this: SUM(orderQty) / AVG(`qtyAvail`)

No, your sum would be your sales amount column, not the date calculation. What does your data look like? Do you have one entry per day? One entry per week? That will make a difference in the lag.

In your OVER clause, you should be able to add ORDER BY and list current run DESC, total current run DESC so that it will sort by current run first and then total current run after that.

@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