GrantSmith Coach

This happens when the response back from the API is empty. You had mentioned that you're attempting to append to your dataset but by default data_import will utilize REPLACE. Have you tried adding, update_method=UpdateMethod.APPEND to your data_import call?

Domo offers the Data Science package which includes Python tiles and Jupyter notebooks which you may be able to leverage to perform the translations via something like the Google Cloud Translation API (https://cloud.google.com/translate/docs/reference/rest/ The data science package is a premium feature. Alternatively you…

Hi @JoshBethers It appears that access and the APIs for the feedback survey data are in Beta only so it's likely Domo doesn't have access to this endpoint yet. You could attempt to join the beta and pull the data yourself and upload it to Domo with a custom connector or the Domo APIs. You can find more information on these…

You can also create your own custom connector to pull eBay data if you are technical enough and know javascript https://developer.domo.com/portal/5d8f965eb3469-overview

Alternatively you can combine both together and use a coalesce and NULLIF COALESCE(NULLIF(TRIM(`fieldname `), ''), 0)

@Pellogat Does you old system have an email address associated with the usernames or do you only have the usernames? How can you determine in the old system if a user has multiple usernames / accounts?

You can utilize the Java CLI and the backup-card command to export the definition of a card to a JSON then modify the JSON definition to include your color rules to include values which don't currently exist in your dataset. Then utilize the restore-card command to upload those changes to your instance. Make a copy of the…

The code is appending each record to the end. If you want to change it to add them to the beginning you need to use prepend: $table.find('tbody').append($row); Becomes $table.find('tbody').prepend($row); in the addRow function (originally around line 198)

Here you go: https://community-forums.domo.com/main/categories/ideas it’s another section on these forums.

You could possibly use a FIXED function and the FILTER ALLOW clause to only allow filtering on a specific date field when calculating your totals. Here's a link to documentation on FIXED function: https://domo-support.domo.com/s/article/4408174643607?language=en_US

Currently this isn't possible with the default scatter plot. You can add this recommendation to the idea exchange to possibly add this to Domo's roadmap. Alternatively you could look into utilizing a Domo Brick to write your own scatter plot and allow for this type of line but that's a much more technical and involved…

To expand on @MarkSnodgrass 's answer you'll need to use the FILTER DENY or FILTER NONE clauses in a fixed function to prevent filtering from happening on the value. SUM(`Value`) / SUM(SUM(`Value`) FIXED (FILTER NONE))

Domo would suggest the Data Science package to allow for R or Python tiles to do the NLP processing in a magic ETL dataflow but it's an extra cost. You can utilize rdomo to extract data from Domo and process it and re-upload it (or pydomo if you're a Python fan). There's nothing currently out of the box to do NLP.

Currently the data table will only display the data that's displayed on the graph. There isn't a way to have it included in the included table without displaying it on the graph. You could have a separate chart for just the graph and include the data you wish there on the page. Alternatively you can suggest this through…

You can use a formula tile to populate a new user id column in your old dataset by just appending the @email.com with a CONCAT formula: CONCAT(`Old User Name`, '@email.com') Then you can use that new field to join to your new dataset and get similar records.

Good clarification @MichelleH @jtrollinger it should end up with something like this CASE WHEN `HdrParentItemCode` IN ('ZROUGHIN', 'ZWATER', 'ZSEWER', 'ZROCK', 'ZVANGUARD') THEN 'Rough-IN' WHEN `HdrParentItemCode` IN ('ZTOPOUT', 'ZGAS') THEN 'Topout' WHEN `HdrParentItemCode` IN ('ZTRIM','ZDROPIN') THEN 'Trim'…

Alternatively you could filter the rows for non null values, feed that into a remove duplicates based on your two ids and the use a join tile to join them back together based on the id fields and then rename the new category

If the category is the same across for each store and ticket I’d you can use a rank and window tile to get the max value of the category for a new column and then use an alter column tile to drop the old category field and rename your new category field

@Aag2023 there aren’t individual edit permissions currently within Domo for dataflows. Permissions are based on the input datasets. I’d recommend adding an idea to the idea exchange for added dataflow security

Only the first CASE keyword is needed you can remove the others but leave them when and clauses

You'll want to both kill the Workbench process and restart the Workbench service in services to make sure it's no longer running and attempting to process your data. If that won't work then there's always the Windows solution - reboot the server.

Or even simpler you could try and check the General > Reverse Color Direction option in the settings.

Try using a beast mode to multiply your value by -1 to flip the ordering and thus the color scheme. You can then also use the tooltip 1 for the actual value and display that in the tool tip / data value properties.

Can you post a screenshot of your code and the error your getting?

Hi @your_super_shawn , I'd recommend reaching out to the App Support team at domoappsupport@domo.com. They will be able to help resolve your issue. You can follow https://developer.domo.com/portal/e3bddcb552199-troubleshooting#undefined under How to Submit a Bug to help get an answer faster.

CASE WHEN COUNT(CASE WHEN `Event Type` IN ('Hearing', 'Vision', 'ASQ3') THEN `ChildPlusID` END) = COUNT( CASE WHEN `Event Type` IN ('Hearing', 'Vision', 'ASQ3') AND `Event Status Code` = 'Completed' AND DATEDIFF(`Event Date`, `OriginalEnrollmentDate`) <= 45 THEN `ChildPlusID` END) THEN 'Completed' END This is assuming…

Start with a day and see if that's returning all of your data.

Hi @shrikantdeshmane Is it a matter that it's throwing an error message or it's saying it succeeds but just doesn't update any records? What was the code you used to create the table xxtm_demand?

@gbrown Glad to hear it! If you could accept any answers that helped solved your problem so others can easily find the answers I'd appreciate it!

You can use a Rank & Window tile with a MAX aggregation to get the most recent date. You can partition by the project_number to get the latest date for each project.