GrantSmith Coach

@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?

@mamedu I've typically just had two separate fields as part of my dataset. One which has the HTML code to make the link clickable and another with just the URL like @MarkSnodgrass suggested. You do have some data duplication but it gives the interactivity of a link within the page but then also allows the users to have…

Hi @user037924 Have you looked at the Chart Properties > Colors? This will allow you to assign specific colors to values you choose. You can also change the opacity of the colors if that's more of the look you're going for.

Hi @jamesdII, Have you tried just comparing the dates themselves? CASE WHEN current_date <= `Target Date` then 'Future' else 'Historical' END This treats a target date of today as in the future. (simply change <= to < to exclude today from the future group. The other issue with your current logic is that both conditions…

@user06209 I'm not certain why you can't do a period over period graph based on hours, seems like you should be able to. One way you can get around it is if you create a MySQL ETL to join the table to itself based on the time being 48 hours before and labeling those oclumns with a suffix ('_48ago' for example). This is…

@user06643 - You can utilize windowing functions within a beast mode calculation. For example: sum(`visits`) over(partition by `channel`, `store` order by `date`) MySQL has supported windowing functions since version 8.0 so this should work in MySQL as well if you're at or above that version. If not then you'd need to…

@user02162 If you want the users to be able to add PDP policies to the data sets or data flows then they need permission to edit those. You'll either need to manage that for them as well or give them permission to edit the data flow / sets.

@cjack-PML - Have you tried plotting the seconds value as a number (total seconds - 65, 58, 12, 38, 22) rather than the string formatted version (00:01:05, 00:00:58, 00:00:12, 00:00:38, 00:00:22) of your seconds? You could then utilize your formatted string as a tooltip and then change the hover text or display text to…

The issue was with the way Google redid their authentication. The general YouTube connector still doesn't work but I was able to get the connections utilizing the YouTube Enterprise Advanced however there were a few caveats. Since I was utilizing a brand page instead of the actual google account to get information tied to…

@rgbuckley Because how the 100% stacked bar works and expects a single column for a series it's not quite possible. However! You can hack around it with a normal stacked bar and then plot the percentages. You'll need to make distinct beast modes for each type of Pay Cat Name using the same formula you posted earlier, just…

@Cartergan - You'll likely need to do a full outer join of the dates table and a distinct list of your agents to get the possible combinations of agent and dates. You can do this as a transform and then select that table and left join it to your qualtrics_responses table on agent and date. This should populate all possible…