ArborRose Contributor

Comments

  • I don't see any enable button on the Alerts section. There are settings in the General tab that configure alerts and notifications. Perhaps this is affecting what you see? When I set an alert on a dataset, the alert shows up in ALERTS section clicked from the top ribbon bar. I can see the existing alerts and configure them…
  • I build "core" ETL datasets, that I then call within other ETLs. Many of our datasets come through API calls. I need to join labels to the identifiers for them to make more sense or to standardize name. Such as insurance company ids that we want to have common labels. So I will build out the base ETLs so they become…
  • I start with a google search for articles, topics with keywords. This brings up Domo knowledge base or articles or community questions. Several of which have humorously taken me to my own past posts.
  • Wow….that's a significant thing for Domo leave out. I should not have to create all kinds of work arounds like bricks for a simple thing like maintaining the date range.
  • My concat statement looks something like this (redacted to show different field names) CONCAT(' <a href="https://mydomain.domo.com/page/***********?pfilters=' ,'%5B%7B%22column%22%3A%22office_id%22%2C%22dataType%22%3A%22string%22%2C%22operand%22%3A%22IN%22%2C%22values%22%3A%5B%22',`office_id`,'%22%5D%7D%2C'…
  • I use a concat like the one above but my screen has confidential data I cannot show. My link works just fine…it opens the page and performs filters on three fields. The problem is..my original screen is a summary, and the user can set the date filter. And I don't know how to carry the date to the next page. Assume the…
  • My pfilters are working but the link does not maintain the date range. If I allow users to set date between…how can I include that as a pfilter so the detail page limits to the same range?
  • Thanks. I was lacking the encode step. If this helps anyone, this statement concatenates three filters as a link. CONCAT(' <a href="https://domain.domo.com/page/*******?pfilters='…
  • I've done the this process, but I did not encode any part of it. The link moves to the desired page but all the filtering is dropped. Thus the question about whether anything else is need. There may be something wrong in my format. I've reviewed half dozen examples but can't get filtering.
  • It took me a bit of effort to figure out how to export Domo data to SQL (without the ODBC driver). I solved this with a python script that reads from Domo and writes to MS SQL. This is a solution I believe the Domo community would like to see. • How to create and run a python script (for non programmers) • Configure the…
  • Thanks for all the responses ya'll. I'm very excited to try this Grant.
  • Table associations and calculated formulas are inefficient when the data has continual additions, and the dataset will have many entries. I need scaled automation that doesn't require me holding its hand. The task is delegated to someone who won't have permissions to the dataset or ETL. Consider my CASE formula for Blue…
  • Is there any way to put a formula or substring into value mapper? In essence, I want to search for a small string, and if found in the data field, replace the entire field with a static value. Case When lower(insurance_company_name) like '%blue%' or lower(insurance_company_name) like '%cross%' or…
  • Here's a first thought I had. I am still theorizing.
  • I'm looking for a more efficient method. This list will have hundreds of thousands of manually typed named. I don't want hundreds of thousands of entries in the replacement table. A left join must match exactly. I want something such as applying more than one regular expression against the incoming. CASE WHEN {reg exp…
  • Sorry…that list didn't paste well.
  • You might want to look back at this previous discussion (linked below). Is it possible you have a transparency in your image? Its also my understanding that email like Outlook doesn't define a background color. It looks to the browser settings. Example - in internet explorer, go to tools > internet options > colors and…
  • @Domodork - I like the idea. I may use the ODBC driver at some point in the future. This API call is a special use case that we want to go through the API.
  • Yes, Domo can use HTML tags but some of us don't want HTML injected into data fields. I get frustrated that I don't have UI design flexibility that are found in ancient tools like SQL report builder. Sometimes I feel like I'm building web pages inside Domo rather than just building them in .Net
  • Just realized I already have a script that I use to export csv files - that pulls me the dataset with the headers.
  • You can use a python script to call the DOMO api and connect to the dataset used by the cards. You can then write that data to a local csv or pass it on to your SQL server, etc.
  • You could put a filter on the data….create a calculated field such as CASE WHEN {there's data} THEN 1 ELSE 0 END. Put it on filters and the output should keep those from showing
  • I would check all your quote marks to make sure you are terminating the proper html tags. Mark sure each opening single or double quote is ended at the appropriate place. When I have done tables this way, I use two cells in a table. The top cell may include a photo using something such as And then another cell would have…
  • {Re-reading your original post.} You could find your most recent record's date using some kind of max date. But it seems you know the scheduling delay already as somewhere around 4 days. Yes…as added columns. My comment shows how I do this kind of thing dynamically. The formula is saying….take the sum of all the records…
  • Solved it. When I couldn't get rid of the comma, my first guess was also to change the field to text using concat() but it didn't work. My previous version workflow still exists under a different name and it works just fine. Both use the same formula for creation and I duplicated the card being used as a dropdown filter.…
  • I do this using calculated fields that represent this year and last year. So Last Year YTD would be something like this… sum( case when YEAR(transaction_date) = YEAR(DATE_ADD(CURRENT_DATE(),-365)) and transaction_date <= DATE_ADD(CURRENT_DATE(),-365) then amount else 0 end ) And obviously This Year YTD wouldn't have the…
  • You could also probably use rank to determine the condition.
  • You could create a calculated field that identifies the lowest and highest. So when its min, the fields says lowest, and its max the field says highest, otherwise its empty. Then use color rules based on the calculated column, when condition='lowest', set color. When condition='highest', set color. etc.
  • (?i)\bRMP I haven't been doing regular expressions in Domo. But the regular expression above says use case insensitivity to find "rmp" or "RMP" or "rMp" etc in the string. \bRMP2\b Would find RMP2 but would not find RMP.
  • Euchre….lol. Jason, I live in Dallas. People in the South don't know euchre let alone how to spell it. Let me know when you figure out how to use Domo to play an online euchre game. The data set and sorting is easy. The cards in the euchre deck : name of card, suit, color (for bower identification) and value. A field to…