DataMaven Coach

Domo does not generally handle Zip files well, if at all. Is there any way for you to get them to post it unzipped? It also may be helpful to compare the zipped and unzipped sizes, as zipping does not do very much for some file types. I suppose if you were able to provide input on how the file is delivered, you would have…

A topic with 4 of my favorite Domoites doin' their thing...Just want to say 'Hi!' I'll be passing this along to the folks I'm working with. It looks like something that will make it simpler for folks to build in links. Well Done!!! @swagner @ST_-Superman-_ Hello! @JasonAltenburg @DaniBoy

The struggle is real! Very frustrating...

Trick to rename the columns with long names:. In Magic ETL Add Constant (with your new column name) Set Column Value to the values in the column with the name that's too long. Go to SQL and use these new columns instead of the old ones. This assumes it's just a few which are too long. Have you tried bringing the data in…

I wrote a whole long response to this, and apparently got logged off!!! Basically...Domo hates null values! Use magic etl to replace null values and empty text. Beast mode will be limiting and doesn't solve tbe underlying issue, so I recommend doing it in etl. Let me know if you have an issue fixing.

Is it using the legacy Excel connector or the File Upload connector? I believe the Excel connector has been retired. Try setting it up using File Upload. Anything connected to the dataset should flip seamlessly.

I'm pretty sure Magic ETL doesn't have TIME as a data type, though it may have been a recent enhancement. I'd be surprised if it were in Fusion if it's not in ETL, but perhaps...forgive my not checking, but I'm Dojoing on my phone. On the number formats...I think we are all confused. Lol. I think I typically use Decimal or…

Hello, You can create a recursive to achieve this, but your history obviously wouldn't back-fill. Recursive query process:. 1. Create Magic ETL, using your input dataset, and creating an output dataset. 2. Save and Run. 3. Add a new input dataset and configure it to use the output dataset which just got created. 4. Fill in…

I noticed that you were specifically asking about mobile. Any user other than a social user should be able to access the page filters. Looking at my own page, I see that I need to tap the menu button at the top right to reach filters. If you have a user who should have access, but "doesn't", you may want to suggest they…

Do you already have the segments identified, or do you need to create a field which maps them? It sounds like you perhaps have a field with start point and a field with end point. The segments would then be identified by the permutation of start/end combinations. You could achieve this in ETL using the concatenation…

It's best in Domo (and really any system) to build transformations in the ETL, and reserve Beast Mode for those things you can't achieve because of dynamic analysis. I'd also caution against forcefitting solutions across tools. They will each have their own optimum ways to achieve results. I find that many people I work…

If you open the notebook card in edit mode, you can use the hyperlink function to set up your hyperlink. This will give you the ability to uncheck the box for opening the link in a new page. On your dashboard edit view, you can make the tile interaction not open in a new tab. Unfortuately, it looks like the feature for a…

Hello - Have you tried achieving this in Magic ETL? There, you can created a column which is the date field minus one year, and then rejoin it to itself to pull in the prior year figure as its own field. Magic ETL handles loops well.

Hi @jorefice - You can ask your Domo reps to get recursive capabilities set up. I know for sure that you can get SQL queries special built to recursively write to Webforms, but they may also be able to set this up to write back to other dataset types. Worth a shot. If you want to create a way to flag certain fields feel…

They weren't earlier - thought that was something you had to do, and wanted to make sure that @ST_-Superman-_ got his due! ?

@DaniBoy - Superman and I have another dual solution - would you mind adding a solution for him, too? Thanks!

This may seem crazy, but try adding a SUM. I've had that do the trick on beast modes not working. SUM(count(distinct `SalesHost`)) over (order by `NetSales` desc)

Would a series of CASE statements or nested CASE statements do the trick?

Awww...Thanks @swagner! My Dojo friends always make me smile!

It may be helpful for you to know that you may need to make a minor mind-shift with your work in Domo. When you are working on building your ETL's, you will want to think less in terms of star schema, and more like a french braid. Start with your fact table, and bring in each of your dimension tables in a line, while…

I'm not sure I am getting exactly what you are trying to do. What is the use case? What do you see the process looking like? What type of information would be in the uploaded dataset?

@JasonAltenburg - What did you do that made your word cloud sql work? I am replicating in another environment, and it keeps failing!!!

In my suggestion, you would be filtering on the first date column, and doing a count based on the second. The first would be a regular filter. The second would be what you would achieve in the beast mode.

Ooook - you were mentioning filters for cards, so I didn't know you were talking about page filters, and specifically the new dashboard/story view. I will take a look. Definintely worth exploring, as we will all need that! @swagner - I know you have been playing with the page filters a bunch - any suggestions?

@JasonAltenburg - I am so glad I give you hope!!! lol Did you happen to run into cases where the same word would appear twice because it was sometimes capitalized and sometimes not? Might I lean on your SQL lazily and ask you if you know the right place to toss in a PROPER function? I am just going to mess it up 6 times,…

Can you just use a case statement to count if the close date is either null or higher than the selected range? The filter would be on the dates already, so you could probably use max date opened as the criteria in the beast mode. If the nulls are an issue, as they often are - you can address this in your ETL by setting…

Make sure to update the reference for next year's date calculation - and make it 13 months instead! Update filter for next year criteria to be < instead of <=. So - sorry for it being a little mixed up. You may have to flip between my 2 replies. Please ask me anything unclear. I'm used to just doing it. Working on getting…

By the way - Since it was said that all the dates are the first of the month, I didn't construct a date for the first of the month...but...I just realized you do need it for the current date to get the first of the current month! Will post that, too.

This seems too simple, so let me know if I am missing the point. Entirely possible. Add column for Current Date - This updates dynamically. Use date function widget to add 12 months to the current date. Filter for the rows between today's date and next year's date. I didn't add the output table to the screenshots because…

Ignore this reply - Accidentally posted reply I had for another post - too many open at once!