Best Of
Re: Error "Domo task has exceeded the max number of runs (1000):java.lang.illegalstateexception"
We have a limit of 1,000 passes through a shape. We can raise that limit at the request of the customer. You can reach out to Domo Support to get that limit raised, or in this case you can just message me.
Re: Filter visualization on dashboard help
Happy to jump on a call to troubleshoot with you!
Re: Filter visualization on dashboard help
@helpme12345 I did join but had trouble joining the meeting in Zoom so I was 5 min late. I have a lot of availability this week if you want to reschedule!
Domopalooza entertainment announcement: STYX
We're so excited to have Styx join us on stage at Domopalooza 2025!
Don't miss out. Join us by REGISTERING HERE.
More about Styx
The seven men comprising Styx--James “JY” Young (lead vocals, guitars), Tommy Shaw (lead vocals,guitars), Chuck Panozzo (bass, vocals), Todd Sucherman (drums, percussion), Lawrence Gowan (leadvocals, keyboards), CRASH OF THE CROWN producer and co-writer Will Evankovich (guitars),Terry Gowan (bass, vocals)--have committed to rocking the Paradise together with audiences far and wide by entering their second decade of averaging 100 shows a year, and each one of them is committed to making the next show better than the last. Styx draws from over five decades of barn-burning chart hits, joyous singalongs, and hard-driving deep cuts. Like a symphony that builds to a satisfying crescendo, a Styx set covers a wide range of stylistic cornerstones. From the progressively sweeping splendor that is “The Grand Illusion” to the hunker-down fortitude of all that is the “Blue Collar Man,” from the regal reach-for-the-stars bravado of “Come Sail Away” to the grainy all-in gallop of that rugged “Renegade” who had it made, the band draws on an unlimited cache of ways to immerse one’s mind and body in their signature sound.
Styx released their 17th studio album in 2021, CRASH OF THE CROWN, which was written pre-pandemic and recorded during the trying times of the pandemic. Styx’s holy mission for cutting CRASHOF THE CROWN, hailed by critics as a “masterpiece,” was crystal-clear to its co-creator from the get-go.“ Absolutely no obstacles were going to get in the way of how we approached creating this album, ”singer/guitarist Tommy Shaw concludes about the herculean recording efforts of his fellow COTC makers. “And everything came out exactly the way we wanted to hear it.” After more than two decades together on the road, this incarnation of Styx is looking forward to performing as many shows as it can as long as it can. “Music is this amazing force that comes from a higher place. I'm humbled for this band to have the great success that it has,” says co-founding guitarist/vocalist James “JY” Young.
Re: Exporting Dataset as CSV ignores the Round function
Assuming that you want the column to stay rounded to 2 decimal places, you'll have to convert it to text once you are satisfied with the rounding.
Then, upon export, Notepad will recognize it as text (not an integer) so it won't apply any math.
Alternatively, you could truncate or trim the integer so that there isn't more than 2 decimal places contained within the value. This way would maintain the data type as a number but Notepad wouldn't have any further decimal places to abstract from.
Let us know if that works or if I'm missing something,
Re: How to fill-down nulls from earliest instance of non-null value?
The flow consists of the following:
1. Add Formula. New column name: "Row Number", Formula: ROW_NUMBER()
2. Rank & Window. Order by "Row Number". No partition columns. New column name: "ID Count", contains Count of "ID" from Unbounded Preceding to 0 Following.
3. Filter. Condition: ID Is Not Null.
4. Join #2 to #3. Type: Inner. Equality condition: "ID Count" to "ID Count". Resolve column name conflicts by dropping ID from the #2 side and dropping all other columns from the #3 side.
5. Select or Alter Columns to get rid of "Row Number" and "ID Count" and to reorder columns, if desired.
Explanations:
#1: Rank & Window requires that we sort on something, but we want to keep the data in their original order. Since there is no sequential column in the example data, we must create one. Add Formula has a function ROW_NUMBER() which fulfills this purpose.
#2: The Count function from Unbounded Preceding to 0 Following is a "Running Count". This will increase whenever we encounter an ID that isn't null, otherwise it will remain the same. This is useful to us because it gives us a value in common between every row and its last row with a non-null ID.
#3: This becomes the "lookup table" of "ID Count" to "ID"
#4: This joins all our rows to their corresponding row in the "ID Count" to "ID" lookup table. We just need to be careful to preserve the "ID" column from the lookup table (#3) and all our other columns from the main table when we do duplicate column resolution.
#5: We produced some "utility columns" along the way, and the Join may have put our "ID" out of place (depending on where it is supposed to be). An Alter Columns could be used to simply drop the unwanted columns, or a Select could accomplish both the removal of unwanted columns and the reordering of desired columns.
rco
Re: Enable Preview Up to Point in ETL
@jimsteph yes! Great idea. most of the time I'm making changes at the tail end, and just need to test a few new tiles added. I would also think this would be advantageous for Domo because it would minimize unnecessary reprocessing…
Re: Has anyone ever deleted a copy of a dashboard and then the original dashboard gets deleted with it?
@MParr At our company we have a process to archive pages rather than delete them.
1. Create a page called something like "Archived Pages"
2. Move the page you want to archive as a subpage of "Archived Pages"
3. Remove sharing for everyone but you (and maybe your team as well)
4. Add [Archived] or [ARC] as a prefix to the page
5. Optional: Add a text box on the top of the page explaining when it was archived, why it was archived and if there is a replacement page.
It just so happens that Karl Altern at Domo has created a way to automate the archiving of pages if you need to do them in mass. I'm sure he'd be glad to talk through it with you, karl.altern@domo.com.
Re: File Upload Via Email (Zip file)
Hello @phesson,
I’m not aware of a direct solution from Domo. It may be best to use Power Automate or a similar tool to download and unzip the file first, then upload it to Domo.
Re: "Add All Columns" button for Mega Table Charts
@NCRivera thanks for submitting this idea. We'll look into adding this functionality in Analyzer in the future.
