-
new user with simple AR questions
Card #1 - my output shows total AR by customer. I would like it to show how much is current, 30 days, etc Card #2 - my output shows AR due by day. How do I get all past due accounts to show as due today?
-
Interactive Dataset
Currently we are looking for an 'interactiv' dataset which loads and updates data automatically from the database and can be edited manually afterwards, basicly like a combination of MySQL dataset and a Domo Web Form. Is there any existing connector with this feature?
-
Beast Mode Calculation in Summary Number: Average Calculation
I wanted to create a summary number with a beats mode calculation that calculates the average time in queue of a customer. The best mode calculation just transforms the time in queue from miliseconds to hours. Unfortunately I can't select the best mode calculation in the summary number. Is there a way to do this?
-
Average Probability for every userid
Hello team, I'm trying to make a beast-mode calculation or build a logic around the below topic there’s a field called “usersessionid” that can be a unique value or it could repeat more than once. There is then another column called “probability” that’s right next to it. The calculation i need to build it, a new column…
-
How Can I add data to a data source?
I have a Data Input called 'datainput_new' that in itself is a dataflow. I want to insert rows of data into this 'datainput_new' table using an insert statement. I am currently using MySQL for my dataflow. When I execute the script and test it immediately, I see that the insert was successful. However, when I exit the…
-
Closing Rate % And Filtering
So this is the first time I have not been able to find a solution on other peoples threads, so here is hoping! Our company gives cash offers for vehicles. They Submit a Form and Recieve an offer they can accept. I am trying to get the acceptance rate % for the current month. So I have it Counting The Submission Dates and…
-
Convert_Timezone() function
This is an optimization issue I have run into when joining tables on dates. I am left joining a table of dates to the data to create a record for each date that a row is valid for based on the join criteria. This dataflow used to complete in 15-20 minutes when I was using convert_timezone('utc','est',c.start_date). DST…
-
How can I calculate SLA for a ticket and how far past SLA the ticket went before resolution?
Hi all, I have a dataset that includes customer escalation tickets that have been or will be worked and resolved by agents. The data includes CREATE_DATE of the ticket and RESOLUTION_DATE. The tickets have a 5 business day SLA period from their CREATE_DATE to be resolved. What I am trying to calculate is how many days, if…
-
Determining if a record falls on the first day of a quarter and if not collect it in the next Quarte
I have been presented with an interesting task, I have a dataset that contains all of our sales records and our company measures SSS (Same Store Sales) Year over year. I solved this fairly easily by inputting the first RO date into the dataset for each location. Now the accounting department has come back and said they…
-
Group By value with Average aggregation calculating differently
Hi there, I believe I'm missing what is going on with my various attempts to Group By source data in order to gain an Average aggregate of a score. I take the entire dataset and when I place it in a table card and AVG the score, the calculation is correct but anytime I use the Magic ETL I was presented with a different…
-
Best mode percentage change incorrect value
Hello, Can anyone please help me figure out why the following beast mode calculation returns the number of registrations in the previous month instead of a ratio ? (( -- registrations this month SUM(CASE WHEN MONTH(`date_joined`) = MONTH(CURRENT_DATE()) THEN 1 ELSE 0 END) - -- registrations previous month SUM(CASE WHEN…
-
Rolling Average Numbers
Hey, I'm strugguling with 2 things and I haven't been able to find anything related. So I'm trying to sum the past 12 months daily so I can then divided by 365 and save that number. Then I need to show side by side this new number rolling i.e day 1 of the month = 166, then day 2 of the month (166+166=332), then day 3…
-
HTML Color of text inside of beastmode calculation
Hello all, I am trying to change the backcolor of the status column, here is the beastmode I am using : the <br> work fine in this mode, but any other HTML that I use, turn out like this on the screen : Can anyone give me guidance on what I am doing wrong? this is driving me crazy.
-
Active Record Count as of Certain Date
I'm trying to figure out the best approach for a Beastmode or other suggestion, to count the number of Active Records in a data set for a given period of time. Each Record has a Started Date and may or may not have an Ended Date (Determines the value of Active or In Active) I would like to be able to report the Sum or…
-
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.?