-
Changing a column used in multiple beast modes to another column
I have around 10 beast modes that that are based on a certain column 'A' in their calculations but I need to change all of them to use a different column 'B' in the calculation. Is there a way to change this instead of manually editing all the column formulas?
-
New application for enhanced data Viz
I wanted to inquire if there is any new application in the recent release that could enhance data viz or any other application that I should consider using to make any reports more meaningful for the client. Your insights on this matter would be greatly appreciated.
-
Missing data points
Hi I am pulling data into card but some months that had no activity are missing and so the running total is not pulled in for that particular month. How do I ensure that the all months are populated including zero values
-
HTML Easy Brick Refreshes Unexpectedly on Interaction
HTML Easy Brick Refreshes Unexpectedly when Function to Reveal/Hide Text is Executed from Area Link We're working on developing a custom landing page where team members can click a section of our logo to reveal additional links related to that category of dashboard. In the HTML Easy Brick I was able to create area links so…
-
Color Rules on Domo Table
Hi, wondering if I can add a color rule on a Domo pivot table card. The idea is to be able to visually see how a certain row/KPI is performing by seeing the colors (see screenshot for example). I need a table format though, so it would have to be in a pivot table or mega table I think. Please let me know if this is…
-
Question on acceptance rate calc
Hello, I am trying to calculate total accpetance rate of the students. I have 2 calculated fields Accepted Students: case when (acceptance_flag = 1) then count(students) Total Students: count(students) I am having a table format and calculation for acceptance rate: (case when (acceptance_flag = 1) then count(students)…
-
How to disable SQL Editor on a View once it's been enabled?
I enabled the new SQL Editor on one of my views this morning to troubleshoot an issue: it's a wonderful tool, and helped me solve a very bizarre problem. Unfortunately, the editor takes up a lot of screen real estate, so I would like to disable it and return to the normal form of the view now that it's no longer needed.…
-
Best way to get multiple data types in a visualization?
Hey, I have total sales (in the millions), avg. selling price (max $20/unit) , and then a % metric. I want to have them all together in a time series chart to show trends. I can't figure this out for the life of me because I can't get them all appropriately graphed without taking one off the graph completely to see. Make…
-
Bar Charts: Map the color aesthetic to a different data point
Suppose a bar chart, X: Product and Y: Sales. I'd like to map a new data column, Profit %, as the gradient color of the bar for Sales.
-
Table with bars
Hello, is there a away to build this kind of chart in DOMO? the higher value the bigger bar size.
-
Getting name of columns used in card
Is there a way to get the names of the columns used on a card? I don't mean the columns for the dataset that powers the card - I mean only the columns actually used on the card. I've loaded several Domo Governance datasets from Domo Stats but I don't see any way to get this. I'm trying to make a report that shows when the…
-
What is the best way to find access to all the APIs that are made available by Domo ?
Hi , I need to get an idea of the capability of what can be setup via the APIs made public by Domo but I do not wanted to be restricted only to the functionalities provided by SDK versions currently such as PyDomo - I have been trying to check if there is a way I can look at documentation on how APIs such as creating cards…
-
How to retrieve e-mail campaign information via API
Hey all, I have been trying to get information about e-mail campaigns running on my organization's Domo instance. I have been able to find the information needed through a GET request at the following endpoint: https://campaigns-prod.domolabs.io/api/v1/email/campaigns/ However, I struggle to authenticate correctly. I tried…
-
Date on a CSV as text to convert to a useable fate format
Hello I have been given some data to process daily, it has a date column but its formatted as Text, and has a short month, for example it looks like: 01 Jan Data in DOMO looks like: There is another column that has the full month name and the year (as a month summary) so i have trued to split out the Short and Date Summary…
-
Zapier Integration
Would love the ability to have the ability to run API integration through Zapier to simplify the process!
-
Indicate in the UI when a dataset ID is being used in an API or writeback EXPORT
Simple idea with a profound impact. Indicate in the datacenter/dataset UI that a specific dataset is being used in an API or writeback EXPORT
-
Google Analytics 4 - Report for Exits
It would be great if the Google Analytics 4 Connector had the option of pulling in "Exits". This metric is available to pull in Google Analytics Explorations, but not in the DOMO connector.
-
UK map - google maps
Hi, I have a UK map which uses lat/long for the dots. I'm looking to use streetviews as that is our main way of identifying good sites remotely. Not all sites have streetview URL's so I can't rely on this. I was wondering if there is a google maps overlay or DDXBricks that can help me here?
-
No Idea why I can't get string to datetime
Input into formula tool is 2019-01-02 07:30:00 AM, formula is STR_TO_DATE(TimeIn1,'%Y-%m-%d %h:%i:%S %p'). Validate formula checks out, but error is Failed to parse date/time: Error at or near character 11 in string /2019-01-15 7:30:00 AM
-
Top 100 Values
In my data i have a 'client','quarter' and a Beast mode 'Score'. I have created a bar chart with quarter on x axis and Score on y axis. I have to create a card which shows scores for only top 100 clients quarter wise. How i can do that. I am not able to find a way at the moment. If we can do that in Beast modes it will be…
-
How would I filter for Order Numbers that contain UN codes? While keeping all other part numbers
Hi all, I am trying to figure out how to do this in Analyzer via Beastmode or filter tool. I am trying to only filter/display Orders that contain a product with a UN battery code while still displaying all other items in that Order Number. I'm having a tough time finding a function that could do this. Any ideas? Thanks in…
-
How to find all Flows(MySQL) that contain a specific string
Hello, I need to find all MySQL flows that have a specific string somewhere in any of the transforms or final outputs(these are all My SQL scripts). There is a data governance dataset for Beast Modes and you can use that to find all BMs that have a string but for dataflows, although there is a governance dataflows dataset,…
-
Filtering Out Letter Values, Leaving Numeric Values
I have a field with letter and numeric values (ex. "John Doe" vs. "12345"). My goal is to filter to leave the numeric values and change the column type to Integer. Does anyone have any ideas on how to do this in ETL? Trying to think of a Case when statement & filter option.
-
ShareASale API Connector
Hello, Has anyone connected with ShareASale using DOMOs API connectors. I have tried the JSON connectors and I'm not having luck. Link below. https://help.shareasale.com/hc/en-us/articles/12442753460375-Merchant-API-Building-Blocks
-
Getting "Domo is ready, but the requested file does not exist." for Excel file
-
API Partitioning
Hi all, so I want to use the Domo API's to do partitioning. That is, I want to send data daily, and I do not want the data there to be overwritten. I am trying this but I think it is being overwritten: https://api.domo.com/v1/datasets/{dataset_id}/data?updateMethod=PARTITION Is this the correct way to upload via partition?…
-
Identify if value exists in field to then classify data
Hey community. I've got a data set that is not optimal for what I'm trying to do. My optimal data set is sitting in a backlog and I'm looking to get some preliminary answers while i wait - so frankly, looking for a hack. I have a data set that has all of the participants associated with all of the events that we track. So…
-
Route map
Hi, Is there a way to have a route map create a triangle? The idea is to have 3 variables with different locations and to mix and match them and for them to create a triangle, however, I only see where you can put long and lat for 2 locations and not three. Is there a way to have three locations?
-
Considerations for migrating Salesforce to a new org
Our company uses the Salesforce connector and we bring Salesforce data into Domo with over 200 reports, flows and cards using this data. Our company was acquired and we are being asked to evaluate migrating into the parent company's Salesforce org. The Domo dependencies are one of our bigger concerns. We have a consultant…
-
Alert Options
Is there a way to set up alerts to notify me if The alert has not fired in 72 hours The alert has errors and is therefore not firing Right now, it appears the only email notifications I can set up are how often the alert is triggered. I would also like to be alerted when I need to fix something. I know that I can set an…