-
Color rules not working with bar + line chart
I have a bar + line chart where I am using partner_name dimension (blue) in the SERIES field along with another numerical metric (green) as shown below Despite applying color rules on the partner_name field in the card, I am not seeing the color change when I change the filter values for this field in the dashboard. But…
-
Add deleted events to the DomoStats Publish Event Logs dataset
Please add "deleted" events to the DomoStats Publish Event Logs dataset. Not including deleted events means the dataset can't be relied on to see the complete details of what was changed on subscriber instances.
-
Beast mode to find last working day
Trying to figure out a beast mode that will filter my data to the last working day. Business works Monday-Friday. Want to be able to set chart to yesterday so that for daily morning chart shows yesterday's data. On a Monday it would pull data from Friday instead of Sunday. If there is a better way to do this other than a…
-
Is there a reason why you cannot change the legend labels in a Period over Period chart type?
I'd love if there was a quick way you could change them like you can to the y-axis for example when you click the dropdown. I know there is a way in a normal bar + line chart to make a beast mode for the time period you want and add it to series to manually plot the bar and line against each other a year apart but I have…
-
Creating a group.
So I wanted to generate custom groups based on the first word being pulled from a data field. Example: System | Application | Client | Problem Say I wanted to pull whatever system app would be and generate a group for it to display on cards via beast mode. Also, would the same concept be possible if I combined two work…
-
SQL formula not working?
I have a series of tests that run to determine a pass or fail. All the formulas work but this one is giving me problems - CASE WHEN Critical/Major= 'Common' AND
No>= 2 AND Critical/Major= 'Major' AND No>= 1 THEN 'Fail' Any one know why this would not be returning a Fail?
-
Is anyone having issues with filters using selectors
I'm having some issues with filters using selectors?? of 60 options, only 2 are available
-
Add parse format directly in view
When creating a view and changing the type on a column. e.g. String ⇒ TimeStamp it would be handy if you could choose how to parse the String directly in the UI rather than creating a beastmode to do this. Perhaps somewhere on this part of the UI would be best.
-
Average Time between Orders
Stuck doing this in Magic ETL: Trying to calculate the average time between orders. For each record in the DataSet, add a field showing the number of days since the previous order for that customer. Customers have multiple orders so I can't use Max(date)
-
Run now feature on dashboard
When I open the dashboard, I always concern that if the data updated. Or when I just update the data and want to see the result immediately I always have to go to the data source and check the status. It's really inconvinience to me and my dashboard users because they do not even know where is the data source is. And if…
-
In the analyzer filter on all time minus the running period
I feel the date filters are missing an option. I can choose "previous" and then choose "last X period", but that includes the running period. So if I am showing quarters, I want to show all time data, except for the current quarter (or week or day or whatever the interval is set to). Of course, I can set it static, but I…
-
How can I set the workgroup for Athena using federated Dataset
Hello I should use federated dataset in order to execute queries to the database without taking data from the data source. In the JDBC connector there is a field to set de workgroup that will be used in the athena connection (dataset) but I can't use JDBC. On the other hand, there is no field for workgroup when configuring…
-
Campaigns App - Domo Markup Language in Distribution Lists
Hello, Are there escape characters in the domo markup language? I am using the markup language operand "Is in" to filter email attachment datasets based on the recipient in the Campaigns App. I run into problems when the data values I need to filter on include commas. For example… Recipient A's email attachment needs to…
-
Ability to edit/change legend labels in period over period charts
Being able to change the legend labels in a period over period chart tyoe would make a huge difference in my workflow day-to-day. Instead of having to write multiple beast modes and adding them to series just to have the ability to have a dfferent legend label show up is too much work for what it does. Allow the ability to…
-
Transferring work from on Domo environment to another
Until recently our organization has had a single Domo environment (that is, a single subdomain like xyz.domo.com). This was used for both internal and customer-facing reporting. Now we have a second one, zyx.domo.com. The environment xyz will now be used for customer-facing reporting, and zyx.domo.com will be for internal…
-
Converting Dataflows
Having a "Convert" button in dataflows would be great for switching from one dataflow to another. For example, a MySQL dataflow to a Magic ETL.
-
How to build filters with images or icons
A Domo user was recently having a hard time figuring out how to incorporate images and icons into her filters. Here are a couple of awesome videos that helped her solve her problem. Hopefully, this can help anyone who runs into a similar issue in the future!
-
Brand Kit Improvements
The Brand Kit seems to be a bit of a sledgehammer at the moment and doesn't offer very granular control over the elemnts in the UI; not just colors. For example, we would love the ability to control the logos that display within a Subscriber environment, so our clients that use them feel like they're in a familiar location…
-
Connector Version Identifier or Notification
It would be great to have the version of the connector displayed in the overview tab of a dataset to make sure it is always up to date or to have a notification when it needs to be updated.
-
Creating a rolling standard deviation within magic ETL
I'd like to create rolling standard deviation within Magic ETL that uses the previous 90 rows (or previous 90 days) as the window. I was able to do this within MySQL before, however, I'd like to do this within Magic ETL. For example if I have 100 rows of data each row should reference the previous 90 rows as the sample…
-
Is there a way to pull data from the body of an email
I have emails that are automatically sent to my inbox with data contained in the email (see screenshot below). Is there a way to scrub the body of the email and extract data from it and pull into Domo? For example, I'd like to pull the value corresponding to Portal User ID (Cookie) .
-
Need to extract all queries used in our SQL Server connectors.
We recently realized that someone in the past hard-coded database names — names which have since changed — in some of the SQL queries used in the SQL Server connectors. Unfortunately, we have hundreds of connectors, and opening up each of them manually to look for a problem will not be fun. To avoid doing that I want a way…
-
TikTok Ads Connector not returning Conversion or Conversion Values
We are currently pulling data from TikTok Ads and we are getting spend correctly but conversions and conversion values are coming in 0. Any insight in what is the correct column to pull from the API? Thank you so much!
-
Transforming Support Staff Name Column
Hello, ETL question. For context, I am creating a dashboard for self-service reports on customer satisfaction surveys. Typically I would create a drop down filter card to 'Filter by: Owner', but in this case the owner column contains multiple names: IE: Owner Joe Smith, Bob Smith Cate Smith Cindy Smith, Sam Smith Does…
-
DOMO GOVERNANCE PAGE OVERLAY
It would be really nice as an Admin to look at a page/dashboard and see some sort of overlay giving governance information. For example, look at a page/dashboard and see a color highlighted overlay showing the most used/least used card, or see a number pop up of who the users are that are viewing the card most recently.…
-
Variables - Dates - Min or Max Today
It'd be great to be able to set the min or max values for a date variable to today so that it restricts users to not select a future date or past date when required to allow dashboards to work correctly and protect against outlier dates.
-
NEW Domo Data Science Resources Guide (help w/ Jupyter, scripting tiles, data science tiles, AutoML)
Hi all, I'm a data scientist at Domo on the Data Science Professional Services Team. We have a NEW Domo Data Science Resources Guide. The guide includes a list of all the help resources Domo has created related to data science products (Jupyter Workspaces, Magic ETL R/Python scripting tiles, Magic ETL data science tiles, &…
-
Client Information Segmentation | Publication Groups | Dataset Copy Connector | Domo Publish
Use Case: Client access and Reporting through Domo Hi Domo Team, Through the exploration of the use of Publication Groups in Domo, we noticed that there are some features from an end-user perspective in the Publication Group that we had questions about. We ended up following this guidance - Our use case here is to provide…
-
Dashboard Sizing
Hi Guys, is there anyway of ensuring the dashboard will fit a cetain size of screen ( e.g. 1920×1080 ) even if im not personally using a screen of this size
-
Average Function in Summary not calculating as per card level aggregation
Here is a Scenario My Data is at Monthly Level so 1 value corresponds to each month. e.g. 01 Jan 2022 - 100 , 01 Feb 2022 - 200 , 01 Jan 2023 - 300 , 01 Feb 2023 - 400 Now in Card Summary I have selected Value column and Average Function When I select Graph by - Month Summary figures value comes up as 250 (1000/4) But when…