-
Value 'XXX' does not exist for the field 'project' // Jira Field does not exist
Hi, I'm having problems getting my dataset to work with the Jira connectors. In the JQL query input, when I try to filter on project field (project='XXX') and run the dataset I get the error Domo is ready, but Jira failed to return the requested data with the following error: The value 'XXX' does not exist for the field…
-
What Generation of iPad will work with Domo Forms within the Domo App?
I need to know what gen of ipad is best for using the domo app as well as uploading picture files via Forms. TSM advised tagging Gary Gibb.
-
Add field to Conductor API connector
For the Conductor connector (Tracked Searches report), can you please pull in an additional field that is associated with each tracked Search: "Prime". This indicates if the keyword is a primary/prioritized keyword the business wants to focus on.
-
Grouping after Split Function
So I'm running into a bit of a snag. Say I wanted to just do the Beast Mode element and pull just what's in the Title(Column) for example: All this info is in the Title separated by a | if I wanted to pull the System name from the title and then group it along with others that come in with the same format but create a…
-
Group By Filter for Dashboards
Hi Folks, Is there a way to add a 'Weekly' 'Monthly', or 'Quarterly' filter to a dashboard that would aggregate best modes accordingly (when written dynamically) within charts by those groups against a date field? The equivalent of the graph by feature in the analyzer: I want someone to be able to select weekly and see an…
-
Brick with Ten Datasets Question
Hey all, In the template for the "Brick with Ten Datasets", is there more specific documentation on the queries used to pull summary info into the card? For example, the https://developer.domo.com/docs/dev-studio-guides/data-queries link is provided as documentation for the code snippet below but there isn't even a…
-
Show numbers in different format
Hi! I have a stacked bar chart whose formatting for values must follow a specific set of rules. If it is above 1 million (example 9,483,321), it will be displayed with 1 decimal place, scale-abbreviated (to 9.5M in the example). If it is below 1 million, it should be displayed with no decimal place, scale abbreviated (like…
-
Sum of units sold, rolling 30 days
Looking to replicate the exact data layout above (side by side columns) in a table in Domo. So units sold by SKU by month (got this far) but also a column for rolling L30 Days sum. I created a new column in the dataset for count of days from current for each row DATEDIFF(CURDATE(),(Calendar Date)) but having a challenge…
-
PDP Automation and Ignoring Case Sensitivity?
Hi All - I have been working on automating PDP for my company but have run into a bit of a snag. By default PDP is case sensitive and if I were manually creating policies using the Domo UI, it's easy enough to just tick the "Ignore case" checkbox. However, when generating policies in an automated fasion, it seems like the…
-
Can you pass variables into a CLI script file?
I want to be able to pass the token and domain for the connect command or the file name and dataset ID in the export-data command. It would make it more extensible rather than have a script file for absolutly everything. domoUtil.jar -script E:\DomoUtil\MyExport.script I know I can regenerate the file each time using…
-
Help with the SUM function, I get "An issue has occurred during processing"
I am going to try to explain myself better, what I am trying to do is identify how many times a person appears in a dataset, in my particular case I need to know the number of people who have created more than 100 contents when trying to run this function, this function tries to count the users that appear or have more…
-
Unanswered Questions Tab Almost to Zero!
Hello Domo Community! Let me just start by saying how amazing you all are. The response time in recent weeks has been ridiculously fast! It just goes to show how well-versed and supportive this community is. With that being said, I would love to issue a challenge! Take a gander at the Unanswered Questions tab. At the time…
-
Is there a way to hide link to dataset on a Card?
Is it possible to hide the link that takes users to the dataset that is powering the card? We only want them to see the data that is on the card and not the advanced details.
-
Scheduled Reports from Drill Layer
We have built several drill down reports for our business in order for them to see the aggregated metrics at each level. These work as intended, but our users want reports from the drill layers sent to them rather than the top layer where everything is just aggregated at the highest level. We would love to see an option…
-
Help with the SUM function, I get "An issue has occurred during processing"
An issue has occurred during processing. We are unable to complete the request at this time. when trying to run this function, this function tries to count the users that appear or have more than 100 records in the dataset SUM(CASE WHEN (COUNT(UserId) > 100) THEN 1 ELSE 0 END) I appreciate any help or opinion
-
Thousands Separator in Beast Mode
Hi Everyone, I'd love to add a thousands separator to the formulas below. I searched and tried the solutions out there for hours, but had no luck. I'd appreciate it if you could help me with this. CASE WHEN `Objective` like 'Awareness' AND `Campaign Name`like '%MOTHERS%' AND `Platform` like '%FB%' AND SUM(`impressions`) >…
-
Multiple Date Fields and Filters
I have one table with two date fields: date-1 and date-2. I would like to configure two filters such that filter-1 operates on date-1 and filter-2 operates on date-2. Is this possible? My experiments so far have yielded inconsistent results. I'm not sure how to control the mapping between dates and filters. Thanks!
-
Difference in Business Hours
I'm looking to get the difference in 'business' hours between two date/time fields. The business hour range is 9:00 - 17:00 (or 9am - 5pm), within weekdays. Additionally, If a user enters a Start Date after 17:00, the start date should get pushed to 9:00 of the next business day. For example, the following should have an…
-
Comparing 2 datasets
Hi there, I am new to DOMO and I am trying to find a way to combine two datasets with same column names. I would like to calculate the variance between current pay vs industry pay and be able to sort it by job title and location (DMA). I have tried ETL, Join and Segment for the baseline but none of these methods work for…
-
Display Values used to calculate Summary Value
Is there anyway to auto display the red text? I'd like to show the 2 values that are used to calculate the Summary Value without manual annotation.
-
Export metadata on connector datasets
We need to export metadata for all datasets that use certain connectors. Specifically, we have created a large number of datasets using postgresql and bigquery connectors. We need to export (1) the query used for each dataset, (2) the dataset id for each dataset, and (3) the name of each dataset. I know it is possible to…
-
Table Chart and data validation
I create my table chart with beast mode fomulae, everything looks good, but when validating the data with the numbers populating in the table chart it is not accurrate. the beast mode formula seems to be correct. Can you help or any idea of what could be wrong. Thanks!
-
Split Multi Value Column values into Separate Columns
Hi! I have a column with multiple values, separated by a comma. I am able to use the Split Column in Magic ETL and place the values into new columns. However, I need it to be added into a new column based on the value. For ex.: Fruit, Vegetables (Fruit would go in Fruit Column and Vegetables would go in Vegetable Column)…
-
Graphing multiple metrics in one chart by rank
Hi, I'm trying to create a chart that shows how different GA4 metrics show a different result for which site traffic source performs best. For example, per the screenshot below: Email has the highest avg events per session Direct has the highest share of total sessions. Or, Display has the highest avg engagement rate. That…
-
Key Word Search - Filter Card
Create the ability to do a Key Word Search across all columns used in a table card. Create a filter card for easy access. This is currently possible by creating a beast mode and concatenating all used columns and adding filter for this new field. However, it's not user friendly as the search results display the full…
-
Averaging time/returning only whole numbers of a fraction number
Is there a way in a beastmode to make the following example numbers on the left below remove the numbers after the decimal? 14.1925 — 14 15.999 —- 15 0.98 — 0 I am trying to get the average time of day that donors answer their phone when we call. So here below this donor answered his phone at these 3 times (hh:mm:ss):…
-
Using partitioning in ETL or Workbench
Good afternoon. Typically, to not do full replaces of data pulls into Domo from our databases, we have used recursive dataflows with ETL. I am trying to think of a way of accomplishing this using the partitioning features in ETL and/or workbench to avoid the ETL still having to process the whole set of updated+historical.…
-
Filters not working
I woke up this morning to a lot of emails about filters on multiple dashboards not working. I firgured out that the ones that weren't showing all the available options (broken) were filters that didn't have anything in the "Optional Group By" tab. Was there a new patch pushed out by DOMO that makes you put something in the…
-
Save / Export dataset containing the projections in Domo Analyzer Cards
Let's say we create a Domo Analyzer Card using "Multi-Period Projection" from the chart properties. It uses Linear Regression Recent Weighted and shows the projection in the UI. We need a dataset where all these projected datapoints will be saved.
-
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…