GrantSmith Coach

HI @user033690 For your specific beast mode it's failing because you're attempting to aggregate on top of an aggregate which isn't possible. When starting a problem like this it's good practice to start breaking these out into smaller chunks to validate the data as you're working through it. First thing you'll want to do…

Hi @user091749 You're essentially wanting to do a join to a table to lookup the project status. Beast modes can't do this as they're processing on a record by record basis. The easiest and best option in this case is to utilize an ETL to filter the names and status and then join it back to the table based on the dependent…

Hi @eriena Because of possible permission issues Domo doesn't automatically remove access to the cards. For example Card 1 is part of Page A and Page B. If Tom was shared Page A and Page B he has access to Card 1. If he's then removed from Page A but still has access to Page B he'd still need access to Card 1 which makes…

Another option (assuming it will be either a number or null) is to utilize COALESCE or IFNULL function: DATE_SUB(`Start Date`, interval COALESCE(`Days Ago`, 0) day)

Utilizing the key part of the Beast Mode for Fiscal Period: MONTH(DATE_ADD(`dt`-1, 7 - DAYOFWEEK(`dt`))) Here's verification for you utilizing the Domo Dimensions - Calendar dataset:

@user016095 - This shouldn't be an issue with the Beast Mode. It's getting the last day of the week and then calculating which month that date is a part of. In your example if we had December 30th it would calculate the date of Jan 2nd 20201. Then it gets the month of 1/2 returning 1.

My understanding was to filter based on the ID when selecting a client name because there's the possibility of duplicate names for different records. So selecting one column (name) and filtering based on a different column (ID) wasn't possible.

Hi @DomoNewb There's a few ways to do this depending on how you want to process your data. Using Magic ETL Replace Text tile: This is assuming the date is ALWAYS in the YYYY-MM-DD format following "EXPIRED " Here's a copyable version of the regular expression: ^.*EXPIRES (\d{4}-\d{2}-\d{2}).*$ Using a Beast Mode:…

Hi @user007486 You can utilize a beast mode to dynamically generate some text. If you're wanting to utilize this text as a summary number then you must use an aggregate function (sum, count etc). Beast modes without an aggregate function are not supported as summary numbers. Assuming you have a value and target columns the…

@user016095 `dt` is the name of the column that contains the date field. In your example you'd replace `dt` with CURDATE()-1 Resulting with: SUM(CASE WHEN `SALE_DATE` > CURDATE()-40 ANDMONTH(DATE_ADD(CURDATE()-1, 7 - DAYOFWEEK(CURDATE())))= `FISCAL_PERIOD` THEN `SALES` END)

Hi @user011045 I've done a previous write up regarding customized period over period data models. You can refer to https://dojo.domo.com/t5/Card-Building/show-percent-on-period-over-period-graph/m-p/50540/highlight/true#M7313 for an in dept description of what needs to happen. You'd join the table together against your…

Hi @user016095 It appears that your logic for fiscal period is determining the month of the last day in the week. You can replicate that logic fairly easily utilizing some date manipulation functions in a beast mode without worrying about the month. MONTH(DATE_ADD(`dt`, 7 - DAYOFWEEK(`dt`))) To break this down: 7 -…

Hi @mmakis I don't believe that's an option based on how the radar chart functions. You could attempt to default your null values to 0 so it goes to the center of the radar and then pops back up for the month you actually have data, otherwise you'd likely need to utilize a different chart.

Hi @Sandis I believe you can't manually disable it but you might be able to talk with your CSM to get them disabled.

Hi @M_Digital_S I haven't worked with DV360 before but I have worked with Google Ads (there wasn't a good connector for it at the time) and Google typically has really good API documentation and SDKs (https://developers.google.com/display-video/api/guides/getting-started/overview ) to pull the data. I ended up utilizing a…

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…