-
Using BeastMode Calculate the 80/20 by Category
Out of all the domains, which 20% of all domains account for 80% of the Users? There should be more than one domain I think that account for that 80/20. In addition, how can I measure that distribution difference? I'm trying to this strictly in DOMO, but since I'm new, the struggle is real.
-
reporting table last 60 days
Hi I am trying to create a table that shows our orders for the past 60 days. The date will be based on order date. I am new to domo and not sure how to create the beast mode. Thank you in advance.
-
CASE Statement: Percent of Remaining
Is there a beastmode where we can show the % remaining after filtering by a percent? Filter by User at 10% of the traffic then show % of assets remaining after that 10% was filtered? Can I do this in a beast mode calculation?
-
distinct count of concat (column) , row_number over partition by (column) - Why isn't this working?
Good morning I'm curious if anyone has any insight into why this beastmode doesn't work, because if I could get this to work, it would solve a lot of work for me. The beastmode that doesn't work for me is: COUNT(DISTINCT ( CONCAT(`hs_rpt_drivemaster.driveid`,'',row_number() over (partition by…
-
Remove decimal from time format
Team, I have a very simple calculation to get time since the last record up to today's current time: CURRENT_TIMESTAMP() - MAX(`sys_created_on`) This seems to work fine and returns a time formatted like this for example: 2 02:34:26.0000 How do i modify my formula to remove the ".0000" part? Thanks Tim
-
x
-
Recreate 2 Excel Formulas in both Magic ETL and Beastmode
I am trying to replicate the following formula(s) in excel in DOMO. I hav ebeen using Magic ETL but apparently the mysql library is very limited. I've provided an example of my dataset that I want to replicate in DOMO using magic etl Then, if possible, I also want these same formulas replicated in Beastmode. Formulas in…
-
Calculate sum of x over (order by y)
Hi! I have tried the following script in beastmode and it said successful after validating it but when I go to apply to any table, it shows an error, "An issue has occurred during processing. We are unable to complete the request at this time." My Users column is an integer and my Section Master column is text.…
-
Excel to DOMO running total magic etl or magic etl-python
Can anyone match the exact results from the formulas in my excel spreadsheet? I used the following for beastmode, but the answers don't match what is in the excel sheet so I'm at a loss. I only want to replicate this using magic etl, but I don't think it's possible. I'm acquainted with the magic etl tool but I don't know…
-
Calculate time between incidents
Team, I am a newbie, thanks for helping I have data in a table that contains a timestamp of incident creation time on each row. I am trying to show the average time between occurrences. Basically, I want to write a calculation that with give me the average time that have passed since the previous occurrence (row) I know…
-
Excel to Magic ETL
Can anyone match the exact results from the formulas in my excel spreadsheet? I used the following for beastmode, but the answers don't match what is in the excel sheet so I'm at a loss. I only want to replicate this using magic etl, but I don't think it's possible. I'm acquainted with the magic etl tool but I don't know…
-
Calculated Fields in Cards
I created a calculated field in beast mode (sum of 7 columns in my dataset). I need to use this field as a summary number in cards. I am calculating total brand impressions and need to show the total as a single number for each partner and to also show the total by partner year over year. When I add the calculated field to…
-
Receiving an error in my Beastmode | Multiple case statements
I am pretty sure it has something to do with having multiple case statements. I've the following code which gives me an syntax error: sum(CASE when `Date` >= (DATE_ADD(CURRENT_DATE(),interval -15 day)) and `Date` <= (DATE_ADD(CURRENT_DATE(),interval -1 day)) then (case when `ConversionTypeName` like '%Sale%' then…
-
How to change timezone of a column in Magic ETL based on another column
How do I change timezone of a column in Magic ETL based on the input of another column. e.g. I have a column called Datetime, which has date-time values (e.g. 2020-12-07T00:00:00). I have another column called Timezone which has a timezone (e.g. 'UTC') I want to convert the datetime column from America/New_York Timezone to…
-
CASE statement if else Magic ETL
Hey guys I am trying to fill a column based on certain criteria from 4 columns. I think it would be best to do this in another column so that I'm not overwriting anything. My table looks like the following and I'm trying a Case Statement that fills in the null spaces, but I think my case statement is missing something or…
-
Total Column in a different column
Good Morning I have a column let's say (look below) Is there a way to create another column with the total sum of that column? So it reads a new column that says total and it should be the same number? Thanks! category category total A 1 A 1 6 A 0 A 0 6 A 2 A 2 6 A 3 A 3 6 A 0 A 0 6 B 0 B 0 2 B 2 B 2 2 TOTAL 8
-
Running Total with Magic ETL (not MySQL)
I've made this short video to explain what I'm trying to do:
-
Magic ETL Python script
Hello. I can't find any example to run a Magic ETL Python script. I have added a column. I want to populate it with a pythons script and it never works in the schema tab I have added a new text column named : "Alias" and here is my script : # Import the domomagic package into the script from domomagic import *# read data…
-
Pull Data From One Column Based On Condition From a Different Column
Hey guys! I've been at this for a while, Magic ETL, Analyzer, Google, nothing seems to answer the following (maybe it's because I'm new) I can't seem to find a means to pull data from a numerical column based on the condition of a categorical column without aggregating as a sum. Could anyone help me with this without…
-
Beast Mode for Top 20 then Other
I am creating a table to rank sales by each company for the last 3 years and totalling the revenue. I would like to show in a table the Top 20 companies by Total 3yr Revenue with the remaining companies aggregated in a row named "Other" rather than the individual company names. I was trying a beast mode to rank each…
-
Counting the occurrence of a certain character in string
Hello there, I was wondering if there is a way to count the occurrence of a certain character in a string. Specifically, I have a column that contains the gender information (M or F) of each data entry. All of the data entries are grouped according to a unique key, and while grouping, the gender column is collapsed with a…
-
DATE_SUB function
Trying to write a Beast Mode that calculates yesterday's date. DATE_SUB(CURRENT_DATE(), interval 1 Days) This formula validates just fine, but an error occurs when I try to use it in a table or see it in a drill down. Any ideas?
-
Case statement to filter by minimum and maximum values
I would like to be able to filter by a summed value. As Domo unfortunately does not allow Aggregated filters, could I bucket the locations into small medium and large by percentage of max and then allow a filter to be used that uses that case statement? Has anyone had a similar problem?
-
Combine 2 datasets with join or append while preventing duplicates
I have 2 datasets: * 1 containing conversions per day per product * 1 containing the costs per day (in total) I am trying to get to this: CostsSalesRevenueROITotal 1993600501Product A2200 Product B 1400 Total 2203600580Product A2200 Product B 1400 But I end up getting this CostsSalesRevenueROITotal 11983600402Product…
-
Rolling Count Calculation
Hi, I am trying to get a rolling count of data over a week, 4 weeks, and 8 weeks period. This is the sql query I have in the transforms dataflow. Then in the analyzer, I would select Count of 'Rolling_Week', 'Rolling_4_Weeks', and 'Rolling_8_Weeks'. But I am getting 0 for everything, which is not accurate. Could anyone…
-
Summing Up Last 12 Weeks Beast Mode
Hi There, I am trying to do write a beast mode to sum up Revenue from the Last 12 weeks but not counting the previous week. for example Last Week = 11/22 - 11/28 (Sunday - Saturday) I want to go back 12 weeks from last week, so I would start from the Week of 11/15 This is what I've come up with but it doesn't seem to…
-
Recursive dataflow Issue - No Data
Aloha All: I have a recursive dataflow that is wiping out my start and end dates when the new data is uploaded. Current data has the start and end dates; however, the historical data is missing the dates. The dates were originally there in the initial upload. My recursive has a join the new data and historical data. Then I…
-
Best Mode: Cumulative Sum
Hi All, I am trying to create in Best Mode a Cumulative Sum of column `Amount` to be represented in a table format. I want to take the `Amount` 50 and count it for all months from `Start Date` to `End Date`. In the example below, I would like to count 50 for July, August, September, October and November. Do you know if…
-
Is it possible to create or update beast modes using an API?
Hello, I work with multiple datasets (8+) that frequently need their beast mode calculations adjusted to stay up to date. The changes are small, but copy and pasting it to multiple tables is repetitive. Is there an API available that can be used to do this? Maybe there is an available work around too. Thank you!
-
Joining based on conditions in Magic ETL
Can we make joins based on conditions in Magic ETL? e.g. I want to replicate the below in a join in magic ETL. Can I do it? SELECT dataset_1.* dataset_2.* FROM dataset_1 LEFT JOIN `dataset_2` on (dataset_2.id` IS NULL AND `dataset_1`.`Day` >= COALESCE(dataset_2.date`,dataset_1.date`) )