MarkSnodgrass Coach

Are you referring to a custom app that you published? Or the new apps that are currently in beta that you build with App Studio?

On your dashboard, if you click on the wrench and select Filter Options, you can choose to not show the Filter and PDP icons.

I think you could make this easier by using the DATE_FORMAT() function along with DATE_SUB(). CURRENT MONTH DATE_FORMAT(NOW(),'%M %Y') Would return February 2024 PREV MONTH DATE_FORMAT(DATE_SUB(NOW(), interval 1 month),'%M %Y') Would return January 2024 CUR MONTH PREV YEAR DATE_FORMAT(DATE_SUB(NOW(), interval 1 year),'%M…

According to the KB article, Form Owners and admin should be able to view all submissions. https://domo-support.domo.com/s/article/360042933614?language=en_US Note: Users are the only ones who can edit their own previous submissions. Form owners and admins may view all submissions, but can only edit their own submissions.…

You should be able to see all submissions by looking at the raw dataset that stores the form submissions. Have you tried looking there?

You can get this formatted as a date field by using the STR_TO_DATE() function like this: STR_TO_DATE(yourfield, '%a, %d %b %Y %h:%i %p') You can use the monthname function around this function to extract the month name, but that will be a string value since it is text.

Another option might be to use the pivot table card. It will allow you to sort by your total column and still have subtotals

You can take the beast mode that Grant suggests and make it be the first column in your table, which will then allow it to be sorted first, but I don't think it is the look you are going for. I also found that the regular total column doesn't subtotal in the subtotal row. A workaround might be to make your top level card…

If there is always a comma between values, you can use the concepts in this video to break them up dynamically and each phone number will be a row. At the end, I would suggest using the function STR_DIGITS() in the formula tile to remove all non-numeric characters.

If you feel that your beast mode is correct, the first thing I would check would be your date range filter settings. Check to see which field is being used in the date range as this can often skew results if it is basing it off a date field that you weren't expecting it to.

I believe you can do this without doing any beast modes, but using the aggregation filter capabilities. Here's how: In your table card, drag in Request Date, Individual ID, and then Individual ID a 2nd time, but choose to Aggregate by Count. In your Date Range Filter, set your date range to use Request Date and graph by…

Ashleigh, I'm not sure about the ability to right-click, but if you want to have a link open in a new tab, change the false to true in the code that is just after the link. That tells it whether or not to open in a new tab.

You can follow the steps in the video to fill in missing dates:

Excellent find @ColemenWilson !

Unfortunately, there is not an easy way to do this as it isn't in the Domo Stats. It might be possible using the Java CLI tool or via an API call, but not easy. I think this would be very useful as a Domo Stats dataset. I would recommend adding it to the Ideas Exchange.

Here is one way to troubleshoot. Create a table card and drag in your timein1 field. Drag it in a 2nd time and change the aggregation to count. This will give you a distinct list of date/times in your dataset. Next, create a beastmode that looks like this: TRY_CAST(timein1 as datetime) Drag this field into your table card.…

This video may help you as well

A good place to try out the function is at W3Schools site. I took your sample date and the format you want and it worked. This makes me think you have some extra data coming in on some of your rows that is causing the issue. In your error message you have a / . Where is that coming from?

For those that don't like to use REGEX, you can use this function to quickly remove non-numeric characters: STR_DIGITS(STR)Returns a new string consisting of only the digit characters in str in the order they appear.

You should be able to do this with creating a rank in a beast mode and then adding it to the filters section and filter to less than or equal to 100. Your beast mode would look like this: RANK() OVER (PARTITION BY QUARTER(date), YEAR(date) ORDER BY SUM(score) DESC) Your client should be in the series, your date should be…

Do you get this error message when you click on the preview (eyeball) icon in the job as well? Is it an .xls file or .xlsx?

I believe this was requested on the last beta call and they are putting it on their list of things to consider for future updates.

This video walkthrough may be helpful for you as well.

You would use the Unpivot Tile and configure it like this:

I agree with Michelle's suggestion. I'd also point out that in your original syntax, you are missing multiple END statements. Every time you use CASE, you need to have a matching END. You have 2 CASEs with no ENDs.

Are you saying that you want the raw dataset that pulls data from Salesforce to be on this custom schedule and not a Magic ETL dataflow that uses this dataset?

Yes, you can create multiple triggers for when an ETL to run. You can create one trigger that runs every 4 hours M-F. Then create another trigger by pressing the Add Trigger button that runs every Tuesday at 10:45.

The DomoStats connector has a Buzz dataset that can give you information about Buzz usage. It won't give you the chat contents if that is what you are looking for, but it will give you other useful information.

This idea has already been submitted here: Consider adding your vote to this idea and hopefully it will be implemented by Domo at some point.

When using Bricks, you will be querying your data using the JavaScript section of the brick. Your question really becomes a JavaScript question. If you haven't reviewed this section of the Domo Developer Docs, I would recommend looking through their tutorials.…