Best Of
Re: Embed error, duplicate of dashboard does not work
Have you tried updating the embed type to Off (save) then back to Private (save)? Have you confirmed that URL is correct for that new page under Admin -> Domo Everywhere -> Dashboards?
Re: Comparative Gage - What's wrong with my query?
If you are adding together multiple values and one of them is blank or null, it will not be able to add them all together and just produce a blank value. You would need to do this: IFNULL(likes,0) + IFNULL(shares,0) + IFNULL(comments,0) in order to add them together. If the fields aren't actually null, but blanks, you would need to do CASE statements around them as well to replace that with zero. I find it easier to clean these types of data issues in the ETL so then my beast mode is easier to read.
Also, to deal with the the incomplete months, you can add the DAY function just like you did the MONTH function but say when it is <= instead of = to.
Hope this helps.
Re: Unify two filters in one Beast mode function ?
You would just create multiple WHEN statements. You can have as many WHEN statements as you want in a CASE statement. Yours would look like this:
(case when (`Distributors`='DistributorA' and `Country`='CountryA') then 'Distributors'
when (`Country`='CountryB') then 'Distributors'
else 0
end)
Re: Its showing me "Live updates are not available" as the status, how do I solve it?
Whenever I have seen this it is because someone else is already logged into workbench. We have two people with access to workbench and if I ask them to close out of workbench and close and reopen it, it removes that status.
Mr_53
Re: set custom start days of the week at a card-level
Try creating a beastmode that will mark the start of each week. You can then sort by this first, and then sort by your second beastmode.
start_of_week :
SUBDATE(`Date`, DAYOFWEEK(`Date`)+2)
Then, you could sort by start_of_week and then by your calculated field. That should get you what you are looking for
Re: Rows Gone Missing in ETL
@user027926 I think those numbers are telling you how many rows came into that tile, not how many came out of it. So, there were 484,445 coming into the Remove Duplicates tile and after it completed, there were 468,410 rows.
It would be a nice enhancement if they showed both the incoming and outgoing numbers for each tile, but you can deduce it by following the steps.
Re: Beast Mode Calc for URL Won't Activate Intranet Links
Hi @user028768
Try wrapping your values in double quotes:
CONCAT('<a href="', `Link to Additional Info`, '" target="_blank">Click to see additional info</a>')
Also, what type of card are you using? Hyperlinks will only work in table cards.
Re: Domo encountered an error proxying your request: 500
Hi @User_32236
500 (see https://developer.mozilla.org/en-US/docs/Web/HTTP/Status/500) simply means an internal server error (essentially Domo had an issue processing your API request). It's an HTTP response code. Typically when I've seen 500 error in the past it's because of malformed data being sent to the API call. Have you confirmed you're sending the same data via postman and via your custom connector script in the same package / envelope / format?
Re: Domo encountered an error proxying your request: 500
Are you hitting a Domo internal API or an external API? Domo has restrictions on which internal APIs can be hit.
For more details on the error you can email support@domo.com and they'll forward your issue to the connectors team.
Alternatively there is a Connector Support email <supportconnectors@domo.com>
Re: join two tables with date comparison in where clause MySQL
The error is because you are missing the ON clause in your join statement. A typical JOIN query would look like this:
SELECT * FROM a JOIN b ON a.id = b.id
However, based on what you are describing, you don't need a JOIN clause at all. You can accomplish it by doing this:
SELECT * FROM b WHERE b.date > (SELECT MAX(Date) FROM a)
I