GrantSmith Coach

Hi @Johnson So do you have several rows for each customer when they make their 100th API call? Do you have a date for when the customer was created and you're calculating the time difference between those dates or do you only have the 100th api call date? Are you calculating the days between the 100th API call dates or…

I really enjoy helping solve unique problems and learning of unique solutions to those problems. It really helps spread the knowledge around to users.

Hi @AlexF Short answer: not easily if possible you could completely reimport your dataset with the replace update method if you have all of your data You could use a magic Etl dataflow to remove the duplicates with the remove duplicate tile or use a group by and group all your columns together and take the min or max value…

Hi @gospel Its calculating the percentage difference between your two values and not the percentage point difference like you’re expecting (95.42-94.83)/94.83 = .00618 * 100 = 0.62%

@user18189 If you're doing this via a Magic ETL2.0 you can utilize these formulas in a single formula tile: (MAGIC ETL2.0 only - I've broken them down for easier reability). julian is your date field with your Julian date. This formula assumes you'll always have a 7 digit date. JDAY: RIGHT(`julian`, 3) JYEAR:…

HI @user18189 Which format are your Julian dates in? YYDDD or YYYYDDD? Since Julian dates count the number of days and doesn't use months you'd need some sort of DATE_ADD function call to add the number of days.

Yes please!

Hi @reichner015 Are you selecting to view your data for the current quarter by month in the date selector (upper right of your chart)? Are you using your opportunity date as your x-axis on you chart? Also with your beast mode `QUARTER(CURRENT_DATE()) AND YEAR(CURRENT_DATE())` isn't really doing anything as it will always…

CSM is your Customer Success Manager - your contact at Domo. I'd talk with them about your specific issue.

Hi @swap700 Which GA connector are you using? I've typically found more success with the Google Analytics Enterprise connector. Typically error messages like this aren't very helpful and could be a large number of issues. You might want to reach out to your CSM to see if they can give you more information on the exact…

Hi @reichner015 What is the granularity of your dates in your dataset?

Hi @reichner015 How is your underlying data formatted? Is your data broke out by month or by quarter or day?

Hi @Liliana There isn't a simple way of swapping out one dataset for another. You'll need to do each one manually. With DataSet Views now available going forward I'd recommend any cards or dataflows point to a data set view of your original dataset so that when you underlying dataset changes you can just change the view.…

That's because you can only build it going forward, you can't historically go back and get the data because of the API limitation allowing only the last 30 days. You'd start building your history today so that in the future you have it for your analysis.

@DanielA If you could accept my answer as a solution so that others can more easily find this question and solution if they're having similar issues I'd appreciate it.

If you're wanting to just view it as a table you can utilize a Pivot Table card. https://domohelp.domo.com/hc/en-us/articles/360043429473-Pivot-Table You can set the name as the rows and the question as the columns with your value as the value.

Hi @AnnieL https://domohelp.domo.com/hc/en-us/articles/360042931954-DataSet-via-Email-Connector Does the download link go to a website to click a button or link to download the excel file or does the link directly download the excel file? I think there may be an issue with Domo no being able to process a file from a link…

Hi @Daneia I believe this is a limitation with the Instagram API and not Domo itself. Typically what I will do in cases like this is to take weekly or monthly snapshots of my account metrics to see then data change over time but it lacks historical data because of the API limitations. I’ll use either a recursive data flow…

Hi @MB_Dem You'll need to work with your Domo Admins to get your role changed as only the Admins typically can do this. If they're generic D2L emails - who owns those emails? Can you work with your IT team to get access to those accounts to give yourself access? Have you talked with your Major Domo?

Hi @calebtyrone You’ll want to log a ticket with support as it sounds like an issue on the back end they could help investigate.

Hi @Shumilex Looks like an operator is missing between `WrapUpMin`) and (`LunchMin` What should that operator be? You'll need to utilize your CASE Statement to check for your denominator value being 0 prior to running the calculation with your denominator. CASE WHEN `ServiceName` like '%Manual_Only%' THEN CASE WHEN…

@mdixonii You'll need to reach out to Chuck Irwin (@chucki) to get access to the beta features and the Dojo Beta Forum.

You might be able to get all of the data via a segment however you can't do an inverse filter like you're wanting to do. https://domohelp.domo.com/hc/en-us/articles/4403089503383-Creating-Segments-in-Analyzer

There isn't a way built in to Domo which will allow you to get all the values except the one you're filtering. Domo works by running the filter first and then applying any beast modes. So with your beast mode attempting to get records which don't equal your filter there never will be any because they were filtered out…

@MarkSnodgrass Interesting as there isn't a Microsoft SQL Writeback Connector listed in the Data Connectors in my instance. I'll have to dig into why and if it's still supported. Thanks for the KB article.

Try this: DATE_ADD(`timePlaced`, INTERVAL `timeEstimate` MINUTES)

Hi @dprince You can't use workbench to write back to MS SQL. It's only to pull data from the defined sources. There doesn't appear to be a writeback tile to use for MS SQL either but only Postgres, Maria and MySQL databases.

@Kenn Do you have the check box for "Publicly embed content Allow public embedding of Cards and Dashboards" checked under Admin -> Company Settings -> Company Overview checked?

Hi @Ashleigh I don't believe there is, you can get the US or AU holidays from the Domo Dimensions connector referencing the calendar.csv or AUcalendar.csv files respectively. There are other API services which will get you international holidays like https://www.timeanddate.com/services/api/holiday-api.html but you…

Hi @Saketh Here's a more compact version utilizing modulo operations and date format CONCAT( -- START -- +5 not 6 since it's inclusive DATE_FORMAT(DATE_SUB(CURRENT_DATE(), (MOD(MONTH(CURRENT_DATE()), 3) + 5) MONTH), '%Y-%b'), ' - ', -- END DATE_FORMAT(DATE_SUB(CURRENT_DATE(), (MOD(MONTH(CURRENT_DATE()), 3)) MONTH),…