Rich Domo Employee

@rileystahura any thoughts on this one? I know you do quite a bit with Domo apps.

Hi HFASG, Domo Support has worked on this topic today. I believe the issue has been resolved for most or all customers. Is the issue still troubling you now? If yes, please reach out to Domo Support with the most recent datasets impacted. Thanks.

Hi PacoTaco, Thanks for your post - it has been a long time since I last looked at this one. Since that time, our feedback process has changed a bit. Please submit your feedback about the leading zeros in one of these two ways: 1. At the top of your Domo experience you'll see a menu button with a "Feedback" option. Follow…

Thanks for the additional context. I think using a beastmode forumla will still give you the flexibilty and accuracy you're looking for. I have used your formula and example data to mock up a few more screens and have highlighed in each the effect of the formula rolled up at different levels of grain. Screen 1 A and B are…

Hi, I've roughly mocked up what I think you're discussing. You have a location based top level card, a supervisor level 1st drill, and an agent level final drill. You have data that captures calls and sales for each of these agents with the date, supervisor, location (office), etc. It also sounds like your raw data…

Hi Feyo, Seems to me like this would be a join. It depends at least a little bit on how your data is set up, but the easiest could simply be a cross join between the two datasets (but that could be a cartesian product if you're not careful). You could do another join type depending on which columns you have in common…

Hi, I think you are asking if a single custom connector could be established to create multiple datasets of different schemas. Perhaps another way of saying that is can a single connector be created to configured multiple reports with different schemas for each report. If that is your question then yes! Over at…

I think the idea of hiding a card based on a formula is a neat idea. Please visit the Dojo Ideas Exchange http://dojo.domo.com/t5/Ideas-Exchange-suggest-and-vote/idb-p/Ideas. You can search existing ideas and then vote for it if it matches what you have in mind. If you cannot find it, please create a new Idea which can…

I think this is a great question, and search is probably the place for a solution to this. I'd recommend adding a request for a feature to search annotations. This could be done either be adding a specific type of result for annotations or perhaps by adding in a specific filter under buzz results for annotations. The best…

Hi, To the best of my knowledge, there is not a way to hide/show a card based on an event (such as summary number present or not). However, can you help explain in which circumstances a target value would not be present? Depending on your need, I'd think that perhaps a case statement beastmode could be used to provide…

Hi Michelle, I'm working with a client right now that uses the Facebook Ads Advanced connector and they are able to get 13 columns with conversions and conversion values by using FB Pixels. I believe the columns you'll be looking for to drive these insights are: * Actions * Unique Actions * ActionValues When those columns…

Hi, I've only had to do this once, and it was for a client I no longer have access to so I cannot double check my work; however, if I am remembering correctly the thing we needed to change was from this: ga:dimension1,ga:dimension4 to dimension1,dimension4 @DaniBoy perhaps a check with the connector team will be needed on…

Hi PS-ALW Great question. I doubt that a beastmode itself will be sufficient. I'd do something like the following: ETL Actions: 1. Count the number of days between the Schedule Start At and Schedule End At. You will divide the Price by this number of days to get a by day amount to recognize. 2. Next, you'd join this price…

Sure thing. So here is what I did to model your question: I created this string (my garbage example) as a URL model of what I think you're looking for: https://www.google.com?formula=yes&donewithstring=the-end I then used your code example to parse it, and I think this will work the way you want (added in red below):…

MattRK - are you doing this string manipulation in a beastmode, Magic ETL, or SQL? My answer changes a bit depending on which environment you're in.

Hi Lisa-Chang, The first thought that came to mind for me was using PDP in your solution. It would be ideal to just have 1 card to edit and maintain and have any changes immediately apply to all views of that card right? But sometimes the dataset that powers those cards have some sensitive data in them OR you just don't…

Hi Matthew, The closest we've seen in SQL is to determine what makes a row unique and check against the existing dataset for matches. If you are able to find matches then you delete those rows from the existing dataset and replace those rows with their updated entries from the new dataset. Additionally, any net new rows…

Hi, Easiest way is to do an abbreviation: CASE WHEN `Value`/1000 > 1 THEN CONCATENATE(ROUND(`Value`/1000,2),’k’) ELSE CONCATENATE(`Value`,’’) END Otherwise you can take a rounded version of the thousands place for the first part, concatenate a comma for the middle, and then take the remainder of the hundreds place to…

Hi, I used an example file containing the # sign as the first character in a row. I was able to get this load into Domo by using the Excel connector and the rows came in. I see you're using workbench so the experience may be different there. Perhaps you're using workbench for the scheduling or transforms features or due to…

Upsert is a really useful approach to updating datasets. It is already feature of some datasets, but not all; and it currently varies connector by connector. We do not yet publish an upsert approach via API for Domo datasets, but when that feature becomes available you will find it here:…

Hi Mritter, There are several approaches to getting the data you're looking for out of the cloud. It is worth exploring each of these solutions depending on which cloud solution you're using. 1. If you can deploy Domo Workbench to the cloud server you could connect to the database using Workbench and "push" data into Domo.…

Hi Jeffcavallo, Yep I think the Gantt chart may be exactly what you're looking for. I mocked one up with sample data pretty quickly. * You need a dataset with the following attributes * Ad Campaign Name * Start Date * End Date * Campaign Category * Once you have your dataset with those entries you'll create a new card and…

MySQL external connectors: If your MySQL database is located behind your firewall you'll need to whitelist inbound traffic to that server over certain ports. I'd suggest you Buzz Domo Support within your instance to get the list of IP Addresses to white list. Once you've configured the firewall settings you should be able…

Can you give examples of one card type that is working and one card type that isn't working? Also, double check that your fields are getting the right data types you're expecting (dates are dates, etc.).

Hi Sethberg, Dynamic conditional formatting in a sumo card would be amazing! I can see how you could compare against some common field or row elements such as Max, Min, Avg, etc. For now, the product doesn't seem to support dynamic conditional formatting, but I'd suggest you go to here: Dojo Idea Page and submit the idea…

@ckatzman no worries! When I've seen this with our global maps or maps of other countries this often means you have an outlier or a blank value. Let's say you drill down into Oregon. You're expecting to only see the counties of Oregon, but you're seeing all the counties across the country. What I've seen is your values in…

Hi ecenteno, Mixed news here. I've duplicated the trouble you're experiencing with leading zeros from an excel sheet - even when Excel has them formatted as TEXT. Domo does interpret them as whole numbers and strips the leading zeros at import. That means using Magic ETL is unable to restore those zeros natively. Here's…

How do I create county and zip code drilldown in a U.S. map? You can create U.S. maps in which users can drill down on states to see values by both county and zipcode. For example, a U.S. map may show sales for western states, as follows: In this map, a user could click on the state of Oregon to show the sales for all of…