GrantSmith Coach

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…

Hi @user025699 Short Answer: You need to reformat your data so you have one record per month instead of a start + end record. Beast modes can't create new records (which is what you'd need to do if you want to count 50 for each of those months). You'd need to restructure your data with a dataflow and break out the monthly…

Hi @user027693 The Domo Java CLI (https://knowledge.domo.com/Administer/Other_Administrative_Tools/Command_Line_Interface_(CLI)_Tool) tool has the search-replace-bm command you can try and utilize to more programatically change beast mode definitions. > help search-replace-bmsearch-replace-bm: Perform a search and replace…

To confirm this do not select to graph by day but remove your date from your table chart and your summary number as well as the number in your chart table should be the same

Hi @user054934 Likely this is because your data is being partitioned by day in your graph but being calculated across your entire data set for your summary number. So if you had a unique ID for multiple days on your summary number it would be counted once under your distinct summary count but would appear in multiple days…

Hi @adrianiy Have you downloaded & configured the Domo Java CLI tool? https://knowledge.domo.com/Administer/Other_Administrative_Tools/Command_Line_Interface_(CLI)_Tool

Hi @user063446 The key functionality of Domo drill paths is to dig deeper into the data you had selected from the parent card. To do this Domo needs to filter your underlying dataset. If you're wanting to have the user go to a different card without filtering you could have the card on a dashboard and change the card…

Hi @user022825 Currently you can't exactly do conditional joins with Magic ETL. You'd need to create a single (or multiple) columns you can join on and then do your filtering / conditional join logic after the join has been done. Simply put there isn't an easy way of doing this type of join with Magic ETL. There are…

Hi @mhouston Unfortunately it appears that their API only supports pulling an individual file and not an entire directory. If you're wanting to programmatically pull all files in the directory you options would likely be either write a script to query all of the files in the folder then call the API individually for each…

Hi @user075511 I had too many issues going down the Google Sheets path with timing issues and the data not being updated in time when Domo would attempt to run the script or the Google Sheet population script would fail silently and I had no visibility into it until it was already too late and in the system duplicating…

Hi @JaredUJZ When you created the API secret and key were you logged into your account that you're wanting to pull data down to? Do you have the Data API enabled for that API project in google's platform? If you import the Data API -> Channels report into Domo are you getting the correct channel information you're…

Hi @user075511 With my interactions with the many different APIs Facebook has been... not great. They don't support service accounts and require a specific personal user to access their API. The only way I know to get around it would be to create a bogus personal account which appears to be a real person but is solely used…

Hi @user034162 It sounds like you want the rankings within each col1 subgroup if I'm reading your post correctly. You should be able to get rankings unique to each subgroup instead of the entire dataset by adding col1 to your PARTITION clause RANK() OVER (PARITION BY `col1`, `col2` ORDER BY SUM(`amount`))

Hi @user020987 Was your code copied directly from your beast mode or did you type it here manually? It appears you're using single-quotes for your field name instead of back ticks which when comparing the two strings (instead of the column value and a string) will never match so EAST is always returned. Try this: CASE…

Hi @user017486 I posted an answer to your question here: https://dojo.domo.com/t5/Beast-Mode-ETL-Dataflow/How-to-delete-rows-automatically-based-on-a-date-in-a-dataset/m-p/51468/highlight/true#M9105 

Hi @user017486 I posted an answer to your question here: https://dojo.domo.com/t5/Beast-Mode-ETL-Dataflow/How-to-delete-rows-automatically-based-on-a-date-in-a-dataset/m-p/51468/highlight/true#M9105 Next time you should only need to post your question in a single topic area as they're all well monitored.