GrantSmith Coach

Hi @user046467 You'll want to look into a recursive dataflow where you can add the current timestamp when the dataflow runs (on Google Sheet update) and then append it to your output dataset. ETL 2.0:…

Hi @curious Does your sub instance have a separate URL or is it all contained within your main instance URL? If it has it's own URL have you tried using that URL instead of the main instance URL?

Hi @user033862 Depending on how granular you'd like the snapshots and the number of employee records this could end up being a lot of records. What I'd recommend is having a dataflow run every so often (probably monthly unless you need it more granular) where it could calculate the number of employees, hires, terminations…

Hi @AJ2020 Are you including `Company Name` in your graph at all?

Hi @curious I can't speak to the road map but if you're using APIs which haven't been publicly exposed you'd need to be careful because they could change at anytime without warning. I wouldn't rely on them if possible because the uncertainty of changes.

Hi @user012140 The box and whisker plot doesn't necessarily plot the min and max of your data but rather plots the 25th, 50th (median) and 75th quartiles. The whiskers are equal to 1.5 * the Interquartile Range (IQR) on either side. The IQR is the 75th quartile - 25th quartile (the size of the box). When displaying all of…

For testing, since you said it works with a where clause have you tried replacing your WHERE clause with WHERE 1=1 to return all the records? 

Hi @user053667 Since you're wanting to pull all of the data in a dataset - instead of using the query have you attempted to just export the dataset itself using the api? https://api.domo.com/v1/datasets/{DATASET_ID}/data?includeHeader=true&fileName=output.csv This would export your dataset to the output.csv file. You…

So for last week, what were the calendar and fiscal months you were expecting? 10 and 11 respectively? With the image you posted are you suggesting that the two numbers should line up? How are you grouping your data? Which columns represents the hard coded formula and which represents the new formula?

Hi @Crisocir You can utilize a windowing function to calculate the rolling maximum. MAX(MAX(`JDL Count`)) OVER(ORDER BY `Batch Date`) Window functions in analyzer require a feature switch. Talk to your CSM if you don't already have them enabled in your instance. 

Are you able to filter on another date field which isn't a beast mode? Can you try and calculate that date in a dataflow first and then do the filtering so it's not relying on the beast mode?

Hi @user006467 You can create a group in the Admin section (or have your admin do it if you lack permissions). You can then send a scheduled report to that specific group of Domo users.

Yes, there isn't a limitation on the number of records a CSV can store or that would be exported from the API to my knowledge. You'll just have a very large file.

Hi @user094816 You can't directly export the data in chunks from the Domo API, only the entire dataset. There are some sample Python files they provide to show how to accomplish this: https://github.com/domoinc/domo-python-sdk/blob/master/examples/dataset.py shows how to connect to Domo and export a dataset. I'd recommend…

Hi @user041053 I don't think there's a Q&A or Guidelines for the training courses however Domo does offer some Certification Prep courses to help you prepare for the certifications. You can find the Domo Professional Certification Prep courses here: https://learndomo.domo.com/learn/lp/7/domo-professional-cert-prep For…

Hi @user17569 There isn't a chart available to allow you to dynamically switch between competitors displayed (and others absorbed into the Other group) over time. The closest you could get would be a 100% area or stacked bar chart but it wouldn't be able to group competitors into an "Other" group if they're not in the top…

I don't but I'm sure the CSM can help translate the request to the beta feature.

No because the filter happens before the data is displayed so it's not there to show the totals since your card doesn't know about those rows.

Hi @user060355 You're getting NULL values because of your denominator case statement. SQL returns NULL if your denominator is NULL. You don't have an ELSE clause on your CASE statement so it's returning null because there isn't an add sale record. You can default your null values to 0 in your case statement and bring out…

Hi @user033119 I haven't used programmatic filters extensively and haven't run into your specific issue but have you tried translating the BETWEEN to be >= and <= clauses to see if that's an issue? For example: `date` BETWEEN `date1` AND `date` becomes `date` >= `date1` AND `date` <= `date2`

Hi @user031517 When you filter your data you're telling Domo to ignore your other data rows so when it goes to plot your single filtered rows and has no context of your other rows / totals so you only have a single value which is your total value as well. Instead of filtering you can still plot the data and keep the…

If you're using a specific date field instead of the current date you could format it with the same structure like: CASE WHEN `Year` * 100 + `Month #`<=`Year For Today` * 100 + `Month # For Today`THEN `Gross Revenue`ELSE 0END

Hi @user033690 You can utilize some built in functions to get the current date and do some addition / subtractions. CURRENT_DATE() will get you the current date MONTH() and YEAR() returns the month and year of the date respectively. We can do some math trickery to make the YEAR and MONTH a digit and compare the two values…

Hi @AbelMM From what I can tell your configuration should work. Have you tried graphing it as a table and validating that the beast mode is returning the correct data? I'm also wondering if it's a Domo limitation because it's a windowing function you're attempting to plot as a series but it's treating it as a separate…

Hi @user049190 Yes there is a limitation to the number of columns supported when importing AirTable data. I think it was around 500 columns. You also need to be careful of nested cells as it will expand every possible value to a new column in attempt to flatten the data which will cause your number of columns to expand…

Hi @Crisocir If you're populating a second column with the last date is this column NULL for records where it's not the last date? If that's the case can you graph a count of this second column and not a count of the original column?

Hi @jpjetlinx Last I've heard it's on the road map to get addressed but there isn't a scheduled date at this time. It might possibly be on the road map for sometime next year but I don't know for certain. I'd love to see the upgrade as well for that exact regex & json reason as well. Perhaps someone from Domo can give more…

Hi @user091749 You'd need to use a MagicETL 2.0 data flow to join the data to itself. Take the input and put it to a Select Columns and select the Project Name and Status Columns and then join it back to your original data set based on original dataset dependent project = the select columns project name, resolve the…

Gee thanks @MarkSnodgrass ? @AbelMM - The issue resides with your windowing function. Domo is close but isn't exactly the same as SQL windowing functions. Because you're adding an aggregate function (COUNT distinct) it's expecting your other columns in a group by statement under the hood. To make a long story short you…

Hi @user033690 You might be able to solve your problem using a windowing function however I'd recommend restructuring your data. I've done a previous write up regarding customized period over period data models. You can refer…