GrantSmith Coach

Hi @Crisocir If you're populating a second column with the last date is this column NULL for records where it's not the last date? If that's the case can you graph a count of this second column and not a count of the original column?

Hi @jpjetlinx Last I've heard it's on the road map to get addressed but there isn't a scheduled date at this time. It might possibly be on the road map for sometime next year but I don't know for certain. I'd love to see the upgrade as well for that exact regex & json reason as well. Perhaps someone from Domo can give more…

Hi @user091749 You'd need to use a MagicETL 2.0 data flow to join the data to itself. Take the input and put it to a Select Columns and select the Project Name and Status Columns and then join it back to your original data set based on original dataset dependent project = the select columns project name, resolve the…

Gee thanks @MarkSnodgrass ? @AbelMM - The issue resides with your windowing function. Domo is close but isn't exactly the same as SQL windowing functions. Because you're adding an aggregate function (COUNT distinct) it's expecting your other columns in a group by statement under the hood. To make a long story short you…

Hi @user033690 You might be able to solve your problem using a windowing function however I'd recommend restructuring your data. I've done a previous write up regarding customized period over period data models. You can refer…

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.