MarkSnodgrass Coach

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.

I would check what groups are assigned to those dashboards and remove the groups that no longer need them. A user will automatically have access to all pages/dashboards when they are assigned to groups that have been given access to a dashboard.

I believe you need to move your Leads field out of values and into rows and then aggregate it the same way you had in in values.

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: 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