Best Of
Re: Is there any way to connect or join an excel spreadsheet to a dataset that is already in Domo?
Hi @MDavis ,
Yes! You can use the Microsoft Plugin from Domo. Here's a video I made to show you how: https://www.loom.com/share/d042cc7f705a4489a57340da9ebf5ae0.
Good luck,
John Le
More videos at: https://www.dashboarddudes.com/pantry
Re: Transforming 6 digit integer to a date when bad values are involved
Hi @gbrown ,
So you're going to go have to do 2 steps:
1) Determine which cells are truly numeric
2) Convert the numeric ones to dates
Here are the formulas to do the steps:
1) CASE
WHEN STR_REMOVE_DIGITS(`Date_Temp`)='' THEN 1 END
2) CASE
WHEN `Numeric Format Flag`=1
THEN CAST(CONCAT('20',RIGHT(`Date_Temp`,2),'-',left(`Date_Temp`,2),'-',SUBSTRING(`Date_Temp`,3,2)) as date)
END
Even better! Here's a video of me explaing what all this mumbo jumbo is: https://www.loom.com/share/ebf8d97b0ec94d458b6d09813dc93e2c
Hope that helps,
John Le
More video solutions at https://www.dashboarddudes.com/pantry
Re: SSH postgres
Resolved: enabling debug-level logging on the ssh server revealed that Domo's SSH client requires some old algorithms to be enabled.
KexAlgorithms +diffie-hellman-group14-sha1 HostKeyAlgorithms +ssh-rsa PubkeyAcceptedAlgorithms +ssh-rsa
Also, the private key needs to be in PKCS1 format, i.e. the first line of the key contains `BEGIN RSA PRIVATE KEY`. I was able to convert my key with:
ssh-keygen -p -m pem -f id_rsa
maodag
Re: Need help with beast modes to show yesterday's invoice total amount, and previous year, current date
@DashboardDude I followed your guidance and the formulas worked. Thank you for your help. Cheers
Re: Need help with beast modes to show yesterday's invoice total amount, and previous year, current date
Hi @anh_tr_huynh4 . Here's a video explanation of what you need to do: https://www.loom.com/share/70b71aee2ec44253bb4638c9862f50cb
Anyway, you're on the right track, but I don't think your formulas are doing what you want them to do. By using the year and month functions, you're really saying to get a sum of invoice amounts for an entire month and not just yesterday.
Hope the video helps
John Le
Dashboarddudes.com
Re: Google analytics filter capabilities
Hi @Jim_C ,
So you can pull in Source Medium from the GA connector as @GrantSmith mentions. Then if you use Advanced Filters, you can select any filter you want. Domo actually has a filter builder which is WAY COOLER than it used to be. I used to have to write in some gnarly JSON code, but now Domo will do that for you. Here's a video: https://www.loom.com/share/196acf511002496caa4dc3e5dfab862a
This was that old JSON code I mentioned:
{
"dimensionFilterClauses": [
{
"filters": [
{
"dimensionName": "ga:sourceMedium",
"operator": "EXACT",
"expressions": [
"Thing you want to filter"
]
}
]
}
]
}
But honestly don't even both with this if you can use their filter builder instead.
Good luck to you,
John Le
More video solutins at: https://www.dashboarddudes.com/pantry
Re: How to get correct bubble sizes on a lat/long map
Okay, I figured out the actual solution (can I revoke marking someone's answer as the solution and give it to myself?). Maybe this would be obvious to everyone else, but in case you are like me and have huge bubbles you can't figure out that don't correspond to your legend, this is what I needed to do:
* Turn off auto-zoom
* Turn off scale symbols with map
