GrantSmith Coach

@bp_paulo_fernandes Are there other columns you can utilize in your join to restrict the number of rows being returned? Right now you have a one to many join happening which is causing the number of rows to skyrocket which it sounds like isn't intended. What columns define each row? Can you put all of those as your join…

Hi @sunny How is it not working? What have you tried? Are you able to log into the sample login page with mike as the user? Did you start up the yarn server to connect to? There's a lot of moving pieces with programmatic filters. It'd be helpful to know what you tried and what the outcome of it was.

Hi @user046467 Are you filtering for 'include' values or excluding 'exclude' values? If you're checking for only include values anything prior to 2021-07-01 won't be found because you don't have an else clause to mark it as include (it's returning NULL). How do you want this to behave for records prior to 2021-07-01?…

@user04105 I'm working with too many different SQL version, so sorry! It should be DATEDIFF not DATE_DIFF. Domo has some issues processing with the coalesce inside and not populating the date correctly. This modified version does the same and sets the difference to 0 if it's the first date in the partition.…

You'll need to examine your join conditions. It sounds like your join isn't restrictive enough and it's generating multiple rows. Are there additional columns you can filter on? Are you able to filter your dataset before your join to only include the records you need?

Hi @user041053 You'll need to utilize a window function and a date diff function to calculate the difference between the two dates. DATE_DIFF(`Date`, COALESCE(LAG(`Date`) OVER (ORDER BY `Date`)),`Date`)) DATE_DIFF is calculating the number of days between the two dates LAG(`Date`) OVER (ORDER BY `Date`) gets the Date value…

A few trouble shooting questions: 1 - Does the dataset exist in Domo? 2 - Have you tried the Windows fix? (turning it off an on again / restarting the workbench server)?

Hi @swap700 You might try looking into the new Dataset Views to append/union your datasets together. You can also use it to rename columns. https://domohelp.domo.com/hc/en-us/articles/360046074774-DataSet-Views The data needs to be of similar types. My question is what are you trying to solve by getting these IDs in the…

Hi @tobypenn You can utilize a window function in a beast mode to get the last date for a week and then compare it to the activity date and filter when they're the same CASE WHEN `Activity Date` = MAX(MAX(`Activity Date`)) OVER (PARTITION BY YEARWEEK(`Activity Date`)) THEN 1 ELSE 0 END YEARWEEK returns the year and week in…

Hi @OllieSouthgateAKA My assumption here is that when Domo is processing your data the underlying architecture / platform they're using to process the data doesn't respect row ordering when performing a rank operation. This is typically the case with Big Data solutions because it's faster to read your large data set in…

Subtotals would be the same issue where it's summing the values after the beast mode has done the calculations for the individual percentages. You'd need to calculate those subtotals in an ETL and stack them as well.

Hi @Shumilex You'll need to run your data through an ETL to calculate the totals for the dataset then append that row to your original dataset. You'd call the agent name "Grand Total". You can then add a beast mode to return 1 if it's not Grand Total and 2 if it is Grand Total and then sort by that then the agent name to…

Hi @Salmas, This isn't possible with a beast mode as it's performed on a row by row basis and doesn't have the ability to add rows to your dataset. You'd need to do it with an ETL.

Hi @pl_Luke Have you looked into Segments? https://domohelp.domo.com/hc/en-us/articles/4403089503383-Creating-Segments-in-Analyzer

Because how domo interprets data you need to wrap your aggregate in another aggregate - Domo will run your initial window function but then will aggregate again if you have other sorting or grouping in your card and gets confused when you only have a single aggregate (returns values for each row but can't aggregate those…

@B_Fullenkamp beat me to it. I'd recommend his method with a slight tweak to properly handle the last day of the month: CASE WHEN LAST_DAY(CURDATE()) = DAYOFMONTH(CURDATE()) THEN  0 ELSE  (SUM(`Goal`) - SUM(`Production`)) / (DAYOFMONTH(LAST_DAY(CURDATE())) - DAYOFMONTH(CURDATE()) END

Hi @Johnson Your beast modes are calculating the difference between when they 100th api call happend to today. Not necessarily time between API calls so when you're calculating metrics you're seeing a higher number for future months instead of the first month. Assuming you have multiple records / dates for each customer…

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.…