when I create a calculated field using this formula and this is created as Ranking CASE WHEN RANK() OVER (PARTITION BY SUB_CATEGORY_TXT ORDER BY SUM(SALES_LC_AMT) DESC) >=6 THEN 1000 ELSE RANK() OVER (PARTITION BY SUB_CATEGORY_TXT ORDER BY SUM(SALES_LC_AMT) DESC) END now when I drag and drop Ranking to filtering, it says…
Hi, I am trying to figure out what the best way to create a running sum would be. I know there's an option on a table, however, I am trying to create a line bar. Would the best way to go about this in an etl or a beastmode? For example 1-30-24 should be the sum of 47780 + 42874 instead of just the 1-30-24 revenue.
Hi I'm trying to create a Rank, but sometimes it works others it doesn't don't know why, I have customers and I want to be able to filter by the top 5 customers based on Shipments I have tried multiple formulas and the validation works, sometimes the table works but the filter does not work: This are the formulas I have…
I would like to create a beast mode that calculates the % of the way we are into a campaign. In Excel, I would calculate this as =(TODAY()-'Start Date') / ('End Date' - 'Start Date') Here's what I have so far (I want this to return a %): (SUM(IFNULL(CURDATE(), 0) - IFNULL(`Start Date`, 0)) / NULLIF(SUM(IFNULL(`End Date`,…
I have 2 Beast Modes that are returning inaccurate results. If I place each Beast Mode in a separate column in my table, they both return their respective values of 01 or 02 for every line even though they are opposite and even though not every line meets either criterion. Any suggestions? Thanks! CASE WHEN GL Group Code…
I am trying to create a calculated field that will give me the percentage of share for the column total i.e. taking the unit from one data point of measure and dividing that data point by the total of that measure. Is that possible?
Hello everyone, I am trying to get an accurate count of the number of blank cells for a column inside an ETL prior to using a formula to estimate the date in the event that it is blank. I included a test output dataset inside the ETL to track the number of blank cells as well the estimation before/after creating a new…
I am working on Turnover metrics and need to capture the average unique headcount of employees over a user selected date range. Here is what I've tried, but Domo keeps giving errors: COUNT_DISTINCT(CASE WHEN (Team Member status = 'Active' OR Team Member status = 'Unpaid Leave') AND Date BETWEEN 'start_date' AND 'end_date'…
I am attempting to create a Turnover Rate beast mode that would take the Average Distinct Count of employee IDs, then divide it by the number of days in the user selected date range. I've tried the following syntax, but I receive an error: Raw syntax: AVG(COUNT(DISTINCT CASE WHEN Team Member status = 'Active' OR Team…
Hello, sometime ago I noticed that when I am trying to update the existing beast mode calculation on validation step it shows me error message "Calculation error: Duplicate calculation name". The calculation itself is working and when I create a new calculated field with same formula but with different name I can validate…
It looks like you're new here. Sign in or register to get started.