GrantSmith Coach

Hi @user089739 Because how the connectors work you'll need to rebuild your datasets and reconnect your cards.

Hi @Fadem What exactly is your issue? What are you getting currently and what are you expecting? Which tool are you utilizing to do you join? View? Magic? MySQL? DataSet Views and Magic ETL allows you to specify the join type in the UI. MySQL you need to specify either LEFT, RIGHT or FULL OUTER before your join to do a…

Hi @etszyingho As part of your filter you can negate the filter by passing in "not": "True", It would look something like: { "dimensionFilterClauses": [ { "filters": [ { "not": "True", "dimensionName": "ga:pagePath", "operator": "", "expressions": [ "/grammar-and-plagiarism/" ] } ] } ] }

@User_32265 That is a bit interesting as both values should be appearing in your list. Are you grouping your data by anything or are you graphing your table by month instead of by day in the date selector? As for your ETL you can use the Group By tile with one caveat. It requires you to group by something. You can add a…

You're correct. There are 5 default roles and I confirmed in the API as such. The documentation needs to be updated.

Hi @usergru It's not possible with the SFTP connector however have you thought about utilizing workbench, scheduling an SFTP sync to download files in the folder to a DataSync folder and let workbench handle creating any jobs that are needed?…

By definition if it’s an internal API endpoint the Domo won’t be able to access it when you attempt to run your script. Your Domo instance wouldn’t typically be in your local network. looks like your issue is that graalMessage is undefined likely because it can’t communicate with your internal api endpoint

@Derreck - No. Window functions aren't supported in the formula tile in ETL 2.0. You can use the Rank and Window tile though to do the same thing.

Hi @Mike_Shrift What specific issues are you having with the values? Without understanding the problem it's hard to help fix it. Whenever I'm doing Period over Period analysis I utilize a custom date dimension table to help identify this week vs last week for example. I've outlined this process before in the dojo here: A…

It's very likely some backend issue that Domo will need to take a look at. I'd recommend reaching out to Domo Support as they'd have more insight into the exact error that's occurring.

Do they own anything else besides a dataset like a view, fusion or dataflow? Have you tried utilizing the CLI tool and the swap-owner command to try and swap anything they might have over to a new user? https://domohelp.domo.com/hc/en-us/articles/360043437733-Command-Line-Interface-CLI-Tool

Hi @soulless It's a bit tricky as you're attempting to do both a SUM and a MAX inside your case statements. You can try and rewrite it so that your conditions are inside your aggregate. This is a bit tricky because for your Fix Price is attempting to use MAX but your others are using SUM. To get around this you can try to…

Then I'd go the second option where you'd need to create a dataset with all of the possible SKU / Date combinations. A starting point as @MarkSnodgrass mentioned is the Date dataset from the Domo Dimensions connector, filter out any future dates to speed up processing, add a constant of 1 can call it 'Join Column'. Get a…

Hi @RobB Are you wanting 30 days prior to the current date or from the date of the row? You might be able to filter your data (using a formula tile and ETL2.0 with a case statement to check if it's less than 30 days ago - alternatively you can calculate 30 days ago from the current date using a date time and then filter…

Glad I could help! If you could make sure to mark it as an accepted answer so others can easily find this I'd appreciate it!

Glad I could help! If you could make sure to mark it as an accepted answer so others can easily find this I'd appreciate it!

No it should work in ETL1 or 2 using the Replace Text tile. You just need to make sure to put the regex in the search and $1 in the replace and make sure you click the gear in the search field and select Use RegEx

Hi @User_32265 You can use a beast mode to compare your date to the latest date and then filter on the result using a window function and a case statement. You can then use this and filter for Latest. If you don’t have window functions talk with your CSM as it’s a simple feature switch CASE WHEN `date` = MAX(MAX(`date`))…

Hi @hanmari This issue doesn’t necessarily relate to the connector but how MySQL handles database reads. Whenever you need to read from the database it will issue a lock to prevent the data from changing until it finishes reading all the data it needs. Are you using a database user which has write access as well? It might…

Hi @Fadem You can do this in a magic etl dataflow with a regular expression and a replace text tile. Regular Expression: ^CN=([^,]*).*$ You can also just copy and paste the following JSON code into your MagicETL dataflow which should handle things for you: {"contentType":"domo/dataflow-actions","data":[{"name":"Replace…

Try this: DATE_ADD(`Timecard_Pay_Date`, interval time_to_sec(`Time_Out`) second) Its converting your time string to the number of seconds and then adding that to your date since dates have an inherent time of midnight

Hi @Salmas Beast modes are evaluated on a row basis and typically don't know of other rows. So in your case it won't ever see a row with rank 1 if it's on the row of rank 2. When you subtract NULL from something the ending result is NULL which is why you have blank output. You'd need to use the LAG (prior) or LEAD (next)…

With Domo when you're using the date selector it determines which month you're currently in and selects days 1-28/29/30/31 (month depending). It sounds like your business definition of a month is different since you're expecting the current month to be August 29th-Oct 2nd. How do you know that August 29th is the first day…

Hi @tejusarora Have you tried it to just return a TRUE / FALSE statement instead of doing your CASE statement? member = 'John Doe' AND `date` >'1/1/2021'

Its likely possible with a beast mode and just filter the card based on when that beast mode is the current month. The question is how do you define the current month?

Hi @Fadem Talk with your CSM, they'd have the best insight into what Domo can offer you and your needs. You could also ask about the Beta program and getting involved with those.

What is the format of your Time_Out field?

The GoogleSheet connector wasn't written to include a batch id or batch last run. You can simulate it using a dataflow to add the current timestamp as a constant and then selecting the max batch ID +1 for your new batch ID and add it to the data you're importing. You'd need to use a recursive dataflow to append the new…

How are you combining your date and time fields? What format is your time field in?

Window functions and pivot tables can be tricky. Glad you got it figured out!