GrantSmith Coach

Hi @user003454 You'd need to format your data differently to get something like this to work such that a single column would have your categories for Region and Segment combines along with another column denoting the type of category label it is ('Region' or 'Segment'). You could pull only the Region data first and then…

Hi @user062862 Do you have a lot of DOMO.log statements or a large loop logging the same statement over and over? Have you tried commenting out some of those DOMO.log lines to see if that solves your problem? Essentially your error is stating your sending too many DOMO.log messages to the console output. 

Hi @user046467 Without seeing the actual error I'm somewhat guessing here but it appears you're missing your final END for your outer case statement. Depending on how you want your SUM to function currently it'll return NULL if your date is not between 1 and 15 days ago. If you want to count those as 0 then you'd need to…

Hi @user052846 You didn't clearly state what exactly your issue was with your beast mode so I'm somewhat guessing here but you're essentially wanting to use the most recent date between publish date and update date for the publish date if the publish date is null correct? If that's correct then you have two independent…

Hi @hamza_123 Are all of your Timezone values valid? Do you have any null / empty values? Do you have any null or empty timestamp values?

 Hi @Jessemauser Mine continues to function properly. Have you tried recreating a new governance dataset from scratch to see if it's still a problem?

Hi @swagner You can use a Rank & Window Tile. Using SUM on your number field with an unbounded for the first setting and 0 for the last setting. Order by your date field and now partitions will get you a rolling sum / running total.

Hi @user10540 This is simple enough with a window function in a beast mode. From looking at your spreadsheet you're essentially looking to see what % of the maximum number within your date range is. This is a great case for window functions. This is a feature switch so if you don't currently have it you'll need to talk to…

Hi @AWieczorkiewicz Have you looked at the schema tab on the script tile? Does it appear after you run a preview? https://knowledge.domo.com/Prepare/Magic_Transforms/ETL_DataFlows/ETL_Actions%3A_Scripting#Populating_The_Resulting_Schema

I’m on mobile and the dojo won’t let me edit my reply but the formula should look like this for prior CASE WHEN `Column B` = YEAR(CURRENT_DATE) - 1 THEN `Column A` END and this for current CASE WHEN `Column B` = YEAR(CURRENT_DATE) THEN `Column A` END

Hi @user052846 CASE statements are your friend in this case. Assuming you’re looking for data from the prior year you can use logic to conditionally set a new column value using a case statement in a beast mode. For your current Column: CASE WHEN `Column B` YEAR(CURRENT_DATE) THEN `Column A` END Previous Column CASE WHEN…

Hi @user037924 On your date filter card (while editing your dashboard) > Change Interation - do you have Standard interaction type selected with Enable interaction filters checked and the Apply to selected cards radio button selected and only the cards you want affected by the filter selected in the card list? How is your…

Hi @user037924 You can't dynamically change chart properties based on your data. If you'd want to do something like that you might be able to write a custom app to handle this specific scenario but based on how Domo works it's currently not possible.

Hi @user048980 Which SharePoint connector are you utilizing? There's several out there. What's the error message you're getting back from the connector?

You have a minor typo in your formula, it should be DAY not DAYS DATE_SUB(CURRENT_DATE, INTERVAL 1 DAY) You can also shorten it since it defaults to DAY intervals: DATE_SUB(CURRENT_DATE, 1)​

Hi @user052846 I understand now. You're simply doing a running total of the `Audience Interest Score` column. You can do this with a window function within a beast mode however you'd need to make sure you have windowing functions enabled in your instance. You can talk with your CSM to get them turned on. It's a simple…

Hi @user060355 Currently Domo doesn't export the exact equation for the regression line. You could utilize an online regression calculator to calculate it possibly.

Hi @user023026 Domo doesn't have a Power BI connector currently. You've got a few options: 1) Write your own custom connector (not sure if you'd have access to Power BI's API / https://docs.microsoft.com/en-us/rest/api/power-bi/ ) 2) Utilize the R or Python SDK to export the data from Power PI and upload to Domo 3) Have…

Hi @user32470 I've seen the DATEDIFF function not always work as intended some times so I utilize the UNIX_TIMESTAMP function to convert it to the number of seconds since 1970-01-01 and then do some simple math. ROUND(((UNIX_TIMESTAMP(`Form Complete Date`) - UNIX_TIMESTAMP(`Form Sent Date`)) / 60 / 60 / 24) - 0.5, 0)…

Hi @user046467 This isn't necessarily a Domo issue but rather a data model / structure issue. You're trying to combine two different datasets with different slices (one by product & day, one by just day). You'd need to restructure your data so they're speaking the same language (in your case have both be by product & day).…

Hi @Jessica It's to show or hide the date range and grouping you have configured for your card. For example where it says "By Month" or "By Day". It's the Date Picker widget in the Analyzer which this toggles the display of on the dashboard.

HI @user049141 Sharing with group C should still apply the Group A or Group B PDP policy to those users so you shouldn't need to share with Group A and Group B.

Hi @user084747 You wouldn't be able to bucket your dataset and then filter because you're still using an aggregate (MAX) to calculate the percentage of it. There isn't a production ready option except for to utilize either a DataView (beta) or Data Fusion to pre-aggregate your data into another dataset and then use that…

Minor tweak needed for the beast mode (just need to use > instead of >= - sorry!) SUM(CASE WHEN `Date` > DATE_SUB(CURRENT_DATE(), DAYOFWEEK(CURRENT_DATE()) + (13*7)) AND `Date` <= DATE_SUB(CURRENT_DATE(), DAYOFWEEK(CURRENT_DATE()) + (1*7))THEN `Revenue`ELSE 0END)

Hi @user32470 How is the returned value not correct? Is it too high? Too low? Looking at your query it appears that you're using the LAST_DAY function which returns the last day of the month and not the last day of the week. Try something like this: CASE WHEN `dt` >= DATE_SUB(CURRENT_DATE(), DAYOFWEEK(CURRENT_DATE()) +…

Hi @user052846 I'm a little confused by your request as the only whole number you have is the number of users. Looking at your two examples you have a decimal representation of a percentage (Domo) compared to your excel document (whole # representation). In cards you can tell Domo to display as a percentage (and tell it to…

Hi @user02319 There isn't a specific card that would get you exactly what you're looking for however you could utilize text cards (or just the card's summary numbers) and a dashboard page (you can convert an existing page to a dashboard by selecting the wrench in the upper right and selecting Convert to Dashboard) to…

Hi @Hulachic5 Are you utilizing Magic ETL 1.0 or 2.0? A typical reason I've seen is that there's a difference in how Magic 2.0 compares NULL values to Magic 1.0. Because of this if you're following the old instructions for Magic 1.0 on a Magic 2.0 DataFlow it can cause you to lose your historical dataset. You need to make…

Hi @user023661 Have you looked into utilizing a Fiscal Calendar? https://knowledge.domo.com/Visualize/Adding_Cards_to_Domo/KPI_Cards/KPI_Card_Building_Part_2%3A_The_Analyzer/Using_A_Fiscal_Calendar

Hi @Crisocir It does appear that there isn't an option to change the abbreviation formatting of the value in the Calendar. The knowledge base article appears to show something that isn't possible. You could put your value in the Event Name and leave the value blank which would display your values however you'd lose the…