GrantSmith Coach

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…

@user017486 How are you uploading the data to Domo? What connector are you using? You should be able to encapsulate the value containing a comma with double quotes to treat it as a single value: Column 1, Column 2, Column 3 one, two, "three, four"

Can you filter that value out via the card filters?

@hamza_123 Which column are you attempting to hide? If you want to Hide a column in the flex table you can do this under General settings by selecting Empty from the drop down for the Column #. You can't utilize a beast mode to do this because the beast mode will look at each row individually. You'd need to calculate the…

@WizardOz This is a very common question. The limitation of beast modes is that it can only look at a single row at a time so you can't do a cumulative sum like you'd need in this case via a beast mode. You can however utilize a MySQL ETL data flow to get the information you'd need. The following is untested back of napkin…

I think that is a limitation of the API / connector. You could utilize an ETL or card filter to ignore the records based on the date or the 0 values.