Rich

domo

💎

About

Username
Rich
Joined
Visits
31
Last Active
Roles
Member, Domosapien, CS Leaders
Points
105
Badges
11

Comments

  • 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…
  • 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…
  • 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 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, 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…
  • @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…