Community Forums

Discover best practices and find answers to your questions with advice from fellow Domo users.

Recent Discussions

Calculating percentage in beast mode based on count
Hi, I have a dataset that looks like this: Network Hour Date Avails A 1 1/1 2 A 2 1/2 4 B 1 1/1 6 B 2 1/2 8 C 1 1/1 10 C 2 1/2 12 C 2 1/2 12 The number of avails is the same for every row that has the same network, hour, and date. I need to write a beast mode that calculates the number of different rows that have the same…
Count of ID when condition is met
Hi guys, I hope you are able to help me with the following situation. Example: Customer ID1 — Customer ID2 — Status — .. ABC — DEF — ACTIVE ABC — GHI — ACTIVE LMN — OPQ — ACTIVE LMN — RST — INACTIVE Basically I have two IDs per customer, I now want to get a COUNT of "active per customer" but ONLY when Status = ACTIVE. My…
Creating a Beast Mode to calculate field sums for remainder of year
Hi - I am trying to write a beast mode calculation that sums a field from an as of date until the end of the year. The variable is indexed across the year and want to count how many are left depending on what date is entered. For instance if 1/22/24 was the date it would count all the values indexed for the variable until…
Beast Mode: Count IF for user_id based on another column
Relevant columns in dataset user_id: unique identifier badge_level: a number from 1 - 4 user_badge_id: another unique identifier. Each badge earned generates a unique id I am trying to create a new column that counts the # of Level 3 badges the user has earned. Then I will create a Beast Mode to calculate the following %…
Case Statement with Count Distinct
Hi I am trying to write a case statement to find how many individuals are admitted (so admitted = admission date present AND discharge date and decreased dates are blank). I have this so far: Count (DISTINCT Case when (STATUS = 'Admitted') AND DISCHARGEDDATE IS NULL AND DECEASEDDATE IS NULL THEN IDFFORMID END I want to…
I am trying to remove duplicates so that I only count the result of the last batch run
Hi can anyone tell me how to write the forumla for this? I tried to add a formula to the ETL but did not know what formula I would need as I wasnt successful with any I tried and I'm a novice! 😪
Counting rows with a specific numerical value when using 'Group By'
Hi there - I'm new to Domo so apologies if this has been asked before and I have been unable to find the answer. I am using the "Group By' function in my ETL and in one of my aggregate columns I want to show the count of all the rows that have the numerical value of 80. I have tried the formula COUNT(`ptstatus`= '80') and…
How to represent how many tickets opened by each individual user?
Hi, I am trying to figure out how to pull 2 datasets together correctly. So, one dataset is Users and the other is Tickets. I want to connect Tickets to Users so I can have a single integer connected to a single user to show many tickets a specific individual has opened. Example: User_Name Number_Of_Tickets_Opened…
Aggregate count function does not work in the denominator
When I use the following statement in a card summary, it works properly. But when use it as a value in a Single Value card, the count function doesn't work anymore: SUM(CASE WHEN ROUND(100*`Score`/`PossibleScore`)>=60 THEN 1 ELSE 0 END) / COUNT( `AttemptNumber`) For more context, the Attemptnumber column has 450 rows where…
How to group rows and make columns that count specific values?
Hi! This is a difficult one to give a title but basically, here is what I am trying to do: I have a dataset that combines a dataset of user profiles and a dataset of our assets that are assigned to each user. What this does is make it so every single entry for a user's individual assets gets its own row. So basically, if…

Welcome!

It looks like you're new here. Members get access to exclusive content, events and more. Sign in or register to get started.