ArborRose Coach

I think it would depend upon the specific functionality and actions that the add-in performs.

In most cases, the expires_in value is expressed in seconds. Therefore, in your example, the expires_in value of 3599 indicates that the access token is valid for approximately 3599 seconds, or about 59 minutes and 59 seconds.

https://community-forums.domo.com/main/discussion/comment/94496#Comment_94496 That's a question for Domo. Possibly someone else can comment with another way.

One way you might be able to get it would be through the Domo API using Python. import requests Set up authenticationheaders = { 'Authorization': 'Bearer YOUR_ACCESS_TOKEN' } Make API request to retrieve user profileresponse = requests.get('https://api.domo.com/v1/users', headers=headers) Check if request was successfulif…

The original posted question mentioned the dataset changing every morning. And that refresh was over-writing the responses entered. If you use more than one dataset, you can refresh the main set without impeding upon your answers in another. Use a "key" field, like an ID that is common to both. In the data, let's assume…

Okay…I see the connector you posted. It shows the credentials need to come from the azure portal active directory. That can get tricky and possibly involve firewall ports.

Have you reviewed the Domo information page? Have you attempted a connection and now receiving an error? https://domo-support.domo.com/s/article/360043436133?language=en_US

@Ashleigh - Thanks. Yes, it looks like it save it this time.

Hmmm…unfortunately it doesn't save when you hit apply. I made the change, hit apply. But when you open it back up, the triggers didn't change. Apparently you still have to hit the save and run.

Colemen's answer refers to having json coming through an API. As Jason mentions, the workbench can simply load it in from a file. Find Domo Workbench under Admin > Tools.

Argh. I was trying to stay off the forum so others can answer. But I recently had to solve this for myself. I created an ETL with an aggregate tile grouped by whichever fields were needed. With the visits in an aggregate and the amounts in another aggregate: The trick here is the count distinct values. Then AFTER this…

It's been a minute. I have to re-read the problem to see what it is you are trying to solve. Then I need to recreate a data sample. You say, "It is going in a gauge card, I just provided the table for context into the data." So you want a date filter, a table of data, and a gauge showing the percentage of repeat customers…

Ah, nice. Thanks for that information.

@Ashleigh - I know this is an older post but I'm curious…how did you get to settings on an ETL? That might have changed. I need to change triggers on an ETL that takes 45 minutes to run. I don't want it to start and then have to cancel it. I simply want to change the triggers before it runs this morning. Settings doesn't…

I've also noticed after hitting "validate" to validate the code, when you hit Save and Close it doesn't….close.

We haven't completed the setup of the Domo NetSuite connection yet. Your question is a nice reminder that I need to move some focus back to that topic. Have you looked at the Domo NetSuite Connector?…

Sounds like you need to do a left join on the matching tables and then a calculated field that says {columnname}: CASE WHEN {value in A} IS NOT NULL and {value in A}<>'' THEN {value in A} ELSE {value in B} END

Let's see if I have this correct….you have data that looks like this… You create a report that looks like this… But you want to unpivot the data so you can see All Sales, then all LBs, and all Cases. We can take the sample2.csv data and run it through an ETL to create Sample3.csv. Which gives us this.. And put that on a…

Assuming data looks something like my sample below, you could create a percent of total and then rank those. With a rank you can decide whether to display them ascending or descending and how many by filtering or setting the limit rows value. Dimension Value Totals A 50 200 A 30 200 A 40 200 A 80 200 A 100 200 B 20 150 B…

When I click the plus sign on the overview section and save, it saves there no problem. Where are you starting the card?

Can you show us any kind of mock up of what you are doing currently with your spreadsheet? There are quite a few forecasting videos and Domo examples on the web. Have you reviewed any of them? I would first look to the forecasting tile in the Data Science are of the Magic ETL…link….…

I do it as Grant mentioned - add an output on the dataset can give you a dataset to debug. I label that output set with the word debug so they are easy to find and remove afterwards.

You should be able to programmatically log into Domo using Domo's API OAuth 2.0 authentication to give you an access token. Register your app to get client credentials (client ID and client secret) through the developer portal. Implement the authorization to get an access token and redirect back to your application. Not…

It doesn't sound like a Domo issue. Sounds like something that needs to be addressed in the HTML and javascript code used to display the form. Different browser platforms have different compatibilities. Its typically the developer that needs to address the code to make things work.

This link may be helpful… https://community-forums.domo.com/main/events/50-lunch-learn-don-t-be-afraid-of-the-big-bad-cli-tool?utm_source=community-search&utm_medium=organic-search&utm_term=CLI There are lots of tools to use and different ways to do things. I guess it depends upon your familiarity with using command line…

Have you checked the date range on the card to make sure it includes all dates? In your screenshot it looks like you have limited the dates.

To apply the logic you mention, you'll need to come up with a formula for the avg of the current months visits. And count working days. CASE WHEN WEEKDAY(Date) NOT IN (1, 7) THEN 1 ELSE 0 END And something to calculate the average visit per working day. SUM(CASE WHEN YEAR(Date) = YEAR(CURRENT_DATE()) AND MONTH(Date) =…

The formula might be something like: sum( case when YEAR(date) = YEAR(DATE_ADD(CURRENT_DATE(), INTERVAL 1 MONTH)) and MONTH(date) = MONTH(DATE_ADD(CURRENT_DATE(), INTERVAL 1 MONTH)) then visit else 0 end ) Assuming you have entries for visits next month. Change the interval to get other future months.

I can't find any links to a livestream for 2024. And a filter on the forum doesn't show any mention. I concur with @DomoDork. I think we have to wait for links to be sent out after events finish. But here's an image you can view while you wait. lol…

I've shared my method recently. I create formulas for CY, PY, P2Y (current year, previous year, previous 2 year)….or month such as month to date compared to previous year month to date…..using a formula where the formula compares the date in data with the current date. If you want year to date or month to date, add a line…