-
How to set up a Future Date Filter
I'm trying to figure out how to set up a beast mode that will allow me to filter out historical dates while keeping the Date Range open to Current FY. I feel like I almost had it with the below calculation, but it's cutting off anything that is scheduled after this current week time period in future months: case when…
-
Conditional formatting of Columns in a table view card
We need more options to format columns in a card table view. In particular the ability to colorize a group of columns that are in the same category, ex. Admitted 2016, Admitted 2015 Admitted 2014, Inquiry 2016 Inquiry 2015 Inquiry 2014
-
How to calculate usage %
This is what I have: Content ID and Product are meta data for a full list of documents. When an user used a document, such as download, viewed etc, there is a record for Library ID, user role, and user region etc. When there is no Library ID, it means the document has not been used. Now the stake holder wants to see the…
-
BeastMode: Field contains lower case
Working on a exception report where item descriptions in our item file contain a lower case character. Logic would work like this: case when `Description` LIKE '%[lower_case]%' then 'Yes' else 'No' end Thanks!
-
Filtering beast modes using Card Start and End Date parameters
Hey Dojo! Long time, no talk. I'm back with an issue that's giving me one of those awesome tension headaches. Maybe y'all can help me out. I'm building an opportunity progression dashboard for our sales team. What the data looks like at the basal level is this: (Coming out of salesforce) Opportunity Name Record Insert date…
-
Sum and Avg calculations don't do anything
Hi all, I've been using Domo for a while now and consider myself a decent-to-good user. With that said, I have never been able to make anything useful with the sum and avg functions in beast modes. To the best of my knowledge, they are completely useless, or broken. Anybody else feels the same way? I would definitely…
-
Calculate average age till Last month, Last week, last year.
Hi Team, I am need to compare the average age for the current month and previous month . Now, the card that I am using to show this is comparative gauge which will display if the metric is trending up or down. So, I tried to calculate the average age for previous month in beast mode but did not work. Can anyone please help…
-
Extract 1 row / few rows from big dataset (>100M rows)
When I try to extract the _BATCH_LAST_RUN_ from a MySQL dataset with 106M rows, the ETL takes 3h20min. Is there a way to extract only one row from the dataset. For the moment, I have to wait until the full 106M rows dataset is load in both Magic ETL and SQL.
-
Finding the latest date with specific criteria
I work in the training area at my organization. We are trying to determine "What is the latest date they have completed all of their required training?" For example, a new agent comes in, and they are assigned Program A, Program B, and Program C. We want to know what the latest completion date is when they have completed…
-
MySQL query for YTD Running Total
Hi all, I'm having trouble creating a mySQL query that does a running total by a certain Group By dimensions. Here is a sample structure of the data: datestoreChannelVisitsYTD…
-
Role Permission needed for PDP Use
What permission is needed for a user to use PDP on a data flow? Our users do not have Can Manage Data Set or Data Flow because we update and manage them on their behalf. Is that what is needed to use PDP?
-
Surveys in specific Date Range
Good morning, I currently have a dataset being created from our Qualtrics connector that counts the number of surveys and averages scores from specifi questions in a given time period. The time period we go off of would be between the Last Day of the Quarter (Period End) and 180 days before the Last Day of the Quarter…
-
Magic ETL Efficiency
Hello, I have a simple Magic ETL that I use to filter a dataset from our company's source system to only show the latest version of each record. The dataflow finds the latest timestamp for each record, then uses an inner join on the record ID and timestamp to only include the most recent row. I've attached a screenshot of…
-
Floating integers / Floating decimals, rounding
How does DOMO's version of MySQL handle floating integers when rounding? I went to round a field in my Dataflow. So that I could avoid changing 50 cards and removing the decimals in this feild. Round(`Trans`,0) When aggregated in the card I am showing my total trans is far lower than it should be. opposed to a bit higher…
-
Beast Mode Manager Tab
Hi, I was reading an article about the Beast Manager tab (https://knowledge.domo.com/Welcome/Domo_User_Interface/Data_Center_Layout_(with_Beast_Mode_Manager)#Beast_Mode_Manager_tab). But when I am looking in my Data Center I cannot see it. Do you have any idea how to access it? Thanks!
-
FB Ad Creatives - Images in cards
Hey all, We are trying to make a table card and display the ad creatives for our FB ads, images in the table card. I have brought images into DOMO before however we are trying to find a configuration of the FB ads advanced connector that can do this. Is there any way to bring in the URL with the existing connectors?…
-
Beast Mode in Pivot Table beta
Hi All! I created a card using one of the new pivot table options. When I use a beast mode in the table it does not seem to be able to calculate the sub-total correctly. My beast mode is a simply divide field A by field B. Does anyone have a work around/solution for this issue that can be resolved in the card itself? Thanks
-
Actual Data to Budget Data
We have created a data fusion where we have actual metrics. Example count of registered donors in fiscal week 14. In the data fusion we added budget data to say we budgeted to see x donors in fiscal week 14. We are now looking for a solution to be able to display the two together in a grouped bar chart. Any help is…
-
Change Column Name in a Dataset
Hi Guys, Is there a way to change the column name in a dataset? I'm using Informatica to load in my datasets into Domo. I know you can create an ETL flow but the dilemma I'm facing is: I have a dataset (Dataset_A1) which had 4 columns, account | record | id | amount_given I created a dataflow to edit the column names &…
-
Use ETL to make calculated column a measure
Hi there I had a measure of DELAY expressed in words in my input file. This cannot be changed by me. I used beast mode to create a new column with the word changed to a number and I called this column DELAY2 However, this column is still be treated as a dimension And if i open workflow to change this in ETL, the calculated…
-
Rounding Decimals in ETL, not in Beast Mode
Hi there, I'm working on ETL right now, I want to rounding a column which is in decimal. Our a goal is create a new Data Flow from few files, then from that Data Flow make some cards. So, is there any help us to rounding in ETL Transform ? Thanks.
-
ETL Transform - Free Trail Version
Hello Experts, I am new to DOMO and trying to explore ETL Transformation. I am using a simple replace transformation and getting the error
-
Converting a beastmode text field into a number field
Hello, I am struggling to get the values my beastmode returns to display in the correct format. To summarize, I'm looking at blood draw times for donors. The data comes into Domo as phlebotomy start time, and phlebotomy end time (which are both date fields). So, I made the…
-
Beastmode Trouble - Getting a unique count of 2 based on 2 columns in 1 row
Hello, In this scenario, each donation id is a unique value and is 1 row. Each donation id has 2 columns: HGB and HGB2. If HGB is not null, that means the donation id received an HGB stick. If HGB2 is not null, that means the donation id received a second stick. If the fields are null, the donation id recieved 0 sticks. In…
-
Case Statement Help - Condition not being passed
Hi All, I've been struggling with this absurd problem when creating a beast mode calculation using case statement. Basically I'm trying to pass 2 conditions into my case statement but for some reason, even after validating the formula, only 1 condition is passing. My calculation is: (CASE WHEN YEAR(`transaction_date`) =…
-
Providing a True/False(Y/N) if text in a comma separated string is in a separate column
Hello, I have data that looks like this and the goal is to validate if the order season is in the selling season. I tried like but it didn't seem to be consistent. Any help would be appreciated. Order SeasonSelling SeasonsGoal18SP18SP,18SU,18FA,19SPY19FA18SP,18SU,18FA,19SPN18FA18SP,18SU,18FA,19SPY20SP18SP,18SU,18FA,19SPN…
-
Regex to Only show data before a certain character
Hello, I have data that looks like this: line_items_nameGoalBanks Short | Navy Camo - Navy Camo / SBanks ShortsThe Rise The Shine Tee | Charcoal - Charcoal / LThe Rise The Shine TeesClassic Vuori Tee | Heather Grey - Heather Grey / SClassic Vuori Tees I want just the items to the left of the | to show. How can I achieve…
-
Adding up values based on a date range
In Beast mode how would I add up criteria in another column based on a date range? Refer to my attached picture: I would like to have a pie chart for 2019 and 2020 that adds up the various values based on a date range.
-
Time Zones
How do I change the time stamps in my postgresql data from UTC to EST? Saw the convert_tz() syntax from Domo but that's for mysql. Not sure where I should run this and how. Thanks!
-
How to create a Beast Mode calculation for fiscal year using a date field?
Hi All, I have a unique dilemma. I need to create a beast mode calculation to calculate our revenue for the latest fiscal year. I know I can just manually add the date filter criteria into the calculation or add a filter but the thing is the data is updated every day and we need the date filter criteria to be dynamic &…