-
Percent of Total on Table Chart
Can someone give me some assistance in displaying the percentage of total for a column on a table chart? I have a table with a count of employees by gender and this works fine on a pie chart using %_PERCENT_OF_TOTAL however someone would like it in a table. Thanks.
-
Create 'same' drill path for multiple cards
Does anyone know of a way to create drill paths for multiple cards formatted the same way? I have several cards with similar data (same column names) and would like to create a drill path table for all of them, but would prefer not to do it 20 times. Thoughts?
-
ETL/SQL or Beast Mode Data Merging Assistance
Hi, I need some assistance regarding the best way to perform the following. We have a report which is updated quarterly. On this report are numerous metrics of different types (strings, numbers, etc.). We need to be able to create a recursive dataset where we can (in HTML Table view) see a side-by-side comparison of the…
-
Issue changing string date to date in MYSQL ETL
I'm working on a query where I'm fed in a month name and need to change that into a date. I've formatted the string so that it looks like '2019-11-01' and such, but when I try CAST, STR_TO_DATE, DATE_FORMAT or anything else, I get a blank into the field value. I'm not seeing any errors. Any thoughts on what I could be…
-
MYSQL Transform: Replacing date on historical input based on update of second input
I'm looking for the best way to do this. I have a SQL Transform with a recursive input and a second input which I'd like to have replace the input of the recursive data based on the date in one of the columns of the second input. The pictures below should help because I'm just as confused explaining this as you probably…
-
Collapse and Merge Columns
Hi, I'm trying to join two datasets together with a single shared field. I can do this just fine, but I'd like to collapse one column from both datasets into the same column and leave the rest of the columns intact. Below is an example of the column I'm trying to combine. I don't want to do a straight append though because…
-
Issue converting string to number in beast mode
I've seen some others posts about this and have gotten this to work on other cards but I'm having an issue converting a string to a number on this card. I've tried `Field_name`*1 and I've tried CAST(`Field_Name` AS DECIMAL(10,2)) but I get back a 0 or null response in the newly created column. I've also tried a CASE…
-
0 Rows returned when trying to use xml tags
I'm trying to bring in some XML data and when I run the import by pasting in the xml, I'm only given one row while my xml data has hundreds. I tried specifying the tag but when I do I get 0 rows. Not sure what I'm doing wrong. Also haven't worked with xml too much. Here's a sample of what I'm trying to pull in. There are…
-
Dynamically Uncollapse Columns for Tabular Output
Hi, I'm trying to create a stored procedure like in the link below and while its not erroring out, its also not uncollapsing columns like it says it would. I'm not great at SQL and I've tried this in ETL but I can't get it to work there either. https://knowledge.domo.com/@api/deki/files/5209/Dynamic_Pivot.sql?revision=1…
-
Textbox Font Size Different on Page View and Card View
Hi, I have several textbox cards next to each other on one page showing different values. I tried setting a font size in the General settings of the card and when I'm looking at the full card itself, things look fine. However, when I'm looking at the page showing all of the cards next to each other, it appears that the…
-
Heatmap Shows Duplicate Rows
I'm on a roll with asking questions here so I figure I'll keep going. I'm trying to create a heatmap to show the number of hours by group for a large set of projects but I'm running into an issue where the project name is creating a duplicate line for each group that has hours in the project. See example below. Or The…
-
Custom Connector - Parse a json object
Hi, I'll start this by saying that I don't know javascript at all, but I really want to figure out how to create a custom connector. So I was messing around and was able to get some data using the following partial script. What I want to do is to set the "resources" object of the response as a variable so that I can then…
-
Issue getting Last_Day(`Date`) working properly in mysql query
Hi, I have a MySql dataflow that I'm having an issue with. I have this query that I'm working with and I'm trying to pull the latest NumProjects value in each month. In the output, I'm seeing that its showing the latest set of values twice because the values are different (I assume). This winds up throwing my chart off and…
-
Progress Bar always shows 100%
Hi, I'm trying to build a Progress Bar and I'm not sure why this is happening but no matter what I do, the bar is always showing 100%. My current Goal value is 13721 and my Guage Value is currently 12488. Doing that math, that should be 91%. Not sure why. Any thoughts?
-
Specifics on connecting to Sharepoint and Project
Does anyone know the exact steps (url depth needed) to connect to sharepoint online? Also, will connecting to sharepoint grant access to Microsoft Project?
-
Using a Beast Mode Calculation in Summary Number
Hi, I'm trying to create a beast mode that will allow me to use CASE WHEN COUNT as a summary number and I'm having some trouble. I've tried this with SUM and AVG in front. I've tried subtracting the Like count from the Not Like count. I'm not sure how to turn this into an aggregation so that I can use it in the summary.…
-
Change color when value is greater than another column
Hi, Is there a way to change the color of a column based on it being greater than its comparison group column? See below for the example. If the blue column is greater than the green column, I want the blue column to turn red.
-
Remove duplicates from large dataset
Is there a faster way than ETL to remove duplicates from a very large dataset?
-
Receiving 415 Error when Updating Dataset through API
Hi, I'm trying to upload some CSV data with Python and I feel like my data is formatted properly but I'm still getting a 415 error. This is what the data looks like and is set to a variable cvList. "None","Auxiliary Copy","Running","92" "vmidintrawfe01","Backup","Running","52" "soepdfs02","Synthetic Full…
-
View Unfiltered Data in Drill Path OR Sum All Data (including filtered) in card
Hi, I have a card that I'm working on where I would *like* to filter by 'In Progress' but at the same time, would like to show 'Complete' only if 'In Progress' is greater than 0 for the specific column. If I can't do that, I know I can filter for 'In Progress' but when I try to add a drill down card, the 'Complete' don't…
-
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…
-
Add date row in ETL (or other) for dates that do not exist.
I have a salesforce import and am pulling in records that are not created every day. But I'm trying to trend this information and its difficult to do since the last time a case of this type in salesforce was created was several weeks ago. So on my card, it looks as if domo hasn't updated since then, but really non cases in…
-
SUM of CASE in Beast Mode
I'm trying to do what I have below and am failing. I have multiple columns with Yes/No statements and I want to count the yes ones and divide by the total. SUM((CASE WHEN `Col1` = '' THEN 0 ELSE 1 WHEN `Col2` = '' THEN 0 ELSE 2 WHEN `Col3` = 'Disabled' OR `Col3` = 'Local Approval' THEN 0 ELSE 1 WHEN `Col4` = '' THEN 0 ELSE…
-
How do you filter out columns that have no summed results?
I have a chart where I'm using a Name as the group and some of the columns have a Zero Sum result that I don't want to see. See image.
-
Percent comparison chart with more than 100%
I hope I explain this correctly. I am trying to get a stacked chart where my field 'Estimated Hours' = 100% and my 'Actual Hours' is a percentage of 'Estimated Hours'. The Estimated Hours field has different values across the chart so I didn't think they'd all be even at the top. I'd also like to show it where if the…
-
Charting by AM vs PM
I'm pulling in data from salesforce and I want to measure it by number of cases opened in the AM vs PM. Is there a way to do this in beastmode or though an ETL? Here is a sample: 153148unassignedTest TicketThe status of your ticket is now Pending/Created as Pending. 9-Nov-17 1:23:00
-
Credential Set for Domo E-Mail Connection
Is there a way to add a credential set to the Domo E-Mail Connector? I have a link that is sent to me weekly. When I click on the link, it brings me to a webpage where I have to enter a set of credentials to login before the xls file download begins.
-
Issue with RegEx on specific field
Hi, I'm doing a Replace Value on a field and for whatever reason, the RegEx does not appear to be searching the whole field. I've used this before and it works on every field but this one. Does the RegEx here work on multiline fields? Thanks.
-
Sort order for legend not working
Hi, I'm trying to sort a legend on multiple charts by High > Medium > Low and I'm using the formula below, then sticking it in the sort field, but its not sorting by it. It looks to be sorting by the count of item in each of these categories. What am I doing wrong? (CASE WHEN `EB Project Risk`='High' THEN 1 WHEN `EB…