MarkSnodgrass Coach

If you are not seeing the warning in Excel then you can assume all the data was exported. You can refer to this KB article about limits on exporting and how it pertains to pivot tables as it counts the dataset rows and not the ultimate pivot table rows.

I would try using the Query Table tile and then pick any dataset and then write the following SQL query: SELECT CURDATE() As TodaysDate FROM Table_0 LIMIT 1

Unfortunately, it does seem like you are a bit limited with the chart properties. I would suggest submitting an idea in the Ideas Exchange to allow for some more flexibility with the Outline View.

I receive this message when I submit an entry in my form in App Studio. Are you not receiving this message? There is not a way to modify this message, unfortunately.

I have not heard that it is in the pipeline, but I think it is a good idea. I have created an idea in the Ideas Exchange that you can upvote. https://community-forums.domo.com/main/discussion/69752/select-line-style-by-series-item/p1?new=1

To my knowledge, if you are wanting your app studio form to have cascading dropdown lists where dropdown list B will show options depending on what was selected in dropdown list A, (i.e. list A contains states, list B contains cities for only the state selected in list A), that is not currently possible in app studio…

If you are struggling with this concept in MySQL, I would suggest you use Magic ETL to join the data. It is much easier to use and will run much faster. Here is a video on joining data in Magic ETL if you are unfamiliar with it.

The line styles are not configurable per line in that chart type. You could assign color rules for specific lines, which may help you. In one that I did recently, I used a lighter blue for forecasted and a darker blue for actual.

You should be able to get around this by using fixed functions. Here's an example: Beast Mode: SUM(AVG(revenue) FIXED (BY sales_rep))

Can you provide some sample data of what you have and what you want the end result to look like? It is a bit unclear what you are trying to do when you have 3 aggregators.

If you have your Domo users add a profile picture in their Domo profile, you can access that picture by using the following URL: https://{instance-name}.domo.com/api/content/v1/avatar/USER/{userid} If you have the DomoStats People dataset in your instance, you can use ProfilePictureURL column as your image source in your…

You would want to create a beast mode that calculates the overall average and put that value in your series. You would want to use the Fixed Functions feature to calculate the overall average. This KB article walks you through it. https://domo-support.domo.com/s/article/4408174643607?language=en_US

@Robyn I have noticed the same thing. @Eddie Small is in charge of the recordings. He would know for sure if there is a way to include the chat in the recordings.

If you are using Chrome on your phone, you can choose Desktop Site by clicking on the 3 dots in the top corner of the browser. This will render out the normal Domo look you see on your computer.

Depending on if you are looking for 6 months to the day or not, there are a couple ways to tackle this. One way would be to subtract 6 months from today's date and include or exclude. You could do it like this: CASE WHEN mydatefield ⇐ DATE_SUB(CURRENT_DATE(), INTERVAL 6 MONTH) THEN 'Include' ELSE 'Exclude' END This video…

In the chart types, choose Grouped Bar. In your chart, drag PlannedHours into your y-axis and set an aggregation type. Next, drag Actual Hours into the series and set an aggregation type.

Currently, you can not save a chart created within AI chat. Domo is working on adding that functionality. Your alternative would be to create a new dashboard and use the Domo AI Content Builder Agent. You can select the dataset that was used in the AI Chat and then ask the same question. It will likely create multiple…

I would start with this article https://domo-support.domo.com/s/article/360042924094?language=en_US

Do you have something in your series? It won't be able to do an average if you have something in your series.

I have a video that walks you through how to calculate distances between cities in Magic ETL. Once you calculate the distance, you can then use a filter to show which cities are within a certain range.

I know in Domo Workbench there is a checkbox that has to be checked to clear out the dataset if the query returns zero rows. There is likely a similar setting for the SQL Server Connector that needs to be checked.

You likely need to add Academic Plan to your partition in the rank & window tile. This will give you a row number of 1 for each academic plan sorting by the effective date descending.

Under Chart Properties - General Set Maximum Items to 3. Also, click the checkbox next to Hide Other Bar.

Not to be outdone by John 😁, I created a video that walks you through how to do what I explained.

As I understand your question, you want to filter your card to the month that the last working day is in. This is a great use case for a nested beast mode as it makes it much cleaner to look at. Here is what I would do: Create a beast mode called LastWorkingDay with a formula that looks like this: /* If today is Sunday,…

Agree with John. Before your rank, add a filter tile and choose formula and use this formula: RIGHT(`ACAD_PLAN`,2) = 'BS'

Domo has a few different variations of forms. There is Form Builder that was created several years ago that can be deployed within a classic dashboard. You can find Form Builder (and that accompanying Form Viewer) in the App Store. App Studio has its own form creation tool that has some nice improvements like data type…

I have built a form very similar to this in App Studio. It has been very successful. However, just recently the end users started receiving the Error Loading Form message that you reported. I don't see the message when I access the form. We have Domo support ticket created and are waiting on the issue to be resolved so…

Very slick @b_rad . Here is how I might do it. Essentially, I am using the period_diff to calculate the month difference, but check to see if the day of the start date is greater than the day of the end date and subtract 1 from the resulting period diff since it shouldn't count as a month yet.

On the column that you don't want the total to show up for, click the pencil icon and click on Total and select the checkbox that says Hide total