Best Of
Re: Drill Down while maintaining breadth
Hi @Data_Devon ,
I made a video answer to hopefully answer this for you. You have a couple options such as Xing out the filters on drill paths or just making the card open another card when clicked.
Re: slicer not working on the beast mode calculation
Try using an ETL instead of beast mode. Create a total rating calculation column that computes the sum logic at the dataset level. Then create a beast mode calculation as a silcer.
CASE
WHEN `total_rating` >= 0 AND `total_rating` <= 6 THEN 'High Risk'
WHEN `total_rating` >= 7 AND `total_rating` <= 12 THEN 'Medium Risk'
WHEN `total_rating` >= 13 AND `total_rating` <= 18 THEN 'Low Risk'
ELSE 'No Risk'
END
Re: Comparing a Running Sum to Same Time Last Year with nulls
This doesn't answer your question, but a suggestion, since I built this card yesterday and have it on my mind, is to use the running total chart and add a YoY comparison and then show the data table under the running total line chart. This wouldn't require any beast modes and I think is a helpful visual.
Re: New Excel Files as Data Sets Creating Extra Columns
That is a normal pivot added by the upload process to provide helpful Meta data on the underlying dataset - so you didn't do anything wrong!
To ensure your ETL still runs as expected - throw a "Select Columns" tile prior to the transforms (upstream) and remove those 2 metadata columns.
Re: Is there an ETL tile to change a row into a column header?
I appreciate all the help!
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.