GrantSmith Coach

Hi @PandianS , Are you unable to use the new Lineage tab on the dataset? That'll show you the upstream and downstream datasets that are impacted without having to utilize the Domo Governance Dataset connector.

Hi @user11590 , You have three options. MagicETL, MySQL ETL or calculate in your query that pulls the data into domo. Beast mode won't allow you to show that calculated field on another dataflow (it will appear on another card if you select "Share Calculation on DataSet" when creating the beast mode) Magic ETL isn't very…

It might not be exactly what you want to do but MySQL DataFlows support the UPPER function you could perform your ETL work in MySQL instead of Magic ETL. Alternatively you have the MySQL Dataflow just do the upper conversion and then use that MySQL dataflow as your input into your current Magic ETL. You'd think they'd have…

@user045760 You can actually use a windowed function beast mode assuming your have unique identifiers in each row. This example is using the Date Dimension but you could change `Date` to your key field(s) SUM(SUM(1)) OVER(ORDER BY `Date`) You may need to have your CSM enable windowing functions as I believe it's still in…

Hi @user019875 You can explicitly state which cards interact with others via their filters. It'd be better if we could just state don't affect this card with filters but we have to do the inverse and define which other cards are affected by the filter for each card on your dashboard. Essentially you'd have to edit each…

@user067938 What type of file are you attempting to retrieve? If it's a CSV and the repository is public you could use the CSV Advanced connected and just put in the URL to the file from github. It might also work if it's a private repository if you supply the username / password or key when configuring the account (you…

I was incorrect and was thinking of sharing datasets rather than dataflows. Right now you can't share data flows (but I did post an idea exchange for just that: https://dojo.domo.com/t5/Ideas-Exchange/Share-DataFlow-like-sharing-DataSet/idi-p/47867). Essentially you'd need to give the user "Manage Dataflows" permissions to…

@user14700 You'll need to have admin priveleges to do this or work with your instance's Domo Admin to set this up. You'd need to either give all Privileged users the "Edit Dataflow" permission for that specific role (More > Admin > Roles) or create a new role for this specific user which has the "Edit Dataflow" permission…

@jaeW_at_Onyx I recommended this method in case there were any advertisers which didn't have any revenue in 2019 or 2020 whereas the LEFT + RIGHT JOIN union method would only include advertisers which had revenue in 2019 or 2020. Your method is preferred if we're only looking for advertisers with revenue but from what I…

@user02319 Correct, you'd need to read the data into a dataframe but you're essentially doing that right now anyway with your dataset pull - it's pulling all of the data into the file object you'd just need to convert it to a dataframe. I don't see a way to filter the dataset using the Python SDK currently. It's just…

@user095063 A quick version would be SELECT a.`Week`, a.`Advertiser`, a.`2019 Revenue` b.`2020 Revenue` from `2019` as a left join `2020` as b on a.`Week` = b.`Week` and a.`Advertiser` = b.`Advertiser` This requires an advertiser to have appeared in 2019 first to be displayed in your final table. If you want to make sure…

@hamza_123 How are your data label settings defined? Did you change it to reference %TOOLTIP1 instead of leaving it blank? What do you mean by empty thread?

Hi @user02319 A highly popular python package for analytics and processing data is called pandas. It allows you to read CSV files (and other sources) into a DataFrame (essentially a data table) with columns and rows. This allows you to then filter specific rows or columns based on specific criteria and then export the data…

Hi @user02319 A highly popular python package for analytics and processing data is called pandas (https://pandas.pydata.org). It allows you to read CSV files (and other sources) into a DataFrame (essentially a data table) with columns and rows. This allows you to then filter specific rows or columns based on specific…

Hi @user02319 A highly popular python package for analytics and processing data is called pandas (https://pandas.pydata.org). It allows you to read CSV files (and other sources) into a DataFrame (essentially a data table) with columns and rows. This allows you to then filter specific rows or columns based on specific…

Hi @Neeti What type of data set are you working with and how are you importing it into Domo? Are you utilizing Workbench or a specific data connector? In workbench there's a notification tab when you configure your data set which allows you to select the user to send an e-mail on success or on failure.

@user19085 Can you combine the new dataflow into the old dataflow and utilize the old dataflow's output dataset? If you need to keep track of the existing dataflow data you could create a new output dataset and rename it as the old one (even though it'd be treated differently)

@user19085 - Are you wanting to have the new dataflow point to the existing dataset as the output and overwrite the existing dataset or are you wanting to use the existing dataset as an input to your new dataflow? If you're looking to overwrite the existing dataset I don't think that's an option with MagicETL or MySQL ETL…

@WizardOz - I don't think it's been released yet. You can see all of the currently released features at https://www.domo.com/product/new-features#/. You might want to reach out to your CSM to see if they have any more information on when this feature might be released.

Hi @hamza_123 You could create a new beastmode to return an empty string if the value is 0 otherwise return the value CASE WHEN `value` = 0 THEN '' ELSE `value` END Put this calculated field into the Tooltip 1 field and then set the data value label to be Tooltip 1 instead.

So if it exists in B use B otherwise use A?

@imelendez I'm a little perplexed by your data. Does your historical dataset have data in the future as well? Are you attempting to get data from set A which is within the bounds of the dates found in dataset B?

@imelendez If you're not looking to keep the historical dataset updated then what you're stating should work. You'll have the two input datasets (A and B) and then tie them together with an append dataset tile which then outputs to an Output Dataset tile for your Magic ETL dataflow.

Of course I overthink the whole thing. @MarkSnodgrass has a much cleaner solution.

@swagner I suppose technically you could do a really long case statement based on each letter in the alphabet. case when `Description` like '%a%' OR `Description` like '%b%' OR `Description` like '%c%' OR `Description` like '%d%' OR `Description` like '%e%' OR `Description` like '%f%' OR `Description` like '%g%' OR…

@swagner I don't think this is doable with a regular expression in a Beast Mode however you can utilize a Magic ETL data flow with a replace text tile and a regex to remove any non-lowercase characters and then check if the value is NULL or not to determine if it doesn't or does have lowercase characters in it. Another…

Hi @imelendez Will the historical dataset increase in size or is it static? (Will it pull in 3 weeks + 1 day ago or be stuck at the end date where you first pulled the historical data?) What is your lookback_date? Is that going to be the current date or are you allowing the user to filter based on that date? If it's based…

Hi @user05966 Have you created the dataset previously with the Domo Python API? What I've had to do in the past is not pass in a dataset ID to allow Domo to create the dataset initially then the second time I run the script I make sure that I utilize that dataset ID that Domo had created. There was also a nice Domopalooza…

@nbrx I've had to utilize a Python script interacting with the Google Ads API to pull the data and then upload it to Domo using Domo's API. Not the best solution but it did what I needed it to do.

Hi @SEC , I haven't had this issue before but could you possibly post some anonymized sample data which allows us to replicate your issues?