Best Of
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.
Re: Tagging Cards
@jaeW_at_Onyx I'm not sure that's the same idea here. Certifying a card doesn't give it a tag or organize it in a searchable fashion. This idea wouldn't just be used for identifying dev vs. production cards for admins but could also be used to group certain types of cards (trends, KPIs, categorical, etc) or by specific business measures or segments further in granularity than pages and collections can offer.
Re: How do I create a filter to show only the UPPERCASE records in a spreadsheet?
Hi @PSMTQsecofr
You can use a beast mode to do something similar. MySQL / Beast Modes have access to the UPPER and LOWER functions however there is no function to Proper Case a string so this defaults to "Mixed Case" if it's not either upper or lower case. It should still solve your issue of wanting to filter only Upper Case records. You'd just need to add the beast mode to your filter in the analyzer when designing your card.
CASE WHEN `field` = UPPER(`field`) THEN 'Upper Case'
WHEN `field` = LOWER(`field`) THEN 'Lower Case'
ELSE 'Mixed Case'
END