ArborRose Coach

Can you cast the varchar(10) to be varchar(25)? SELECT t1.EventID, t2.OtherColumn FROM Table1 t1 JOIN Table2 t2 ON CAST(t1.EventID AS VARCHAR(25)) = t2.OtherColumn

According to Domo support documentation, Domo Workbench has no limit. I use Workbench to schedule daily uploads. If that doesn't work, you might be able to do it with Python. I extract using Python but I never tried uploading using Python.…

I don't work with R, but I have a friend who has significant R experience. Passing this along…. Check Internet Connection: Ensure that your internet connection is stable and that you can access CRAN (Comprehensive R Archive Network), where R packages are hosted. Sometimes, network issues can lead to failed installations.…

The regular expression you're trying seems to be incorrect. Explanation: (?<=,\'): Positive lookbehind assertion to match the position right after ', without including it in the match. (.*?): Non-greedy matching of any character (.*?) between the ', and ',. (?=\',): Positive lookahead assertion to match the position right…

Could there be a difference in permissions between users? Does this user have access to something others do not, thus adding to the "weight" of the file? Things you might want to try: 1. Make sure there is consistent access to the SharePoint location where the file is located as well as associated resources. 2. Check data…

Are you all using the same environment? Is the other team member on a different system? Have you checked to make sure the add-in used is up to date? Sometimes issues and bugs can be resolved by updating to the latest version.

You may not need to store a snapshot to compare old data to new data. Depending upon the data, you can do a trend of Year over Year, Month over Month, Year to Date, etc. Look under chart types for Period over Period. YTD comparisons can also be done with formulas representing current year, previous year, previous 2 year,…

The error message you're receiving indicates that the Domo API endpoint /domo/workflow/v1/models/RunDataflow/start is returning a 404 Not Found status code, indicating that no workflow was found with the name "RunDataflow". Here are a few steps you can take to troubleshoot and resolve this issue: Verify Workflow Name:…

I use recursion to create a snapshot of a dataset. A simple google search "Domo recursion" will give you an example. https://domo-support.domo.com/s/article/360057087393?language=en_US

It appears that Planful has an API interface. Go to the Domo app store (via ETL) and enter JSON and hit enter. You will see various JSON connectors you can use to interface to other system APIs, without additional cost.

I don't know or use Planful, but I integrate quite a few different data sources into Domo, and extract a few things for integration to other files and systems. Using Domo Workbench, you can schedule imports from Excel files and other sources quite easily if direct connectors are not available. The DOMO ODBC is another way…

Thanks for the information. I could have used this ability as a solution to a question I asked last week.

Not sure if this support page reference helps: https://domo-support.domo.com/s/article/360042930154?language=en_US

I am not using this connector currently, but the Domo support pages indicates need for a ClientID, obtained after registering a Workday API Client. And it should have a token endpoint. In general, a JWT (JSON Web Token) is used as a form of authentication when connecting to APIs or services, including when using connectors…

https://community-forums.domo.com/main/discussion/comment/87799#Comment_87799 One row, regardless of the person, will only meet one side of the condition. It's a transaction like a payment. Each row belongs to a specific store in a specific year. The GROUP_CONCAT or LISTAGG creates a big list of the offices visited. When…

Thanks for clarifying Marcel. I tried it via the ETL. Domo didn't like the keyword so I used an alternative method to implement the same basic idea. You are correct, in the scenario I gave y'all. I didn't tell the whole story. My true data involves patients, and I need to count visits.

My last version didn't quite work either. But the theory still holds. If I separate the group by as shown below. The top one is getting me correct count and amount by month, store. The middle group by is getting me a correct total by year. The bottom group by is identifying the customers common to both. This gives me…

I am currently validating my numbers. I believe I have a process that is working. In the first group by, I total 2022 using GROUP_CONCAT. GROUP_CONCAT(DISTINCT CASE WHEN Year = '2022' THEN Store ELSE NULL END SEPARATOR ', ') I do the same thing in the next group by (Group By 1), totaling 2023. The output is then aggregated…

Thanks for the responses. Regarding the first suggestion, the resulting value for "In Both" results in only "out". The count is always zero. But looking at the data, I can verify there are instances that meet both conditions. @marcel, I am not familiar with LISTAGG. You say beast mode, as in a formula. But I don't know…

I'm interested if anyone has a solution. I asked this question once in a work session with Domo but I was told titles cannot contain any type of formula or beast mode.

Your value should look like a decimal before you format as percentage. (2.2 - 2.88) / 2.88

It looks like you are trying to do YTD comparisons. I would try it something like this…. Create a formula for SUM, AVG, COUNT for Current Year (CY) and same for Previous Year (PY). Then you can throw them up on to a card to see side by side comparisons.

I create a "link" using beast mode using a formula. First I get out notepad and write out the anchor reference string as if it were written on a web page. Then write that all out as if I were passing multiple parameters in a method of something like this…. destination_url?param1=something&param2=somethingelse Then I…

I create a "link" using beast mode using a formula like shown below. First I get out notepad and write out the anchor reference string as if it were written on a web page. <a href="destination_url">What gets clicked</a> Then write that all out as if I were passing multiple parameters in a method of something like this….…

I create a "link" using beast mode using a formula like shown below. First I get out notepad and write out the anchor reference string as if it were written on a web page. <a href="destination_url">What gets clicked</a> Then write that all out as if I were passing multiple parameters in a method of something like this….…

https://community-forums.domo.com/main/discussion/comment/87377#Comment_87377 If you review the screenshot I included, you will see there are operands included. So you can create the anchor reference to say things like where value in (X, Y, Z), or where value = X or value = Y. The problem to solve is how to gather the…

Coalesce is easier to apply then IFNULL.

There's a NerdGraph connector…. https://domo-support.domo.com/s/article/000005347?language=en_US

Yes, ETL has a rank and window tile.