Best Of
Re: Joining or Appending Data Help
Hi @user000253
I'd recommend using an APPEND tile in an ETL or a DataFusion to UNION your two datasets together. However one caveat to this would be they need to be in the same format / have the same columns
You could process your data to look like the following:
| Job ID | Country | Year | Amount |
| 123 | UK | 2009 | NULL |
| 234 | UK | 2009 | NULL |
| NULL | UK | 2009 | 1000 |
Then in your card you can define two different beast modes:
Job Count:
COUNT(`Job ID`)
Revenue:
SUM(`Amount`)
Then use those two beast modes for your two different values (line and bar)
Re: How to implement commands from the Command Line Interface Tool in Python, specifically api requests
Also as a warning private APIs aren't supported by Domo so you're using those at your own risk as they could change without warning and cause issues or break your script.
Re: CustomApp - Dashboard & OtherCard
... you can easily do what's available in the domo.js function.
If you're building Dashboards that are filtered to subsets of data, consider creating a filtered Dataset View. Then point all your cards and app to the filtered DSV.
You don't want to be setting up dashboards where the cards are filtered to a specific (for example) department, because then when you have to set up a new dashboard for a different department you have to do a lot of work.
Re: Timestamp Convention in JSON File from Command Line DataFlow Request
@GrantSmith will know the answer to this one.
Re: Why is my card missing rows?
@ljb18 what field is being used to count the number of tracks? That field likely has blanks in it and the summary number will not count blanks as part of its total. Find a column that does not have any blanks or nulls and use that as your count for the summary number and you should see the same number as your dataflow row count.
Re: User Profile fields only manual?
Domo has an API that you can work with to automate the process.
You could be a custom api that extracts data from one of your systems and updates Domo.
Re: Sum One Check Amount with multiple rows of the same data by using DISTINCT ?
I assume this is data where you took a payment table and JOINed it to a Employee Timesheet table.
Don't JOIN the data.
Append, UNION, the two sets of data together.
I know it sounds like work to understand why UNION is a better solution than JOIN. But trust me.
As you JOIN transaction tables together, you are going to try to do more crazy math to make your cards work. It's not scalable.
Take your LEFT table, add "Activity Type" = "Payment"
Take your RIGHT table add "Activity Type" = "Timesheet"
And UNION the data on conformed column names. You'll avoid row duplication.
Re: Running Total Year over Year
Hi @user06209
You can utilize window functions in a beast mode (you just need to have them enabled - talk to your CSM)
SUM(SUM(`Amount`)) OVER (PARTITION BY YEAR(`Date`) ORDER BY `Date`)
Re: Is 'Partition by' supported in DOMO SQL?
Domo's MySQL is version 5.6, which doesn't support window functions. I would suggest using Magic ETL to do this with the rank and window tile. If you have Magic ETL 2.0, it will run incredibly fast.
Rank and Window KB Article:
Magic ETL 2.0 KB Article:
Re: is it possible to add a constant in front of values in a column by using a beastmode calc?
Hi @user048760
What you're looking for is the CONCAT function. It allows you to add multiple columns together with constants to create a single value.
If you're looking for just the URL (which you won't be able to click on but would only be displayed)
CONCAT('https://xxxxxxxxxx.sugarondemand.com/#Calls/', `ID`)
Alternatively you can also utilize some HTML code to convert your URL to a clickable URL.
CONCAT('<A HREF="https://xxxxxxxxxx.sugarondemand.com/#Calls/', `ID`, '" target="_blank">', 'Clickable Text Here Or Use a Column Instead', '</A>')
The `target="_blank" ` tells the HTML to open your link in a new window. If you want it to open in the same window then just exclude that section.
The HTML link will only work in the table type card and doesn't work in other cards at this time.