GrantSmith Coach

Hi @JustinB You could abstract the core calculations in a dataset view and then use that as a field in your beast mode. It's not ideal and abstracts the logic to multiple places. I've been requesting beast modes behave like actual variables for a while now instead of inserting the entire formula.

Depending on how you count your weeks you could also calculate the first day of the week or the last day of the week so that you have a continuous week and not have issues with the start / end of the year. This is assuming you'd count a week that started on 12/30/2020 as the last week in 2020 and would include 12/30/2020 -…

Hi @mhouston There isn't a way to tell the Domo connector to only bring is X% of the dataset. It's all or nothing currently. Depending on how technical you or your team is you may be able to utilize some of the internal Domo APIs to pull a subsection of this data and then upload it to your instance, however it's not really…

@Anna Yardley I've completed it as well.

Hi @faisalnjit Domo has a connector called Third Party Data Governance. There's a lot of helpful and useful information as they have datasets for the Cards, Pages, Datasets etc within Domo and how they interact with others. Here's a KB article outlining the connector:…

Hi @Jobur No, it's a separate connector. (Data -> Cloud App -> Search for webform)

Hi @Jobur You can utilize a Web Form if you want to give users the ability to edit a form like an Excel file which is included by default. There is also a premium feature to do inline editing which has an extra fee associated with it. Since it sounds like you're wanting to write back to the Hyperion system you might want…

@user048760 If you just want to display your date in a different format you can utilize the DATE_FORMAT function within a beast mode: DATE_FORMAT(`dt`, '%b %d, %Y') This way you have a single date column in your dataset and don't need to worry about maintaining both throughout your ETL process. See…

@user047019 How are you grouping your dates in analyzer? Are you showing it by day or none or by week?

Hi @sem There's a new beta available to allow filtering on aggregates. You should be able to utilize that with your beast mode. It is in Beta so you’d need to get signed up for the beta program. Start with taking to your CSM.

@user048760 What exactly are you wanting this date to represent? As you said you already have the batch last run date to show when that group of data was imported. Are you just wanting to reformat the date?

Hi @jrdunson You can schedule multiple reports from the same dashboard. When you go to schedule it it will keep any filters you have in place as well. You should be able to just select Schedule as Report from the Share menu (box with the arrow in the upper right)

Hi @user048760 You'd need to utilize a date tile or formula tile to assign the current timestamp in a Magic ETL DataFlow.

Hi @VarunMB You could try to utilize a beast mode to assign a specific sort order value and then sort your values based on that new beast mode.

Hi @colinr Currently cards don't have a supported API to view the data from a card.

Hi @danidiaz There isn't a public API that's supported to perform the creation of cards currently.

Hi @user000253 You'll need to define your custom sorting order as the bins are now being treated as strings and "30" comes after "280"' CASE WHEN CEILING(`number`) <= 10 THEN 1 WHEN CEILING(`number`) <= 20 THEN 2 WHEN CEILING(`number`) <= 30 THEN 3 WHEN CEILING(`number`) <= 40 THEN 4 WHEN CEILING(`number`) <= 50 THEN 5…

Hi @user000253 The histogram is fairly limited in the customization options. Currently you can't customize the number format for the bins. I'd recommend offering this as a product feedback (https://knowledge.domo.com/Welcome/Getting_Started/Submitting_Domo_Product_Feedback) You could use a bar chart and custom bin labels…

Hi @user000253 In beast modes you can use the ROUND function to round a number to a specified number of decimal places. ROUND(`number`, 0) In this case 4.1 would go to 4 and 4.6 -> 5 If you want 4.1 -> 5 then you can use the CEILING function instead which returns the next highest whole number. (For reference FLOOR is the…

Hi @JonavilCello Unfortunately Domo doesn't offer that level of granularity for their permissions structure. It's an all or nothing with page permissions, you can either edit pages or you can't.

@ravimohan911 I'd suggest reaching out to Domo Support since it sounds like an internal / backend issue.

Hi @user048760 What you're wanting to do is possible by utilizing a date offset dimension. Essentially you'll have records for each day for current, lat week, last month, 2 months ago, whatever you want to define your offset / period definitions. There's been several write ups about this specific topic on the Dojo before.…

Hey @moonmoth @Ashleigh is the resident course builder expert but I believe she stored CB stats and completions within Google Analytics and added tracking tags to the CB courses she built.

Hi @ravimohan911 Have you tried updating the embed type to Off (save) then back to Private (save)? Have you confirmed that URL is correct for that new page under Admin -> Domo Everywhere -> Dashboards?

Hi @WorldWarHulk I'd recommend you reformat you restructure your data to utilize a date offset dimension. You can have customizable offsets (in your case last quarter) for each of your dates so that you can easily do different period over period type analysis. I've written on this topic before:…

Hi @b_rad The Domo Period over Period charts have their shortcomings. You likely won't be able to format it in a tool tip because you don't have access to the last week value in your beast modeI typically use a date offset dimension table which allows me to define my own offsets like last week, last month, last year (day…

Hi @danidiaz It's not possible currently. You option is to duplicate (save a copy) the card on your dashboard and implement your different filters on the different versions of the cards and then schedule that report / dashboard to be emailed.

Hi @b_rad Are the CURRENT_PERIOD_DATE and PREVIOUS_PERIOD_DATE columns in your dataset? Do you have a sample screenshot of where you're entering this information? You might be able to utilize the DATE_FORMAT(`date_field` , '%m-%d') function to help format your dates.

Hi @user052846 You might be able to do this within a window function in a beast mode (filtering based on a case statement and the new aggregate filter beta - talk to your CSM to get it enabled). You can get the maximum average per day with the following beast mode (make sure you have date in your card or this won't work)…

Hi @mattAnonomatic I'd recommend getting in touch with Support for this type of issue. They'd be able to help diagnose your issue and if it's a problem with your account or not.