-
Conditional LIKE Statements, Does not Contain, NOT LIKE: Beastmode Only
Hey guys, To organize my blox_section column I created a beastmode formula under the Data tab in the Analyzer tool to create a new column called "Content Topic": My Case Statement is the following: (Case WHEN `blox_section` LIKE '%crime%' THEN 'CRIME & COURTS' WHEN `blox_section` LIKE '%sports/high-school%' THEN 'HIGH…
-
Number of Months Left As Displayed in Table
Is there a dynamic beastmode that counts the number of months displayed in a table?
-
Create time column for Line chart
Hey guys! So I want to create a line chart that shows the sum of a total over the course of a 24 hour time period. I have a timestamp column where I extracted the time but tbh it looks weird. So I was thinking to improve the chart, is to create a column that include all time over a 24 hour period (not military time) and…
-
Write a Filter Formula using Magic ETL Filter Tile
Hey guys, so I am trying to utilize the filter formula feature in magic etl, but I can't seem to get it to work. When I run the following formula, no data appears. Using Excel, I performed a concatenate on all 517 websites that I would like to be filtered out from my data in order to build my formula. I've also used AND as…
-
Previous day values - Following Day Values Restart Calculation Each Month
Hey guys, I have a dataset that appends each day to include the daily downloads, and resets the calculation on the 1st of every month. This issue is, it's cumulative totals, so if yesterday we had 40 downloads and the following day we had 15 downloads, the total for the following day would come in as 55 total downloads.…
-
Add multiple Hyperlinks in one cell
Hey there, I have been trying to create a hyperlink in my cell using Domo Beastmode. The issue is, if there is a string proceeding or following the link, the entire cell becomes a link. Which is problematic because some cells are have multiple links with string while others have multiple links and no string. Is there a way…
-
Convert Timestamp to CST, UST, MST, EST Python
I have a data set like the following: start_time_UTC 2021-09-16T12:00:00-05:00 2021-09-15T19:00:00-05:00 2021-09-16T08:18:00-05:00 2021-09-16T12:22:10-05:00 My default time is UTC, but I would like to create multiple columns based of the start_time_UTC to create cst, mst, and est. from domomagic import * from datetime…
-
Previous Row + Following Row: Cumulative Sum
Previously, I was provided a video to help with receive this result, but didn't realize that performing it in View Explorer didn't quite work, so I sadly had to create an thread for the same question. Using Magic ETL I would like to find a way to take the previous row + the following row, keep the sum and continue to add…
-
Exclude first Value - Rank & Window
I am currently calculating the contribution for my dataset and have already sorted my values in descending order using the rank tile with date and group for my partitions. What I'm hoping to do is sum the previous value + the following value until my last value would be the grand total. In theory, I thought using the rank…
-
Avg Per Hour
I'm trying to use the analyzer tool to get the average number of posts per hour. avg(COUNT(DISTINCT `Permalink URL`) over(partition by HOUR(`Created Time`))) I want to be able to use the following graph where the series is the average. For some reason, when I run the query, nothing comes up on the graph and it turns blank…
-
Comparative Gage - What's wrong with my query?
Using the Comparative Gauge, I wanted to display our performance by whether the number of impressions have increased or decreased. Only, when I use the following window functions, I get a blank card with a downward arrow. Current Month: sum(case when MONTH(`Created Time`) = MONTH(CURRENT_DATE()) then…
-
Finding the Max Average
Can someone help me build a beastmode to locate the max average? I am trying to return the average day with that, on average, shares the highest value of the week. By taking the max average of days, with the max average of days with the highest values, is it possible to discover the day that returns the highest avg? I…
-
Python
Hey guys, I can't find any documentation on how to use the python widget. I've read the documentation on the site already. It didn't provide me any insight on actually implementing it and the Schema tab is far too confusing. I don't even know why I would import all my selected columns if I'm going to be creating another…
-
Return AVG DayName
Hey I was wondering if there is a beastmode windows function that would allow me to return the avg dayname from the average of x? I have data that includes a domain, a column for day name(made via beastmode), and an avg of impressions). Any ideas? I thought the following would work if I added concat in front of it but I…
-
Return Day with highest value - Case Statement
Hey guys I have a date column from Oct-Dec, a numeric column of totals from the date, and finally a categorical date column full of names. I've attached a sample data table. I'm using a beastmode that splits my dates into weeks. I want to create a case statement that returns the value of the day from the week that had the…
-
% of Total
Hey there, I'm trying to create a % of total column for my dataset with various domains. Issue is, there's multiple rows with the same values as others. Tried to perform a group by domain then rank by video plays with a partition by url, but it is not working. Thought maybe a window function could work, but I would need it…
-
When x is null and y and z is not null then case statement - multiple parameters
Hey there I'm trying to perform a case statement in magic etl using the formula widget. I'm trying to use automl tool to predict the likelihood of receiving a like, comment, and/or shares based on a section topic. I'm not sure if I'm on the right path though. (CASE WHEN `likes` IS NOT NULL AND `comments` OR `shares` IS…
-
Need to pull specific months from my Date column using Beastmode
Hey there, I'm trying to pull all dates from October and another from November. YEAR(`date`="2020")+MONTH(`date`="Oct") My date format is different though, it has the day first, then Month abbreviated, then year(full) 13 Nov 2020
-
What's wrong with my Beast Mode Calculation?
When I tried to show the results from the queries below I get this error, "An issue has occurred during processing. We are unable to complete the request at this time" AVG(sum(distinct`Users`)/ `Content ID`) AVG(SUM(DISTINCT `Users`) over (order by `Content ID`)) I want the average of users over content id, but the results…
-
BeastMode Lead Function Doesn't Exist - Rolling Average
Hey guys, so I'm trying to apply this concept to my dataset, but when I tried to apply it I received the error, " Invalid Formula : This calculation is using a nonexistent function." Apparently, the lead function doesn't exist in the BeastMode library but it did when this video was created. (6) Domo - Analyzer - 3 month…
-
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.
-
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?
-
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…
-
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…
-
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…
-
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…
-
Replicate Excel Formula by using Domo to Calculate 80/20
Hey there! I'm trying to apply the Pareto Principle to the following dataset I've attached using either Beast Mode, Magic ETL, or MySQL. I want to replicate what is done in column "Bottom 25" in Domo but I'm at a loss. I've used the following query, but it gives me whole numbers instead of what's displayed in the "Bottom…
-
Can you apply previous pdp to another dataflow?
I am a new admin so excuse correct me if my terminology sucks. Previously, I manually added to my PDP my domain list with associating emails so that my dashboard catered to their associating email. It's a long process when you have 99 domains. I just created a new dashboard using a different dataflow. I would have to go…
