Also, if you have data from the current month coming in and you don't want it to be considered, you can add a beast mode that looks like this and add it to the filters to remove it. CASE WHEN LAST_DAY(CURRENT_DATE()) = LAST_DAY(date) THEN 'Exclude' ELSE 'Include' END

You can do this with the multi-value gauge card, which is one of my favorite cards. You are going to want to do a few things to make this work. First, set your date range filter to the last 16 months. This will allow the card to use data back to December 2022 as it counts the current month as a month. Second, create a…

In the Chart Properties under General, set Sort On Totals to descending. This will make your chart group by the overall total and not the individual items.

In regards to getting things from the appstore, I am most interested in better visibility into what connectors are available and most used. I would love to see a trending section and a newly added section. The trending section would show the most installed connectors in the last 30 days or so. While the preferred tag is a…

You would want to use the Lag Windows Function in order to get the previous value. LAG(SUM(`surveyvalue`)) OVER (ORDER BY `fiscalquarterdate`) It's also worth pointing out that the Flex Table card is a great card for showing a previous value next to a current value. It's highly configurable to show a combination of values,…

In your ETL, before you do your running total in the rank & window tile, you are going to need to join your data to all months that exist. This way, there will be no gaps and you will be able to create a running total for each month.

I would use the the DomoStats connector and pull the Dataflows and Dataflow History reports. This should give you the names and IDs of your dataflows.

As @ColemenWilson said, there are multiple ways to do this. Here's a video that walks you through some options:

There is a brick called "Brick with Ten Datasets". I would recommend using that as it has the most defined datasets. If you need more than 10, then you may have to go to the custom app route. Or using Magic ETL to combine some of your data.

If you drag and hold your mouse over multiple tiles you can choose the Copy to Clipboard option. You can then paste that into any text editor as it is just JSON data. You could then look at the structure of the alter tile and select columns tile to see which would be easier to mass edit outside of Domo and then paste back…

Congrats @ArborRose !

Happy to help! If you can mark any answers as accepted that helped you, that would help others in the community.

Correct on the compatibility. Sounds like they need to alter the original dataset for you so you don't have to create an ETL, or not have it come in as a federated dataset.

Yes. Here's a KB article on it: https://domo-support.domo.com/s/article/360044876194?language=en_US Here's a video I have on it:

That sounds like you would need to contact the software dev if it is not even showing up in your initial dataset. Your only workaround would be to have another dataset that is either manually maintained or is another dataset that just lists all projects and then join them together in Magic ETL.

Yes, you can wrap IFNULL() around anything. If you are able to send a screenshot of what your card looks like in analyzer, that might help with the troubleshooting.

I'm guessing that your project cost field contains nulls, which is likely eliminating those other projects. Try creating a beast mode that looks like this: IFNULL(projectcost,0) Drag this field into your table card and see if that fixes it. Also, make sure project cost is not in your filters.

Yours looks like mine and mine works to put in the filter. Do you have a space before desc? It is hard to tell.

When you set the date range filter to This Year, you eliminate any previous year data. You would need to include the last 2 years in your date range filter and then use a beast mode to filter out the dates you don't want and add that to your filters. This video may help you:

Did you provide them with a PEM key for them to use when pushing the data? I have several third parties that use this connector and they are not experiencing an error. Here's the KB article if you haven't already looked at it: https://domo-support.domo.com/s/article/360042931914?language=en_US

If your Excel file is stored in OneDrive or your company's Office365/SharePoint system, you can use the OneDrive connector or the SharePoint Online connector to have it directly connected to a card.

Rank can be hard to do in a pivot table card. I would start with a mega table and see if you can get the ranking how you want it and then drag your ranking beast mode into the filter and set your number there. This video walks you through how to do it.

I don't have to work with GA4 data, but generally speaking, you can eliminate duplicates in Magic ETL. You can use the Remove Duplicates tile, or you can use the Group By tile and use aggregations such as Max and Count Distinct to remove duplicates.

Each user can set their own language setting by clicking on their profile icon in the top right corner of domo and clicking on the setting icon. They can set their own time zone and language.

This has been a common frustration with smart text. Until they add this ability, I use a dynamic textbox card and put it next to the accompany card to provide that context.

You can color just the text by sliding the opacity to 0 and then selecting one of the first 3 text options and unselect apply format to table row. This video walks you through how to do it. I think you would need to switch to a pivot table if you want total positions for both rows and columns

@BenSchein I'm glad you are in the same boat and can empathize with the annoyance of this issue. Hopefully, your influence will help this idea be implemented. I have started using both Chrome and Edge as a way to avoid running into the issues, but it would be nice to just use my preferred browser without worrying about…

Congrats on making your way through the exams! If I recall, you can either record a video or submit screenshots, whichever is easier for you. You don't need to do both.

I have not heard of a limitation to which groups are accessible. I would suggest submitting it to the beta feedback team.

When you are editing the app, I am able to click on the share icon in the top right and it lets me select a group. If you are not finding that functionality to actually work, I would submit it to betafeedback@domo.com