-
Group multiple dates
Gurus, I have the below data set: Ticket #Date CreatedDate SolvedTicket TypeOpen / Close Flag11/26/2017 P1Open21/16/20171/21/2017P1Close312/27/2016 P2Open412/22/20161/1/2017P2Close512/19/201612/22/2016P1Close611/19/201612/22/2016P3Close711/18/201612/2/2016P3Close And I am looking for attached chart( i just created a sample…
-
How do I create zeros for null values in line chart?
I'm importing a SQL query that data and have included a batch date transform at the workbench level. I've joined the SQL query to the Calendar dataset so that dates are created for any weeks missing data which I was hoping would give me a 0 line on my chart for those days, but its not working. I've done this successfully…
-
sum 2 fields in separate rows
Hello, I have a field 'miles' where for a loaded movement the miles is one value and for an unloaded movement the miles is another value. I need to sum these two together to get the total miles, but both rows of data need to show?
-
Beastmode calculation based on filter value selected
Hi All, I have a quick question, can we create a beastmode calculation based on inputs recived through added filter on cards. Exapample : Dataset has List of Items with Added Date and Expired Date. Filters will have Q1,Q2,Q3,Q4. So if i select Q1 beastmode should calculate Expired Item/Average(List of Item Day1 of Qtr,…
-
More than 500 records via the LinkedIn connector?
I am looking to use the LinkedIn connector to pull the Company Update Post Statistics report for a single date, but as there are more than 500 posts for this account i can never get all the posts as I receive this message: "Domo is ready but the LinkedIn connector responded with an error - Your daily User API call limit…
-
Time selection options in drilled down chart
Hi, I have a drilled down card which displays data using month in the X Axis. If the user would want to view the data at a quarterly level, it would be possible using this option (in a non drilled down card): But the same time selection option is not visible in the drilled down card even though I have disabled the 'Hide…
-
Workbench Data Loading Error : Data Source owner
We got this error when trying to run an automatic data load through workbench on a local server. The upload worked fine when executing manually. Has anyone run into this issue and knows diagnostic steps we could take to fix? Thanks!
-
Course Builder Google Analytics Tracking ID
I used this knoweldge base article as a reference: https://knowledge.domo.com?cid=gatracking So i attached the tracking ID to the course builder app and deployed it to my domo instance. Then I created a new card from the asset but I cannot get google analytics to track it. Just wondering if there is anything obvious im…
-
Custom App 'Add Card' Disabled?
Hey guys,I am attempting to create a custom card using the Domo Development Studio. I have properly logged in and launched the app using Git, however when I navigate to the Domo Asset Library (which I need to manually type in the URL with the address bar) and I click the orange button 'add card' I get this error. Is there…
-
NOAA Connector
I saw some people using the NOAA connector data at DP18. I got the token to activate the connector, but I am having a hard time understanding how to get weather data out of it. Does anyone know of any resources that I can use to understand this connector? There are 2 things I would like to pull into Domo so I can ETL it…
-
How to fix processing error in upsert?
Hi all, We are trying to update our data via the merge update option (please see the image below). We are also updating our query in the "details" section with a statement like SELECT columns FROM table WHERE tiemstamp>tiemstamp of last run But every time we try it we get the following error message: What does this error…
-
Days Since Last Instance
I need to build a beast mode that gives me the days since the last time a sales rep transacted. My dataset includes several transactions by the same rep but I only want one line per sales rep and however many days it has been since their most recent sale. Does anyone have experience with this? --I've built a beast mode to…
-
Custom Connector how to choose which JSON node to pull data from
I'm creating a custom connector and the JSON format follows this pattern {"code":0,"message":"success","data":[{"website":"https://redactedwebaddress","monitor_id":"15223002603958004","use_ipv6":false...............etc When I attempt to parse the JSON it returns code and message data however I would like to start pulling…
-
Filtering a Dataset in a Custom App using a URL
Hello, We are planning to have an external link to a custom app that will filter out one record. However, I know that DOMO custom apps cannot access the url in the address bar, so we cannot use a query string. Additionally, I have tried the page filter URL and it seems to work, but not as expected. The user would need to…
-
Can't save card (no beast mode or color rules)
I can't save one card I'm working on, for inexplicably no reason. I found this thread: https://dojo.domo.com/t5/Card-Building/Cannot-save-card/m-p/24129 Unfortunately, the fixes here don't work, as I have no color rules or any type of beast mode for this card. It is a simple table with a date range of all time filtered…
-
Dataset Data Definitions, Metadata, Sources and Information
Can someone please help? I figure that there has to be some way to organize data definitions for individual columns, or just general data in a dataset. I was hoping someone could share best practices of this? The tiny description space is extremely inadequate for this, even if there was just a notes page that I could edit…
-
Error uploading assets while uploading customapp
Getting below error while uploading custom Apps's: Design can be found at https://XXXXXXX.domo.com/assetlibrary?designId=7a515f05-387d-47c5-a129-cd60859a03cd X Error uploading assets
-
Trello Connector - not getting the board name, list name and labels in dataset
I would like to create a dataset from trello to summarize the status of the projects. While i am using either trello connector or the trello app, i am not getting the board name, list name and labels on my dataset. Can you please check and let me know if there is any issue with the connector.
-
Use data as header
I have a data set that shows locations, event name, and date. I want to set it up kind of like a calendar, such that the date goes across the top as a header, locations are the column, and then under each date is populated with the event name. Is there a way to do this? so like this: 5/1 5/2 5/3 location event event event…
-
User Activity Metrics
We have setup our Domo metrics connector and data sets, and we have a 'Most Active Users' metric. That metric however is only measuring login by a user. Not how many times they've opened a card, made edits, etc. Has anyone pieced together the data sets to get more accurate "activity" metrics from a user perspective?…
-
Additional textbox for explanation in KPI card
I would like to have an additional textbox for further explanation in a KPI card. Reason is I have a data set is from a third party and I need to elaborate the source to avoid license issues. It appears that the only usable place for my own text is the card title. Only this is a always visible for cards but it already full…
-
How many orders that contain just 1 line item? (1 Item Order Count)
Looking for some help on a beast mode. Here is a short video I put together so you can see what I'm trying to accomplish. In my dataset I have line item detail on orders we enter daily. We currently have beast modes for the number of orders, the number of lines, and the average lines per order. I need to create a new beast…
-
Domo + BambooHR
Is it possible to connect Bamboo HR to the Domo user list? It would be nice to automate the people list in domo so that I am not having to add and delete employees every time someone joins or leaves the company.
-
Custom App with parameter
Hello, I'm creating an app on which I want to view data based upon the user's selection. How is it possible to send a parameter within a custom app using the app.js file or something similar? Let me know what you need to know for this topic. Thanks.
-
Hey there,I am trying to figure out how to have hyperlink within a chart that takes you to an ex
Hey there, I am trying to figure out how to have hyperlinks within a chart in Domo that take you to an external website. I know it is doable because someone in my company did before, but I cant figure out how he did.
-
Converting cumulative data to difference
Hi, In the following table, I want to change the 'count' column from cumulative to differences. So instead 20, 20, 30, 30, 30... I want it to be 20, 0, 10, 0, 0... It would be great to know what's the best way to do it. Thanks!
-
Grouped Bar with Line Graph when series in multiple columns
Hi all, I know that the Grouped Bar with Line Graph requires one column for each of the "series", X axis, Y axis I have the following table: Date; Operation type; Operation amount; Rate 3/28/2018; Withdrawal; 1,000; 4% 3/29/2018; Deposit; 800; 3% What I have built is a grouped bar with shows the following: But I also want…
-
Suming Invoice Amount with Specific Criteria
I have a table with data that looks like the sample data below. I would like to be able to sum the total invoice amount on a per job # level and be able to attribute it to the Firm designated as the "Original" for that job #. As an example the Sum of invoices for job #1 would be 200 and it would be attributed to "Test Firm…
-
Decimal numbers are wrong
Hi, i have a CSV-file with decimal numbers, but they are loaded not correct by workbench: "" --> correct mapped to null "0.0392156862745098" --> correct mapped to 0.0392156862745098 "0.0784313725490196" --> correct mapped to 0.0784313725490196 "4.43137254901961" --> WRONG mapped to 443,137,254,901,961 It appears everytime…
-
Referencing formulas in formulas
Is there a way to reference Beast Mode variable names in another formula so I don’t have to copy the entire formula again which could get complex and hard to read ?