-
Value Mapper using String
Can I use value mapper using string data? I want to label social media posts based on the caption to specify what products are they talking about. For instance So I want to search for "ball" in the caption and put "ball in a new column. Same goes for "food" in the second row. Any advice is highly appreciated.
-
How to Create Multiple Summary Numbers
Issue/Business Problem Description Many customers want to display multiple card summary stats that can give them a better picture of what’s going on in the card as it helps tell the story and can highlight what the card has in it. Description of Solution A customized Beast Mode calculation is necessary. The “secret sauce”…
-
Beast Mode POP Day Calculation
Hi everyone! I am currently trying to create 2 variance calculations and 3 YTD calculation. Lets start with the 2 variance calculations: * The first variance should calculate the Total Sales of each day and reduce it with the Total Sales of a day in the prior year. * The second variance should do the same, but in % The YTD…
-
Unable to Convert to a Date and Time Format
Hi, I am importing data from a txt file. I have several columns that are timestamps. For example, the data is 20160421114552 - meaning 2016/04/21 11:45:52. When I try to convert this to a date and time in Magic ETL, I select the column, put the new data type as "Date and Time", and select the format with "Year First". Yet…
-
Does RedShift offer better performance?
I am currently using MySQL data flows and indexing the join fields appropriately but performance seems underwhelming when dealing with millions of rows and/or GB sized data sets. Would I see a performance benefit utilizing RedShift? I began looking into the RedShift documentation and the first difference of note was…
-
How many dataflows are there in my DOMO instance
Is there any way in DOMO to check the total count of how many dataflows we have? Similar to seeing the count of datasets in Warehouse?
-
Filter on cells with multiple values
Hi, I am creating a calendar on Domo with a dataset that looks like this. This dataset is imported from Google Sheet into Domo. Is there any way I can create a single filter, with all the countries name, such that when I choose a country, all events corresponding to the country will appear? i.e. If I choose 'Poland', it…
-
Need some help: Two Beast Modes
I've got two Beast Mode calculations related to supplier receiving measures I am having trouble with. Hoping you can help me transfer my Excel knowledge in the example here over to Beast Mode. * Attached is a workbook with sample data, example of the finished report, and explainations of the calculations. * Here is a video…
-
Sum of Nested Beast Modes not coming up with Correct Total
I've got a Beast Mode that I'm creating that is trying to come up with the average value for the sum of 5 Beast Mode Calculations. If I use the first 4 in the Beast Mode and divide by 4 I get the correct value but if I try and add the 5th Beast Mode and divide by 5 the value that is returned is not correct. The average…
-
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…