ckatzman Contributor

@smurray, @Rich I'm afraid i'm just being obtuse. I have a dataset that has state code, has fips code, and i think has zip-code (not so worried about the latter for the moment). I have a card that is top view of states. I have a drill-down built beneath that based on FIPS, howwever when i click the state level to initiate…

You could do that on a table card using HTML to add situational images, increase font size, change color, etc. Examples of this capability were demonstrated at Domopalooza Beast Mode Boot Camp session. I don't have HTML expertise, so i'm not the one to guide "how", but that's the way I would go in looking at how to do…

@Rich Can you clarify for me how, on drilling down to a filtered state level, you display a zoomed view of just the focal state? Is there a setting that i just haven't figured out somewhere?

I've always encountered this same problem of wanting to stack tallest to shortest first, and then secondarily by a "series" order, but could never get it to work with just using a single "series" value. I worked around this by creating a separate beast mode result for each possible series value, and then bringing each of…

I'm not able to see your image, but based on description I believe I had the same issue and found a cheat solution that worked for me. Rather than using a single series to define my "stack", I used Beast mode to create independent results for each possible series category, and brought in those multiple pre-aggregated…

Similar question was posted in the Dojo recently... I posted the following (link) suggestion related to doing it in DataFlow, but the same might work in BeastMode. I have found that MySQL functions will work in Beast Mode even though they are not reflected as part of the Beast Mode function list. Extract Domain from Email…

In your SELECT statement, could you embed a LOCATE() function within SUBSTR() function? SUBSTR(`email`, (LOCATE('@', `email`) + 1)) If that works correctly, I would expect it to pull from a value of 'john.smith@generic.com' and return a value of 'generic.com'.

Are you really drilling at that point, limiting your defined population by an attribute, or just changing the time-series grain at the top of the card? In other words, Change from "This Year", to "This Year by Month", or "Previous Quarter by Week"?

@Kawasaki-San, I don't believe analyzer/filter will stick to a card, but if you have Admin permissions within your Domo instance, you can set a PAGE-level Analyzer/filter and it will remain in place for other users. Might try playing with that, perhaps set the card(s) in question on a dedicated sub-page so that you can…

Hi Celine, I saw your post yesterday, and was curious about the possibilities. DOMO has rolled out capabilities for building your own API connectors, something I was just introduced to yesterday in a call. Check out https://developer.domo.com/; Build Your Own Custom Connector. I also checked out the Census Bureau website…

That's brand new functionality that was shown last week at Domopalooza. I think it's only in beta at the moment, not sure when it will be deployed fully in production. I believe there is a process for companies to be part of the beta, meaning you get early access to it (and all that comes with that... possibly buggy?).…

@akern, check out this previous post that was based on DAYOFWEEK, which may be helpful as well. https://dojo.domo.com/t5/Beast-Mode-ETL-Dataflow/Matching-dates-from-two-data-sets/m-p/6612#M431

Sunday to Saturday. Sunday = Day 1, Monday = Day 2, etc.

@Sara26, here's a link to a Dojo post that has some examples of embedded HTML to pull in images to a table card. https://dojo.domo.com/t5/Domo-Dojo-Contest-January-2016/Most-Actionable-Impactful-Card/idi-p/8244

My organization has Workbench installed on a Citrix Remote Desktop instance. It installed the same way you would on a local desktop. The advantage here being that it's "always on", enabling us to configure our jobs to use the scheduling features in Workbench (which run through Windows Task Scheduler) to fire some SQL…

In card edit mode, go to chart settings, data label settings, and in the text box (a hover will appear to help guide you), pick the type of label value you want to display. for example, type '%_VALUE' and the macro will populate the # representing your sum/count/etc. for each bar. you can still play with other settings…

Click on your avatar/image in the upper right of the Domo page, select profile. On your profile page, the Org Chart link is in the upper right corner.

Glad it helped. Something to keep in mind when you have your County level map as a drill down... you can delete the blue "filter" that's showing for the state through which you drilled down, and then you'll get to see your results nationwide at the county level too.

Sara - To a Sumo card, I don't know... I tend to think not. You can to a table card, as well as resizing (to your question), but it requires the use of Beast Mode w/ embedded HTML coding. While it can be done, Domo staff will not support the HTML piece of what you are trying to do. there are some pretty handy Dojo…

By chance do you have the DOMO iOS app installed? If so, you might look to see if you are running the most current version. There was a problem with the iOS app where it would get caught in a perpetual loop of trying to login, and if the password failed, it would try 10 times and then lock you out of your account until you…