MarkSnodgrass Coach

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: https://youtu.be/QIuuXjiH1JY

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: https://youtu.be/EHm47saloVY

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: https://youtu.be/qxhV3gAZnk4

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. https://youtu.be/0p2CP-r6C8Q

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. https://youtu.be/F4MjItncJbU 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

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?