-
Can you subtract days based on case when statements?
Hello! I have a case when statement that I need to subtract a certain amount of days based off of: Case when 'ID' = '1066' THEN `Maturity Date` - 45 when 'ID' = '1019' THEN `Maturity Date` - 55 when 'ID' = '2600' THEN `Maturity Date` - 66 when 'ID' = '2507' THEN `Maturity Date` - 70 when 'ID' = '1075' THEN `Maturity Date`…
-
How to create a column of data
Hi, i wonder how i a create a new colum with the date having these columns "Month" and "Year", it could be mm/yy or any format, but i would like to be in "date" format Thanks!
-
How to put dates in order
Hello, someone could help me how to put the month/year in order? It is alfabetic order, but I want in cronological order
-
Creating a DataBase on Magic ETL
I have a database with a column Area with differents areas, and other column called "Value" and i want to create a new database grouping all theses areas in just one, but keeping the others columns with the info that it was. I want to do these Magic ETL
-
How do I count Not null values in beast mode
we do have function in SQL as name is not Null , Do we have similar function in DOMO beast mode?
-
Top 10 items view
we wanted to review top 10 item out of 1M items i can apply for filter accordingly example... how we should bring on ranking column while using beast mode
-
I need to create a dynamic report that shows me data between 2 and 5 days ago
I've tried a variety of methods but can't get seem to get it accurate. Any help would be appreicated.
-
Capture Duplicates in DOMO
Hi DOMO - Is there a way to do this excel formula in Beastmode? =COUNTIFS($A$2:$A$8, $A2, $B$2:$B$8, $B2) basically, it shows the duplicates based out of 2 columns. what we have is the Name and the Title and the location we want to see how many names have the same title for example: Peter Manager San Francisco Peter…
-
I'm stuck. Sum of a Windowed/Partitioned Sum???
I keep running into a wall with this. I think there is an easy answer, I just can't find it for the life of me. My dataset contains one row per store, per day. I want to display -- by region -- the count of stores with an average order value (AOV) less than $20. In order to do that, I first need to calculate AOV by store…
-
how to the find difference between dates ( in days ) that are in one column?
I am currently trying to figure out the days between each customers transaction. I know you can use the DATEDIFF function but what if my dates are all in one column? Any suggestions?
-
Calculating a moving month within 3 months
I am trying to calculate a moving 90 day period based on month. For example what I would like to see now is the date rolled up into DEC,JAN,FEB and as we move to next month I would expect to see JAN,FEB,MAR. I know the current month function to get only the current month moving but having trouble integrating the following…
-
Top 5 items using Beast Mode
How to List down top 5 items for sales by region from pivot table in grand total (column) e.g
-
Replacing value in case statement
Hello, In my dataset each account is assigned to state. In some cases I want to manually adjust the state. I tried to do in in ETL. I created a constant called State with empty string. Then I added a formula tile and created this case statement: (original state is what I had originally assigned to state) (CASE WHEN…
-
Row Count growth change
Trying to get the %change in overall Row Count DoD looking at today vs. yesterday. This is what I have but is not successful. Any suggestions?: (SUM(CASE WHEN DAY(`Snapshot Date`) = CURDATE() THEN `Row Count` ELSE 0 END) - SUM(CASE WHEN DAY(`Snapshot Date`) = CURDATE(-1) THEN `Row Count` ELSE 0 END)) / SUM(CASE WHEN…
-
how to get last full 12 month in beast mode
I would like to create a flag for the date for the last 12 full months, not including the current month. For example, as of now, I only want to show any dates are in Oct 2018 to Nov 2017. I used this one, but give me to the same date of last year. Thank you. DATE_SUB(now(), INTERVAL 12 MONTH) Olivia
-
LAG / LEAD function misses the last iteration
Hi experts! I'm using the lead / lag function in beast mode to find out the last row from each group of index rows simply by comparing the value of primary key of next/previous. It works accurately except it misses the last / first group (last when using lead and first when using lag). Here's my beast mode code: And,…
-
Filtering Rows without Displaying Them / Same-Store Comparison
I have a dataset of sales data with one record per store, per day, across multiple years. I used @jaeW_at_Onyx's offset date table solution to get YOY and POP comparisons; but I'm not positive that's relevant to my [hopefully simple] question. I'm trying to create a filter for same-store comparisons. I am defining…
-
Adding Hyperlink to table values
Hey all, Does anybody have any experience writing a beast mode formula to insert a hyperlink into a table value within Domo? Can't seem to get it right. Thanks in advance!
-
Convert all dates to last day of year
I am trying to convert all my dates to the last day of the year in a beast mode. I have a column in my dataset that is already showing the year for the data and have tried this STR_TO_DATE( CONCAT(`YEAR`,'-',12,'-',31),' %Y-%m-%d ') It doesn't seem to work. Any help would be appreciated
-
Beastmode Including exceptions to % calculation
Hi, I'm trying to calculate % right first time to remove exceptions ie where some "discrepancies" are right first time (RFT) and other classed as not RFT. However, I wish to include the data points from those which are deemed RFT in the overall calculation. This calculation works but doesn't allow me to exclude certain…
-
Excluding weekends from a prior day card
Hello, I'm build a prior day card that as name says will be depicting a prior day data. Business operates Monday-Friday but prior day on Monday would show no data since it is using Sunday's information. Is there a syntax I could write or other transformation that would exclude weekends from being included in last day and…
-
One of my bar charts won't display properly in the dashboard.
Hi, everyone! I have a card which shows up properly in analyzer, but does not show its bars in the dashboard or when I click into the card for a drilldown. The weird thing is, if I hover over another card as if to filter a time period, the data will show up. Our management and executive leadership regularly access this…
-
Equivalent of IFERROR(VLOOKUP,IF(RIGHT(- in Magic ETL
Hi Guys, Hope all is good. I am using Magic ETL and trying to create a flow replicating the current logic of my Excel file. In Excel I have 2 datasets. On the Main sheet a column is categorizing using the formula =IFERROR(VLOOKUP(value,range,exact Match),IF(RIGHT(Category,2)="AB","Above","Below)) Now in Magic ETL data…
-
Can I dynamically change chart properties when using DOMO variables?
I am using the variable feature to create a dynamic bar chart that updates to show various metrics depending on the selection made. All but one of the possible choices of metrics are measured as a percentage. However, one of the of the metrics is a count, not a percent. I have updated chart properties so it looks good when…
-
is there any way to move the "Totals" column in a DOMO Pivot Table Card?
the totals are the right most column in a pivot table card in ( by default I believe). Is there any way to move them to the second column? or to the left most side?
-
Fixed Functions for Identifying the First and Last Connections for an Entity
Hi all. I built the following beast mode to identify the first and last connection for an entity. It validates and works when I lay out the connection ID and the beast mode in a basic table, but it doesn't really work with any other visuals (I get error messages), and when I tried to use this to build a net new column in…
-
Daily Row count growth
What is the best way to show row count growth of a dataset day over day? Currently using DOMO Stats to show each datasets total row count I think I can create a beastmode for this, any suggestions here?
-
Beast Mode Manager shows deleted beast mode
I deleted a beast mode of card type from a card, and saved the card. This beast mode indeed does not show up any more once I opened the card. However, when I went to beast mode manager and this deleted beast mode still shows up. If I clicked it, I got an error like this: Something went wrong. Please try this after…
-
Getting the last field of a character-separated string
I have a field that has an odd structure. It looks like this: asdfas\\qwerqwer\\..\\vcbnvcn To be clear, the .. means that there's an arbitrary number of double-slash separated strings, not a literal double dot. Also, each field can be of arbitrary length. I need the last field. In the example, I need to return vcbnvcn.…
-
DOMO Groups filter
Hi DOMO Team - Good Day! I just need some help with regard to groups. we created a list of new groups for all our people and created a card to show all the groups that they are in and it shows that including the new group that we put them in. we would like to create a Beastmode where, when this person is in their 'legacy'…