Best Of
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
Re: How to dynamically add "missing" data
You can do this by creating a dataflow and adding the Domo Date Dimension dataset that provides all dates for whatever range you need. Look for it in the cloud apps. You would then add a constant of 1 to each dataset and join on that column so that you would get all dates. You can also use the filter tile to restrict what range you want.
This should get you what you want.
Re: Beast mode: Format numeric fields in Concat function
agreed... I find myself using the summary bar to do the real comparison against plan (metric) and formatting with RAG colors to designate if on track/ need improvement/ major issue. Both the formatting is complicated and especially on mobile devices the html coding doesn't work.
Re: Beast mode: Format numeric fields in Concat function
I haven't found a better way and sometimes the concats we use get really long. I wish Domo had a drag and drop summary number where we could add several numbers together and format it how we would like with a little more ease.
jstan
Re: Cards are not sharing Properly while sharing the dashboards to the user
just to clarify, you're sharing dashboards with people. but after the initial share they don't have access.
Then you remove them and add them again they have access?
if yes, that sounds like a bug, take it up with Support@domo.com
but test it first. share a new dashboard (with cards that people don't already have access to) then have them try accessing. Remind the user to refresh their browser just in case page history is cached.
Side note, but not directly related to your problem. Don't share content with individuals, to scale your implementation and manage sustainably, share content with groups.
Re: Change line type to dashed in line graph
It appears that it is still not an option. Domo uses the dashed lines for the min max and average values, so maybe that is why they have kept it from being available as a choice in order to avoid confusion.