ArborRose Coach

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.

https://community-forums.domo.com/main/discussion/comment/64143#Comment_64143 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 :…

As Mark says…you need an aggregate (COUNT, SUM) on the amount field. Place the month field and the amount field next to it. To order the months in chronological order, you can create a calculated field using Month({your date}). That will give you 1 for Jan, 2 for Feb, etc. Place that in the sort and the data will line up…

Can you use coalesce? Coalesce(`timefield`, 0)

Its hard to visualize what you are describing without a mockup or screenshot of your data. Perhaps the datatypes are not allowing something to total? If I had a list of things and only one column had numbers, I would expect the number column to total but not the other columns. If I'm aggregating totals, I can count the non…

https://community.dynamics.com/crm/f/microsoft-dynamics-crm-forum/257248/entity-not-showing-up/721058 Is there something you need to check on the back end?

@user015090 - with an html brick (like using images), you wouldn't upload the video to Domo. You "host" the video on a server, youtube, or wherever, and call the video as I showed in my earlier comment. In my test, I pushed a video up to a location I already had on the internet. Then called that video with its URL.

I tried using <video></video> and it did not work. As Aknowles mentions, perhaps something needs to be enabled. CONCAT('<div style="text-align:center;border:0px white;border-collapse:collapse;"><video width="320" height="240" controls><source src="https://mysite.com/image/movie.mp4" type="video/mp4"><source src="movie.ogg"…