GrantSmith Coach

Hi @Khan_Naziya The hard part is for Domo to know if there should be data that needs to be updated or not. Domo can only ingest the data but doesn't know the intricacies of your source system to know if there should be records to update or not. You'd have to somehow pass that status via your query you're sending to Domo to…

Hi @user067324 Right now you can't filter other cards based on a different field than the one you selected. It would be a great feature enhancement but currently isn't possible based on how Domo is designed.

Hi @Khan_Naziya Workbench jobs are stored locally so if you delete the job it's gone and you can't restore it. You'd have to recreate the job. It's always a good idea to back up jobs before you delete them because of the lack of automated backups in workbench. You could even schedule a recurring job to run an export using…

Hi @user015090 It is indeed possible to tie a hyperlink to an image. Here's a simple beast mode which works for me: CONCAT('<A HREF="http://www.domo.com"><IMG src="', `Profile Picture URL`, '"></A>') Likely you have a syntax error with your beast mode. It looks like you have an extra quote before your target keyword. Try…

Hi @mmanuzzi Because of the nature of unique visitors and how platforms like Adobe or Google Analytics calculates it it does the deduplication and summarization before it sends you the data via the Domo connector based on the time slice you have selected. Because of this you can over count if you sliced based on days but…

Hi @Joe_M You can utilize a windowing function (if you don't have it enabled in your instance, talk to your CSM to get the feature switched on) within a beast mode. SUM(SUM(1)) OVER (ORDER BY `Date`) This is calculating the row number based on the `Date` field, if you need to calculate it based on another field change…

Hi @_Terel_Soares I haven't used Abobe Analytics but if it's like any other OAuth type authentication your client ID and client secret are typically found in the same place. Usually under the API configuration settings (again, not an Abobe Analytics user so I don't know specifics in this case). Here's the documentation…

Hi @GuitarMan2020 Summary numbers only support beast modes which are aggregates (MIN, MAX, SUM, AVG etc). You could wrap your CASE statement in either a MIN or MAX depending on the logic you require. If any record has 'Yes' and the end result should be 'Yes' then use MAX. If any record has 'No' and the end result should be…

@user031867 Yes - by default the number is 1 if the setting isn't specified.

Hi @user031867 The lines charted within the Grouped Bar with Line Chart is defined as part of the settings. You specify the number of series on the left scale by supplying a number under General > Series on Left Scale. It will take the first X number of series and plot them as lines. The rest will be plotted as bars.

Hi @SumanK I don't believe there's a way to customize the message sent in the scheduled report however you may want to talk with your CSM to determine if the Campaigns App add-on would be able to solve your problems (you can search for it in the Domo AppStore to see how it works as well) You may be able to add a text card…

Hi @user16346 Is it possible for your GA instance to contain transaction IDs which start with a character or should it be assumed that it's always going to be a number?

Hi @user032625 , Because of the flexibility of Domo it is difficult to direct you on how to solve your general question. It would be helpful if you had some sample (and anonymized) data to review and help direct you with the best solution. If your data is formatted as a single row containing the date when the content was…

Hi @user06643 If you set the rows to be collapsed in the Analyzer and then save save your card it will default to the rows being collapsed for users when they load the card.

Hi @user031517 A little more information about how your data is structured would help or some sample anonymized data would be great too. Without knowing how your data is structures it's difficult to pinpoint the problem. How is the data being populated? Is it being done via a join? What does a single row in your dataset…

Hi @tstimple , You can utilize the windowing function LAG to calculate the rolling average based on the number of days. Window functions are a feature switch so if you currently don't have access to them talk with your CSM about getting it turned on. Example 5 day rolling window: (LAG(COUNT(`one column`), 1) OVER (ORDER BY…

Hi @HashBrowns Unfortunately right now that's not possible to conditionally set the label text color. The code snippet you have only works on table cards which allow HTML markup. Bar Charts currently don't support it. I've been looking for this functionality for a while as well but they don't have it yet.

Hi @PhilD , Are the only two fields you have listed the location and your count distinct calculated field? If that's the case then your locations might appear the same but aren't actually the same (perhaps a trailing space). Can you try wrapping your location in a new beast mode to strip any trailing spaces?…

Hi @user021892 - Welcome to the Dojo! Your data sources and your use case will determine how you want to combine your datasets together. Lets say for simplicity sake you have two different datasets with the following data: Sales: DateSaleQuantity1/1/202050001002/1/202075001503/1/2020250050 Revenue:…

@Sandis You can use a Fusion to union the two tables together which would likely be more efficient than an ETL but it's up to you.

Hi @Sandis How are you pulling in your data? Are you pulling in the most recent records only or are you pulling in your entire dataset? You may want to look into utilizing UPSERT in Workbench 5 - https://knowledge.domo.com/Connect/Connecting_to_Data_Using_Workbench_5/Using_Upsert_in_Workbench_5 to only insert the records…

Hi @user007486 You're correct. The Join tile in Magic ETL only supports direct equality and doesn't handle BETWEEN type joins. What you could do is do your ID join and then utilize a filter tile to restrict the records after the join but might be a bit inefficient since it's reading all of those records and then doing a…

Hi @usergru How I've typically done this in the past is to have two separate datasets, live and historical. For the historical dataset I'd have it APPEND the data from 8 days ago every day. For the live dataset it would REPLACE the dataset with the data from the past 7 days. Then you can utilize a data fusion to stack /…

Hi @user11651 I haven't used the Salesforce connector but it's a data type issue. You might need to check to see if you can force the column type within the connector itself. If not you could modify it within your Magic ETL by using a Set Column Type to convert it to a string and then use String Operations to left pad your…

Hi @user084060 This is likely because of your numerator CASE statement where it only returns a value if sales=true. If you have a record where that condition isn't met NULL is returned and anytime NULL is divided by another number NULL is returned. Without seeing your data I'd recommend something like: select…

Hi @user022825 You can utilize the BINARY keyword to force MySql dataflow to do a case sensitive join. selecttable_1.*,table_2.*from table_1left join table_2 on BINARY table_1.manager_id = table_2.manager_id_2

Hi @hamza_123 I believe Domo has the ability you to utilize the NULLIF() function where it will return if a field meets a specific column. COALESCE(NULLIF(column_x, ''), NULLIF(column_y, ''), NULLIF(column_z, '')) If not you could wrap it in CASE statements. CASE WHEN `column_x` <> '' THEN `column_x`WHEN `column_y` <> ''…

Hi @user015090 If you're wanting the GA property to be open to other course builder apps I'd recommend using the instance URL. If you only want that property to be associated with that specific course builder app then use the app URL. I believe @Ashleigh has done something similar with Course Builder and Google Analytics.…

Hi @matthewstryker SQL doesn't handle reading different/variable column names in an SQL statement very well. What I would suggest is instead of storing the values in a wide format (columns as values) I'd recommend storing them as a narrow (also known as Tidy) format so you have two columns: Metric/Name and Value. Your…

Hi @gotex The blue text is because you make the text a hyperlink (<a href=...>). If you don't need it to be a hyperlink remove the anchor (<a> & </a>) tags from your text. If you need to have the hyperlink you'll need to add a style to the <a> tag: <a href="#" style="color: #bbe491"> Also make sure you're using an HTML…