ArborRose Coach

Btw…those identifiers in the URL are important. They can be used in Python code to identify a dataset to export the data to a local Excel file.

https://community-forums.domo.com/main/discussion/comment/86842#Comment_86842 They may not be able to share them via Domo, but each URL has an identifier associated to the dashboard. And those are unique. If I copy the URL from my browser and shoot it to a coworker in Teams or email, they can attempt to pull the card. They…

You can bring in portions of your data as a dataset and then create a ETL flow to append each to compile a larger dataset. Say you want 2 years of data. The previous years data you might want to pull on the week, each Saturday. The current year, you might want to pull the current quarter daily and the past quarters weekly.…

According to the Domo documentation on Locking or Unlocking a Page, "Locked Pages also cannot be shared by users if they are not the owner or do not have an "Admin" default security role or a custom role with the "Manage All Cards and Pages" privilege enabled."…

It sounds like you defined formulas on the ETL that are replicated in beast mode on the card of the dashboard. The beast mode on the dashboard would see the calculation already exists in the dataset with the duplicate on the card not being part of the ETL / dataset.

I tried background colors and hate the result. In this case I am trying to mimic an excel sheet. Without subheadings and borders, my Domo version isn't very readable. To differentiate columns, the descriptions get out of hand. This is such a basic html ability. I fail to see the usefulness of an html table that doesn't do…

None of these solutions work. A pivot table is inappropriate to my need. A mega table only lets me set the global style for verticals (as far as I can see). I need to set specific columns left and/or right borders so I can "section" the dashboard.

Ashleigh - can I control the borders between specific columns? I need to create visual sections of three or four groups of columns. I'm not seeing that control with a Mega table.

Mega Table should work just fine. Thanks. Any idea how to I could make subheadings?

If your dataset has something you can use to identify the incremental changes, yes. A recursive data set can pull records and append the records to an existing dataset. I would look at doing something similar. You just need to make sure your ETL accounts for changes in records. The following link should give an idea……

https://community-forums.domo.com/main/discussion/comment/86437#Comment_86437 Michelle is correct. In fact, I am staring at one of my own cards where the grand total shown is completely wrong because of this reason.

I too think your DISTINCT is probably the reason. If you are trying to count, I would create the CASE statement to be COUNT(CASE WHEN {conditions met} THEN 1 ELSE 0 END)….without DISTINCT.

I do this for year to year trend comparisons using chart type "bar line". I set the data range to the increment (month, quarter, etc). It gives me the current year as a bar and the prior 3 years as line overlays. As the year progresses, we see the performance comparison.

I inquired about a similar functionality. I wanted to give users a note taking ability - related to the Domo card. When a specific filter was applied, the user would see the notes written about that selected person or criteria. We had a work session for Domo to show me an example like Colemen's description but they weren't…

Thanks. I found a formula Grant used in a different thread and using my fields it comes out with the correct days. https://community-forums.domo.com/main/discussion/52686/domo-idea-exchange-beast-modes-business-days-prior-to-today

Neither of these formulas worked properly for me. I am currently in the first week of 2024. Dates from half a year ago are not calculating correctly.

I have not tried nesting, Mark. I did try simplifying the criteria. I ran one that was just something simple like… CASE WHEN LOWER(insurance_company_name) LIKE '%aetna%' THEN 'Aetna' END Same thing..it couldn't find it. It's all good feedback, thank you. The fact that Colemen says his comes out correctly, and y'all seem to…

@ColemenWilson - it appears as a formula tile near the end of an ETL. I have diverted a debug output so I can see the values immediately after the tile executes. I've also taken a few steps of the condition to a test ETL and I get the same results. It simple doesn't see the substring in there.

https://community-forums.domo.com/main/discussion/comment/79378#Comment_79378 There's nothing confidential in this, so I'll show a clip of my actual results. After the formula happens, if no condition is met, the field is populated with a string of X's. The formula that overwrites the X's…

https://community-forums.domo.com/main/discussion/comment/79387#Comment_79387 It's simply not finding the occurrence. It should see that those strings contain "aetna" in whatever case and then give the appropriate new field value "Aetna - Dental".

Here's link to Powerpoint plug use… https://domo-support.domo.com/s/article/360043437953?language=en_US

If interested in scripting with WinSCP, here's a link to some examples. https://winscp.net/eng/docs/scripts

I do this with code outside of Domo. I created a small visual basic executable that downloads from an sftp site, to a local file. It then copies and renames the file to something easy for me to upload into Domo using Domo Workbench. I also copy a dated version to a folder so I can keep a history. You can also script with…

I would use Domo Workbench. It's easy to setup and you can schedule it.

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? https://domo-support.domo.com/s/article/360042925814?language=en_US When I set an alert on a dataset, the alert shows up in ALERTS section clicked from…

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…