-
Filter top x per id
Hi All, I will just draw this as it will be easier to understand. I have alist of account with revenue atatched per country bu I only want to show the top x countries in revenue (top 2 in the example below). My tab is already sorted by Account and Revenue: Here is what it looks like now:…
-
How to merge two rows in one?
Hi, Let me show you what my table looks like and what I want to achieve this should be the easiest way to explain: Account SubAccount Integration AccountA Subaccount1 IntegrationA AccountA Subaccount2 IntegrationB AccountB Subaccount1 IntegrationA I then want to create an additional column in beast mode that checks if…
-
Combine multiple distinct rows values in one cell
Hi, I am trying to combine the distinct value from multiple rows in a column with Beast mode. Here is an example of my file: Field AField BFieldCA1111A2222A3333A4333B5111B6444C7555 I would like to have: Field AField BA111, 222, 333B111, 444C555 In this case I have a concat but I would also need to do a distinct sum…
-
Calculating Score Domo with Variable
Hi, I am trying to calculate a score from different fields using CASE in domo but it seems we cannot use variables in beastmode and I am facing dificulties. Each of my columns have values which I want to translate into a score and then sum up the final score for a line. ie: If Field1='1" Then score=20 + If Field2="Yes"…
