-
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
-
CASE WHEN... AND in SQL ERROR
I'm working in MYSQL and trying to write a CASE WHEN Statement with multiple AND X<Y conditions. When it is finished, the statement below will be much longer with 15 more AND conditions, but right now this shorter version won't verify. The purpose of this statement is simply to find the lowest value across 15 columns for…
-
Beastmode Count help
Hello, I'm looking to create a beast mode to provide a summary number but my case statement counts are not working. The data looks like this: Message Key Data Source 1 Collected Delivered 2 Collected 3 Collected 3 Collected Delivered Delivered never has a message key but collected could have duplicate message keys. I'd…
-
Postgres Data Flows
I'm new to Domo and finding my way around, so apologies if I'm asking an obvious question. I've set up Postgres DataSets and they seem to work just fine. I've now noticed that there are SQL DataFlows based on either MySQL or Redshift (which is a fork of an old version of Postgres.) Is there any plan to support Postgres 9.x…
-
SQL dataflow help
Need some help from the SQL guru's out there. Table as seen below. User Name User Org Client Name Client Org Phil ABC Comp Jack DEB Comp Phil ABC Comp Jack EFT Comp Phil ABC Comp Jack ABC Comp Phil ABC Comp Jack OKA Comp Phil ABC Comp Jack IPA Comp Phil ABC Comp Jill CDE Comp Phil ABC Comp Jill XYZ Comp The situation is…
-
Count Summary Number
I'm having an issue adding up multiple columns to present an overall summary in a pie chart. Below is a sample of the columns. These are scored given by managers during visits to their sites. I'm trying to combine the two to create a chart that shows the total number of mastered, in place, not in place, or blank. I thought…
-
Does anyone have the Beast Mode with HTML code to include an up or down arrow into a card?
I am sure I saw a beastmode with some HTML code earlier this week on Dojo which reflected an up green arrow or down red arrow based on another columns output. I just can't find this HTML beastmode on the forum anymore. Does anyone have it to share? Thanks.
-
Beast Mode for Numeric & Alpha Fields for PayRate Conversion - BambooHR Connector
One of our SQL query guru's was able to pull this one together as a beast mode rather than getting complex in the ethers with a magic ETL or MySQL transform. Below is taking a PayRate value where sometimes there's a 3 letter alpha field for the currency which made the field text. We needed to break out the letters to make…
-
Sum Columns based on Unit Number
Hello, I am trying to sum a hours column based on unit number, each unit number appears multiple times in the data set (for each time it needed service) I need to sum the hours of work done to each unit, any recomendations? Thanks!
-
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.
-
Calculating Average Time Between First/Last Login
Hi, I have a table of user logins that has user id in one column and the date they logged in in another. I'm trying to calculate how long users typically login before they become inactive. Ideally, I'd be able to map number of months on one access and number of users on the other. What type of operations would I need to…
-
Domo Beast mode row aggregation
Hi Domo-Community! Hopefully, you can help me! I have a table like the enclosed one, which is based on a huge file, with the help of ETL I was able to reduce the complexity to this level. My problem is that I can´t aggregate each day to one row. The aggregation is based on the filter. So, when I want to see salesfigure for…
-
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…
-
Google Analytics data showing up in wrong quarter
Hello, I have some cards powered by Google Analytics data from our websites, but when I try to sort a number of our fields by quarter, namely Pageviews, Organic Traffic, Pages per Session, Avg. Time on Site, and Bounce Rate, I can't get Q1 2018 data. Instead I've found that the numbers from July to September are…
-
SQL variables with spaces in them?
My existing dataflow has column names like "trade show", "contact person" and so on. But when I write SQL code for the transform, I get syntax errors: SELECT TOP 10 trade show,contact person from my_data_flow SELECT TOP 10 [trade show],[contact person] from my_data_flow none of these work. What should the query look like?…
-
Using Beast Mode to substitute null fields
Is there a way to use Beast Mode to make the null entries 0's in the attached picture?
-
Beast Mode Help: Two layers of division
I've got a calculation I am trying to perform with a beast mode formula, that I can't get to work. The calculation is (Number of Lines / Hours Active) / Standard I'm trying to protect against divide by zero in the two layers of the formula. The first item in the order of operation is the (Number of Lines / Hours Active),…
-
Top 5 Selections within 7 day Rolling Period
I'm creating a dashboard to track complaints filed against a facility. Each record in my dataset is assigned to a unique ID. Each unique record displays 1 "topic" they selected. The "topic" is the reason for their complaint. I need to find the Top 5 Topics selected on each ROLLING 7 day period. So today's 7 day period…
-
Breaking data per month viewed per week
Hi DOMO - Good Morning! we have a data that shows per week data per resource. and we only have 2 date columns which starts from Sunday and ends on a Saturday. the total hours, and daily hours have all been already grouped by using magic etl.…
-
Filtering data before aggregation in card view
HI, I am very new to domo and need some help to see if this is possible. I have hourly data for 14 days. 7th Jan 2019 to 20th Jan 2019. e.g. 07/01/2019 01:00 6 07/01/2019 02:00 9 07/01/2019 03:00 10 07/01/2019 04:00 12 07/01/2019 05:00 15 ... ... 08/01/2019 01:00 9 08/01/2019 02:00 33 08/01/2019 03:00 122 08/01/2019 04:00…
-
Troubleshooting on Dynamic SQL in MySQL
Hello, I am working on to create dynamic sql in MySQL. Bottom line for my query is, I would like to create column for each question and display answer associated with it in row for each application. This query is keep giving me an error. Can someone look into this and make some suggestion? Also, is there a way where we can…
-
CROSS Apply equivalent in Redshift SQL
Hi All, I am trying to find the equivalent of CROSS APPLY in the query below. Can you please help.. WITH CTE AS ( SELECT *,ROW_NUMBER()OVER(PARTITION BY "ORDER","ORD_DATE" ORDER BY "DATE_VALUE" DESC)AS RNum FROM input ),CTE2 AS ( SELECT "ORDER","ORDDATE","PRMDATE","DATE_VALUE" AS recdate, DATE_SUB("DATE_VALUE", INTERVAL 7…
-
Revert Data Set
Hi - I would appreciate any assistance someone can offer. I was working with an ETL and accidentally filtered too many rows of my data set. Now some of my important data is lost from the set. I need to revert to an earlier version of the data set; is there an easy way to do that?
-
How To show sum after nested calculation using beast mode
Hi I have a dataset where values are like below: SessionId ActivityType ActivityTimeStamp Company 1001 Play 2022-04-18T04:28:12 ABC 1001 Play 2022-04-18T04:28:13 ABC 1001 Read 2022-04-18T04:28:14 ABC 1002 Play 2022-04-18T04:30:10 ABC 1002 Play 2022-04-18T04:30:15 ABC 1003 Play 2022-04-18T04:40:15 XYZ 1003 Play…
-
Seeking Visibility to Scheduled Report Recipients
I am seeking a way within Domo as an admin to see all of our scheduled report recipients within a single dataset. Anyone know how to do that?
-
Troubleshooting on Dynamic SQL in MySQL
Hello, I am working on to create dynamic sql in MySQL. Bottom line for my query is, I would like to create column for each question and display answer associated with it in row for each application. This query is keep giving me an error. Can someone look into this and make some suggestion? Also, is there a way where we can…
-
Need help converting a MS SQL Query
Hello everyone, I am trying to move one of my SQL queries to Domo. I was able to move the query but I got slightly different results. I will attach the original query and the query I used to create the sql dataflow. Did I make a mistake with the dates in the query while moving the query to Domo? SQL Query select distinct…
-
Looking up values from secondary data source for multiple columns
So I'm having some trouble wrapping my head around a solution for this scenario in Magic ETL: -I have a primary data source with multiple columns where values are stored in shorthand like "hc_res" but I want to display reports with pretty names like "Healthcare Resources". The mapping of "hc_res" to "Healthcare Resource"…
-
Replacing Values in Multiple Columns Based on a Lookup Table
So here's a challenge I can't seem to figure out how to solve in Magic ETL. I have a primary data source that has values written out as "tags" like "hc_res" and a secondary data source that maps those tables to pretty display names like "Healthcare Resources," which is what I need to display in reports. Normally, I'd just…
-
Indexing Magic ETL vs Adrenaline
Hi a quick question Does Magic ETL delegate the Indexing to adrenaline. if it does would it be more efficient if the dataflow was in Magic ETL or Adrenaline. if you have a big dataset im assuming the SF layer will need to transfer from one engine to another ?