Best Of
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
Re: Is there a way to prevent a card in a story page from using the page filters?
Hi @mberkeley
Page filters apply to all cards on the page so you can't selectively apply the filter. What you could do is utilize some filter cards (one for customer, one for industry) and chance the card interactions for each filter so it only applies to your cards individually. You might still have users using the page filters which would still continue to cause issues. The other option is to have a separate datasets with different column names or don't include industry in both datasets and customer in both dataset. Dataset Views (in beta - talk with your CSM) are good for this as they update instantaneously and are easy to use to drop some columns.
How to create custom color schemes?
I would like to be able to create cards with different color schemes.
I've noticed the map cards have the ability to do this with just a few simple single-color schemes, but I would like to be able to use these same schemes (and hopefully even a larger variety of schemes) with specifically bar/line graphs and all other card types.
Sometimes I have lots of series and don't want to change the color for each one, how can I go about setting a color palette for the entire card?
Talkwal