-
Anyone experiencing connectivity issues?
Dataflows cant be accessed and they are failing at run. This is the error that comes up "We encountered an error accessing the DataFlow, please try again later." also pictures on user's profiles are dissapearing anyone could check on it and let me know, thanks
-
Active users last x days
I have the following dataset ( see the attached screenshot). It shows the userID active on a given date and the session time. I want to determine which users were active in the current week, t-1 week, t-2 week etc. As an output I want a table with the following columns: UserID, active this week column ( 0 or 1 value),…
-
Counting unique orders each month
Hello I'm trying to build a beastmode calculation that will only count users ordering for the first time in any given month. My end game is to be able to have a vertical chart showing by day users ordering for the first time that month, however using a count(distinct) beast mode command will only tell me unique orders for…
-
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…
-
Amount of Days in Quarter
Hi, I'm trying to create a formula to count the total amount of days in the current quarter. Seems pretty simple, but can't seem to figure it out. Any suggestions?
-
Rolling 13 month calculated up to end of previous month
I have this calculated field whcih is a rolling 13 months but I cannot figure out how to limit it to the end of the previous month CASE WHEN `Start Date` >= DATE_SUB(DATE_FORMAT(CURRENT_DATE, '%Y-%m-01'), INTERVAL 13 MONTH) THEN 1 ELSE 0 END The results I am looking for if I ran it today would be everything from Feb1 2017…
-
Count the number of working days consumed or remaining month to date
I am trying to work out a Beast Mode Calculation on a dataset that I have that will tell me how many working days have elapsed since the 1st of the current month, or how many are left. I have a value in my dataset which tells me how many working days there are in the current month, I'm struggling with trying to figure out…
-
Use a case statement to return a value in another column
Hello - I'm trying to return a value in one column when there is a certain value in another column. When using the Case statement below, I get an error that a column doesn't exist...but it definately does. Any insight? (CASE When `Opp Status` = Won Then `Annual Value` Else 0 end)
-
Pivoting multiple columns to one, while keeping correlating data
Ok pretty sure I need to creat a pivot table of some kind, to move data that extends in rows across an unknown number of columns, and bring it all into one uniform column. The problem I have is keeping the associated row data when you move the data into one column. See below ---> What I have: What I need: How do I do this?
-
Using SUM and MAX
I am trying to get a quarterly view of a value where Q1 and Q2 are full quarters and Q3 is a year-to-date calculation. So my table is showing Quarters as rows. But when I try to pull the data using a beast mode like below, I get errors because I'm using the SUM aggregation with the MAX for the date (or the number of days).…
-
Effect of adding new column to imported data on an existing dataset/dataflow
Good afternoon! Not sure if I'm using the correct search terms but we haven't been able to find anything related to this question by one of our managers, and before changing anything we wanted to confirm whether or not it would cause any dataset/dataflow or card issues. We currently upload a file to Box each week, which is…
-
How can I filter data?
Hello Dojo, I want to show data which contains tag "help_request" but not contains tag "closed_by_Merge" How can I do that? Thanks, Jennifer.
-
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…
-
selecting last row in beastmode
So I have a dataset which has a column with a value that updates every 10 minutes. I would like to make a comparative gauge that will compare last value from today vs the last value from yesterday - i can't figure out the two beastmodes to create those values... any ideas? Thanks in advance!!!
-
calculate % of field
Hi, I am new to Domo and wondering how I can calclate the % of a field based on one of its values. I can essentially do this in excel using the following function, can I replicate this in Domo? =COUNTIF(F2:F500, "Closed Won")/COUNTA(F2:F500) The field that I am trying to count from is titled Stage (Column F) and I am…
-
How to find the Difference between Months of two dates. Eg : 01/01/2017(start date) and Curdate.?
-
Sudden Beastmode error
Hi there! I have a card, which uses a lot of beast mode calculations. All of a sudden. I get this error: "You have a divide by zero error in your Card´s Beast Mode / Link: Get help in Domo´s Knowledge Base" So, I checked everything and I was told that I needed a case function to avoid 0 division, also checked DOJO topics,…
-
Identify customers ordering on multiple dates
Hi I am trying to build a beast mode calculation to isolate customers that have ordered based on certain conditions. My dataset contains all customer ordering activity, each customer is identified by a unique user ID. Customers will often order multiple times each week. Each customer order is assigned a unique order ID and…
-
Dual figures in the Summary Field with CONCAT
So i found the solution to get two different values in the summary field with CONCAT command. I have the following beast mode command CONCAT('$', round(sum(`Value`), 2), ' Period Total | ','$', max(Case when (`date` = CURRENT_DATE()) then round(`Value`, 2) end), ' Today') what it does is allows me to se a sum of values in…
-
making sum of daily averages
So I have a data set which has the a date column and a column that represents a certain value for each date. I have several years of data where I have a single corresponding value but my latest data has multiple values per day - i.e. i have basically an entry for each 5 minutes per day. So when I graph this in a bar chart…
-
unexpected result from joining to ETL data flows
So here is another strange happening that I do not understand. Here goes folks: I have two data flows that I have created each contains a date column and a value column. The date columns don't match up exactly - same date but not the same time samps... anyway I want to join them so that I will have one date column and two…
-
How to filter range of measure value for specific dimension
Hello, I need to ignore some specific range of measure data for some specific dimension value. Please help. Eg : Yellow lines to be ignored. when product name = computer or laptop then amount is not equal to between 100 to -100 Please advice. Thanks Bikash
-
Beast Mode update
It seems like in the new Beast Mode you can't look through a list of previously written calculations on the data source. When you open Beast Mode via the 'add a calculated field' button you can only see a blank template for what you want to work on. It also seems like a Beast Mode calculation isn't available outside of the…
-
Sum ( Extract ( ) ) using RedShift
Using RedShift,,, i know that EXTRACT ( minute from date1) will give me the minute from date1 (18:03.94 returns 3) Ok,,, so now in my RedShift i said SELECT SUM( (EXTRACT(hour from date1-date2)*60) + extract(minute from date1-date2) ) So in my POSTGRES db, that returns everything great in total minutes.. Here's what i am…
-
How to count number of work days in a date range
My first Dojo question. I hope it is worthy. I need to create a simple table that shows the number of work days since the begining of the quarter, The total number of work days in the quarter and use those two numbers to calculate the percent of the quarter completed. Is there a way to count the days in a date range that…
-
Why are not all of my beast modes copying over when I switch datasets?
I have an existing dataset built using the dataflow that powers a lot of my cards, and which has a lot of beast modes on (some unique per card, some shared across the dataset). I've created another identical dataset using the data blend. However, when I switch over datasets, not all of the beast modes copy over. When I've…
-
Current Day vs Previous Day in Table
Hi Everyone DateSalesproduct6/13/201621A6/12/201620A how to create a table like below by using date set above Output ProductCurrent_Dayprevious_dayDoDA21205% Thanks in advance
-
Data Fusion Request - Changing Column Names
Hi - Could you please prioritize adding the ability to change field names in Data Fusions after they have been created? I understand that currently this is only possible at the initial creation stage. This is problematic because additional field names not only come in unchangeable, but they are combined with their original…
-
New User: Calculated Field Sum Error; Cannot find resolution documentation
This is an elementary function, and I appear to be doing it correctly, yet I cannot get the correct outcome. I am using beast mode to add a calculated field, which combines the value of 2 raw data fields. However, the calculated field, no matter what I do, always returns blank values instead of a calculated value. What am…
-
Case Statement (dividing by specific conditions)
Good afternoon, Dojo's. We received assistance in another thread (https://goo.gl/i5cVjC - thank you @RGranada!) but needed to expand upon the original beast mode to determine a completed percentage for only certain individuals as opposed to company-wide and @Valiant suggested it's best to open a new thread for this request…