MarkSnodgrass Coach

Here is a video on how to break up comments into individual words and remove particular words.

I will often do a formula like this that I drag into the filters section to get year to date values from previous years. CASE WHEN DAYOFYEAR(datefield) < = DAYOFYEAR(CURRENT_DATE()) THEN 'Include' ELSE 'Exclude' END In the filters section, I filter to Include which will filter out any rows that are later in the year.

You can implement the LAST_DAY() function around all of the dates and that will group everything into monthly buckets. Do it before you do the join and it should get you what you want.

I answered a similar question on how to do this here: Let me know if that works out for you.

Have you tried added a calculated field under the transforms section and use a function such as TODAY() to have it add today's date when it runs?

Thank you! It was great to see everyone at Domopalooza and to compete in the Demo Slam. Thank you @GrantStowell for doing such a great job moderating the Community. It was great to finally meet you in person!

You may want to look into this video by @ellibot

In Magic ETL, it will look something like this. I had to add some tiles to get my data where I could make something like yours. I will explain the key tiles that you would want to focus on configuring in your environment. Join Tile Do a LEFT JOIN and have your DailySeconds table on the left and your Events on the right.…

You can do this in SQL and Magic ETL without much trouble. I will try and lay out both options for you, but I can pretty much guarantee that the Magic ETL option will perform better for you. SQL Start by getting your counts in your events table like this and call it EventCounts SELECT StartSecond, EndSecond, COUNT(EventID)…

The first thing to check would be your date range filter. If you can set it to graph by month then it will automatically group it for you by year month. If that is unavailable, you can click on your date field and choose format - date format - custom and enter in your format.

You can do this by creating beast modes for each of your series for current/future months and another for historical months. Since you have 3 bars, that would indicate you have 3 items in your series, so you would need to create 6 beast modes. Each would look like this: Series A Historical Beast Mode CASE WHEN seriesname =…

The API key should be the access token that you would generate in your instance. You can generate an access token by going to More → Admin → Access Tokens. Make sure you set an expiration date that is far out, such as 10 years.

Before going down that road of trying to use JavaScript, you may want to check what your company time zone settings are and what a user's Domo time zone settings are. Under More → Admin → Company Overview there is a time zone setting that your company can be set to for the default display. Each user can have their own time…

You may want to try how I outline to do this in this video:

Form Builder has traditionally been a paid feature. However, it may be included at no cost to your organization. The app store does not know what agreements you have in place, so it will always say trial when looking it at in the app store. I would talk to your CSM to see if it is a paid feature or not for you.

I don't know the answer to this, but I agree this would be helpful to know. I would also like to know how many days does it take for a dataset to not be accessed before the dataset goes into this state.

There is currently no option to change the delimiter when exporting to CSV. I would recommend adding that to the Ideas Exchange.

In Analyzer, click on the Summary Number and click on Show Formatting Options below the label. Choose Number (or Currency) and uncheck abbreviate and check use thousands and set decimals to 2.

You can also use the SharePoint Online Rest Connector to pull in the data. Here's the KB article that explains how to get it set up. https://domo-support.domo.com/s/article/360043436773?language=en_US

I see in the bottom corner of the chart when you are in the dashboard that the filter icon is showing. This means there is a dashboard filter applied to all cards on the dashboard. Likely, that filter is causing the previous to not be able to show.

@Jessica I recently struggled with this as well. I wish the implementation and documentation of Form Builder/Viewer was stronger. Hopefully my instructions will help you. The first thing that you will want to do is to go to your Form Builder where you built a form and select Edit Card in the wrench. Then, click on the…

You can do this in Magic ETL with the Rank & Window and Filter tiles. In the Rank & Window tile, select the Rank function and order by time_stamp descending and partition by load_id. Add a filter tile after this and filter to where rank equals 1. This will give you just one entry per loan_id and it will be the one with the…

You can use the formula tile and use the concat and date functions to build your date and make it be recognized as a date field. Here is an example where the date will always be in 2018 DATE(CONCAT(`Month of the year`,'/1/2018')) Here is another example where it will extract the year from the current date…

You could also create groups using Segments. Here's the KB article. https://domo-support.domo.com/s/article/4403089503383?language=en_US

There is not one currently in the appstore. Depending on how they make data available, you might try the JSON No Code Connector, the Dataset via e-mail connector or the CSV Advanced Connector.

Agree with @MichelleH on the dataset copy. A couple other options if they are available are Virtual Datasets and Domo Publish.

You are going to want to add a fixed function into your beast mode. Look at this KB article on how to do it, specifically the Filter None section. https://domo-support.domo.com/s/article/4408174643607?language=en_US

I would suggest looking at the dynamic textbox card to do this rather than smart text. You can use the category name for the keyword and the value to show the # of clicks (if you want). https://domo-support.domo.com/s/article/360042924514?language=en_US The Multi-value gauge card is also highly configurable and could be an…

The first thing that jumps out at me that might be throwing off the histogram chart is that you have something in the Sorting properties. Try removing that and see if that allows it to distribute better. If you haven't looked at the KB article, this can be helpful in understanding how the chart is intended to function.…

I saw someone else ask the same question as they are experiencing the same issue. I would recommend creating a support ticket as Domo might need to look at their API connection and see if something changed.