Best Of
Re: How to Unlock an Account After Multiple Failed Password Attempts
The administrator needs to do it by going to Admin - People - clicking on the user and then clicking on the Change Password button and creating a new password. This process unlocks the account.
Re: Tracking Usage & Measuring Success
Hi @Data_Devon ,
Let me know if you want me to show you what I do. I have dashboards that show me how many views they get, most active people etc. That way we know which dashboards are getting the most engagement.
https://www.dashboarddudes.com/domo-help
Re: Is it possible to use a code engine package as library in another package
You could try and adapt this: https://developer.domo.com/portal/4w40o03817vij-hitting-a-code-engine-function-from-an-app#calling-a-code-engine-function-code-example
I haven't tried it, but this:
domo.post(/domo/codeengine/v2/packages/${functionAlias}, inputParameters
)
Would become this:
codeengine.sendRequest("POST", api, inputParameters)
Re: Can we import a custom package created in one Code Engine to another Code Engine?
@Makam there is no direct, “native” Domo feature to share code between Code Engines. Instead, the best practice is to maintain a single external repository or private package index for your shared code. Then, each Code Engine environment can fetch and install that code as part of its setup, ensuring code consistency and maintainability across all of your Domo projects.
I have used CDNs like https://www.jsdelivr.com/ for importing NPM packages.
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