GrantSmith Coach

@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.

Awesome! Glad to hear it @user028768 If you could mark my answer as accepted for others to make it easier to find I'd appreciate it. Thanks!

Hi @user028768 Try wrapping your values in double quotes: CONCAT('<a href="', `Link to Additional Info`, '" target="_blank">Click to see additional info</a>') Also, what type of card are you using? Hyperlinks will only work in table cards.

Also, by utilizing a window function in a beast mode it'll properly handle any filtering done to the cards instead of doing it within an ETL.

Hi @ravimohan911 CC @MarkSnodgrass So technically you could hack it a little bit to sum all of your values together while ignoring but it gets a bit wonky as the Total row is manually calculated and would need to be a separate row in your dataset. If the user does any sorting the Total row wouldn't be at the bottom…

@jaeW_at_Onyx @banderson FYI There's a limit of 1024 characters for columns in your datasets. The text in one of my data columns is getting truncated Domo has a 1024-character limit. Any additional characters after this will be truncated. You can get around this by splitting the text between two columns to make sure it…

Hi @User_32236 500 (see https://developer.mozilla.org/en-US/docs/Web/HTTP/Status/500) simply means an internal server error (essentially Domo had an issue processing your API request). It's an HTTP response code. Typically when I've seen 500 error in the past it's because of malformed data being sent to the API call. Have…

The version of MySQL that Domo uses (5.6) doesn't support quite a few nice features like regular expressions so you'd need to resort to something like the LIKE command as the simplest option to see if a substring exists in your field.

Hi @user077529 You can use a CASE statement to conditionally count values in a beast mode. You're close but yours is only counting everything if isRegistered is true. You want something like this: Registered count COUNT(CASE WHEN `isRegistered` = 'True' THEN `OrderNo` END) Non-Registered. COUNT(CASE WHEN `isRegistered` =…

Hi @banderson Are the items you're checking against this list the same values all the time or would they vary depending on another dataset?

Hi @user10926 What you can do is make a copy of your column into a new column and then do the replace on your new column to do the substring.