GrantSmith Coach

Hi @user17569 There isn't a chart available to allow you to dynamically switch between competitors displayed (and others absorbed into the Other group) over time. The closest you could get would be a 100% area or stacked bar chart but it wouldn't be able to group competitors into an "Other" group if they're not in the top…

I don't but I'm sure the CSM can help translate the request to the beta feature.

No because the filter happens before the data is displayed so it's not there to show the totals since your card doesn't know about those rows.

Hi @user060355 You're getting NULL values because of your denominator case statement. SQL returns NULL if your denominator is NULL. You don't have an ELSE clause on your CASE statement so it's returning null because there isn't an add sale record. You can default your null values to 0 in your case statement and bring out…

Hi @user033119 I haven't used programmatic filters extensively and haven't run into your specific issue but have you tried translating the BETWEEN to be >= and <= clauses to see if that's an issue? For example: `date` BETWEEN `date1` AND `date` becomes `date` >= `date1` AND `date` <= `date2`

Hi @user031517 When you filter your data you're telling Domo to ignore your other data rows so when it goes to plot your single filtered rows and has no context of your other rows / totals so you only have a single value which is your total value as well. Instead of filtering you can still plot the data and keep the…

If you're using a specific date field instead of the current date you could format it with the same structure like: CASE WHEN `Year` * 100 + `Month #`<=`Year For Today` * 100 + `Month # For Today`THEN `Gross Revenue`ELSE 0END

Hi @user033690 You can utilize some built in functions to get the current date and do some addition / subtractions. CURRENT_DATE() will get you the current date MONTH() and YEAR() returns the month and year of the date respectively. We can do some math trickery to make the YEAR and MONTH a digit and compare the two values…

Hi @AbelMM From what I can tell your configuration should work. Have you tried graphing it as a table and validating that the beast mode is returning the correct data? I'm also wondering if it's a Domo limitation because it's a windowing function you're attempting to plot as a series but it's treating it as a separate…

Hi @user049190 Yes there is a limitation to the number of columns supported when importing AirTable data. I think it was around 500 columns. You also need to be careful of nested cells as it will expand every possible value to a new column in attempt to flatten the data which will cause your number of columns to expand…

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…