BlueRooster Domo Employee

Yes, you'll need to get the token from within Okta. Here's a link explaining how to do so: https://developer.okta.com/docs/api/getting_started/getting_a_token Hope that helps, ValiantSpur

Unfortunately I'm pretty sure you can't. Here's a similar idea that I believe is already in the works: https://dojo.domo.com/t5/Ideas-Exchange/Report-Scheduler-Schedule-Export-of-Cards/idc-p/23440#M4508 Hopefully we'll see some movement around this soon, ValiantSpur

I don't think you'll find an outright on this one. But I'm pretty sure you're going to have a ton of scripting errors with the out-of-date browsers on a 98 machine. I doubt it was even ever tested on Windows 98 as extended support from Microsoft ended back in 2006.

The Overview is user specific. If you want to share some default cards, you'll need to add them to a page and then share that page with the default group. Each Overview, Alerts and Favorites are unique to the user and can't get be set by the admin. Let me know if you have any other questions, ValiantSpur

Basically I would use a SQL Transform to rebuild the base dataset SELECT *, 'Insert Variance BeastMode Here' AS 'Variance' FROM Dataset And you can SUM any of the fields you're summing ahead of time. But that should produce a dataset that is exactly what you would export from the finished card.

Definitely pretty tricky, took me a minute to figure out what was going on. So the data at the row level is exactly the same. The problem is that the Total and Sum fields, don't calculate our special rounding at the row level, it does it on the whole dataset. Example: If you had 3 rows where the decimal was .25, .28 and…

So it should be a bit easier than you may be expecting. First thing, on your date column, it looks like two different formats (from the 2 datasets) are being returned. You may want to do a STR_TO_DATE(`Dia`, '%d/%m/%Y') to make sure they are converted correctly When building your chart, the date will automatically be…

Here you go: `Current` - (FLOOR(`Needed`) + CASE WHEN MOD(`Needed`, 1) >= .25 THEN 1 ELSE 0 END ) FLOOR returns the whole number part of `Needed` MOD(`Needed`,1) returns the decimal part We then do a CASE WHEN to see if the decimal is >= .25, if so then return 1 and add it to the whole number of needed. Let me know if you…

So you'll need to use a SQL transform for your dataset. It would go something like this: SELECT `customers_id`, GROUP_CONCAT(`carrier_requested` SEPARATOR ', ') as 'carrier_requested' FROM data_source GROUP BY `customers_id` The MySQL GROUP_CONCAT function looks like what you'd want to use. Hope this helps, ValiantSpur…

Here you go. You can create a filter for 'Today' in GMT using the following: CASE WHEN Cast(`DateTime` as Date) = CAST(CONVERT_TZ(NOW(),'EST','GMT') AS DATE) THEN 1 ELSE 0 END And just set it to = 1 This will only return data where your `DateTime` field is the same day. You can use the same Convert_TZ function on your…

This is done automatically for you when using the Pareto chart type under the 'Vertical Bar' section Give that a go and let me know if that's not what you're looking for. Sincerely, ValiantSpur **Please mark "Accept as Solution" if this post solves your problem **Say "Thanks" by clicking the "heart" in the post that helped…

First, I agree with the way you've setup your Budget Limit BeastMode. I don't really think there's another option that works as well. For the second piece, unfortunately you'll have to break the amount up into separate categories and put those in the Series section. It would be nice if we could add a Dimension to the end…

I haven't seen that behavior before when editing or creating cards. Are you able to replicate the behavior or is it sporadic? That's definitely something I'd bring up to support if you haven't already. Sincerely, ValiantSpur

I'm a bit unclear on how you're using the fields. Is this a table chart type? The BeastMode I provided will replace the Sales Team field, you should still be using the same Sales Manager field. Any chance you could take a screenshot of how you have the fields setup in your card?

If I understand you correctly, you're needing to strip the non-numeric data from the field and the convert to a decimal. You can easily do this via the following ETL steps: First you'll want to add a 'Replace Text' option enter the following the Search term field: [^0-9.] And set the 'Use RegEx' check box for the Search as…

Drop the `Sales Team` = CASE WHEN `Sales Rep Supervisor` = 'John Smith' then 'Retail' ELSE `Sales Team` END

If you recreate the card from scratch, are you still unable to group? I've had to do that before to "re-enable" some of the default options that should be available.

Does your date dimension have the calendar icon next to the name? Or is it being seen as a Text field? You can also try creating a BeastMode using your date like this: CAST( `Date` AS Date`) Hope this helps, ValiantSpur **Please mark "Accept as Solution" if this post solves your problem **Say "Thanks" by clicking the…

 Hi, You'll need to reach out to support and have them enable DomoMetrics datasets in your instance. There are 2 datasets (Pages Viewed by Person and Cards Viewed by Person) that you could use to create tables listing the page/card name and their corresponding ID. Hope this helps, ValiantSpur **Please mark "Accept as…

Creating annotations is tied to Edit Cards permission. This is part of the Admin, Privileged and Editor roles. Hope that helps, ValiantSpur **Please mark "Accept as Solution" if this post solves your problem **Say "Thanks" by clicking the "heart" in the post that helped you.

So you would need to create a BeastMode to use for the drilldown. This would be your new date field in the drill down CASE WHEN `Status` = 'Closed' THEN `Completion Date` WHEN `Status` = 'Open' THEN `Due Date` END This way, regardless of what the user clicks, at the next level they see the appropriate date. Hope this…

You don't need to leading parenthesis (and it wasn't being closed). The following should work now. case when MONTH(`Created Date`)= '1' then 'Jan' when MONTH(`Created Date`)= '2' then 'Feb' when MONTH(`Created Date`)= '3' then 'Mar' when MONTH(`Created Date`)= '4' then 'Apr' when MONTH(`Created Date`)= '5' then 'May' when…

Here you go, something like this should work: CASE WHEN WEEK(`Date`) = WEEK(CURRENT_DATE()) AND YEAR(`Date`) = YEAR(CURRENT_DATE()) THEN 0 ELSE 1 END Set this as a filter and have it = 1. This will allow any date that does not fall on the same Week # and Year as the current date to be included in your data. Let me know if…

Just tested this on our end. I'm seeing that the Custom Maps that were prepopulated from Domo do show the data label, but any map I add, the data labels do not appear. Hope that helps, ValiantSpur **Please mark "Accept as Solution" if this post solves your problem **Say "Thanks" by clicking the "heart" in the post that…

Ok, so I think I understanding what you're wanting. I took the original sample you gave and built the following just using a 'Running Total Line' card type (no ETL needed) The only optional changes I made were to set the date range fitler to Graph by None I set the 'Number of Running Total Series' to 1 And then I added the…

Here's a post I had done explaining how we handle this: https://dojo.domo.com/t5/Card-Building/Re-Period-over-Period-using-stacked-bars/m-p/30479#M3655 Once you've got that, the basic variance calculation is (Current Year / Previous Year) - 1 Let me know if you have any questions, ValiantSpur **Please mark "Accept as…

In the ETL process, you can use 2 'Date Operations' widgets, one to return the Quarter of Date and the other Year of Date. I would then use the Combine Columns option to combine those values into one new column. From there you can do a 'Group By' on the new date from your Combine and sum the Profit amount. That should…

Unfortunately there's not a way to have hover text that isn't included in the chart. This is actually a current idea 'Under Review' on the Ideas Exchange. https://dojo.domo.com/t5/Ideas-Exchange/Multiple-Values-in-Hover-Over/idi-p/7023 If you haven't already, I would go ahead and upvote it. I think there are quite a few…

You could do something simple like divide the # of days by 30 to give you a month count. There other option is to use PERIOD_DIFF() to get the # of months difference. https://www.w3resource.com/mysql/date-and-time-functions/mysql-period_diff-function.php At least at first glance, it sounds like either option should be…

Could you provide a screenshot of the color rules you have setup for this card?