-
Beast mode calculation
I want to create a beast mode calculation which should be something like this Value for current month this year - value for current month last year / Value for current month last year How can i do this?
-
Omitting rows in pivot table
Any way I can omit this section in a pivot table but keep the 2021 Total?
-
Totalling certain rows
I have a question about totaling data in tables. I have two sets of data from different time periods 2021 & 2023, and I'd like to sum the respective metrics for each. I have two different tables present that may aid in getting this solution done. For the first image I want to add a column after the 2021-12-01 column to…
-
Case Statement with YTD
Hi Folks, I'm trying to derive this through Beast mode calculation. Requirement: Case statement Score 1 - If my error % is 0 - 75% Score 2 - If my error % is 75.1% - 95% Score 3 - If my error % is 95.1% - 100% (Includes 100) Score 4 - If my error % is 100% (YTD) Finding difficulty in writing a case statement for 'Score 4'.…
-
Change value formatting based on KPI selected in variable
I have a card that allows the user to select which metric (Sales, Units, Margin %, etc) they want to graph by, using a variable control. Is there a way to force data formatting to be 'currency' when 'sales' is selected for example? Then when a user selects 'units', we'd want the formatting to now be shown as 'number'. With…
-
FIXED BY Beastmode trouble shooting
Something is not working quite right and I am having a hard time figuring out what is going wrong. We're trying to see the % of registrations by year, by day of week (sun, mon, tue, …), by hour of day, and then to be able to filter by locations. So in ETL, for the numerator, I am grouping by Year, DayOfWeek, Hour of day,…
-
What function will help me determine a variable part of text?
I'm using Magic ETL to create a new column that will return True or False depending on the contents of a string in another column. Question is how do I write a Case formula that will return True or False based on the contents of another column? For example, the word "Delivery" is placed in different locations on a string…
-
SQL partition password reset
Hi - I put in a help ticket without success so far. We are using a SQL partitions connector to bring in accounting data. Following an apparent password reset on database access, some of the datasets continued to work while some larger datasets stopped working but continued to bring in blank lines of data. I reset my…
-
Aggregate counts over time that keep a running total
I have an area chart where time is the x axis, and count of instances are the y axis. I want the count to be a running sum over time, but I am not sure how to do that in domo. See my image for details. (I don't care about the trend line.)
-
I am using this beast mode but it wont let me save the card
count(ID) over(partition by Clinic,Product)
-
Number format
Hello all, I am trying to replace the Number format in Card/Dashboard. For example: Number is displayed as 21K but I need it to be full number with comma separator. Or 1.19K should be displayed as full number instead of 1191? I tried all ways but it does not seem to change the format. Can someone help me with this?
-
Does Beast Mode support using "Contains" to Identify Value Count
Hey there… I have a field called PresentationName where we (unfortunately) use a text string as part of the PresentationName to identify a Type of presentation. Clearly we need to pull that out into its own metadata and will in the future. But for now, I need to find a way to create a calculated field that lets me get a…
-
Formulae function for table instead of line by line
I have two tables. The first table i have a list of telephone numbers. The second table, a list of the first 3 digits of the number. I want to qualify the first with the next. Here is my formulae: case when SUBSTR(Phone,4,3) not in(NXX) then 'no' else 'yes' END so this is fine in that it qualifies line by line. However, I…
-
Column created with Beast mode with numeric and porcentage format
.Dear community, this month I have receipt separately two cases with the same concern: The users have shown to me functions created with beast mode, inside a pivot table card. The goal is set in the same column figure with number format and percentage, including the symbol “%”. I have attempted so many ways, but I don´t…
-
Is the data restricted for drill downs?
I am building a drill-down but seem not to have the same options as I would building a separate card. Example: I have a stacked bar overview where I am demonstrating the cutomer base by volume over months and by customer types. I am trying to create a drill down where I am showing in a pivot table view where I want to show…
-
Is there a way to bucket columns similar to excel in DOMO?
I am trying to have a pivot table that shows weekly plans vs actuals. Is there a way to add a top layer of that to group the value columns into the top three pillars? Supply, demand, revenue. Thanks
-
Single Value Card Division
I have two single value cards. Card 1 is a overall total of all possible values and card 2 is a filtered subset of card 1. Is there a way I can divide the two cards? I know that you can just make a new beast mode with both calculations (Ex. Card 2/Card 1). However that does not work in my case due to Card 2 being a…
-
Reuse Beast Mode field in another calcuation
Requesting to allow Beast Mode field created in a card to be used in another calculation. This feature is currently available in the "Add Formula" function in Magic ETL but not for beast mode calculations done in Analyzer.
-
Expose date filter's start & end date inside beast mode
The date range filter will always have a start and end date. I would like Domo to expose that start date/end date inside a calculated field as variables. My workaround is to have the same variable for fixed date ranges (MTD, YTD, etc) This would not be the case if Domo exposed the date filter variables inside Beast Mode…
-
Grand Total summing the percentage instead of calculating
Every time we bring in any kind of calculated difference to the table, we get a grand total that sums up all the percentages. For instance, for this Table, the rightmost column is calculating the difference between the two left columns. Every row is correct except for the Grand Total which sums up the percentage together…
-
Is there a way to store a beast mode in a filter on a dashboard?
Is there a way to instead of having the beast mode in our cards for the guage multi value visual (Impressions, Web Page Visits, Visit Rate, etc.), have it in a filter that links to the cards in the campaign? Instead of having a static last 30 days vs previous 30 days, our client suggested that it would be great if there…
-
Case statement with multiple conditions
currently I have this query and I have 16 exclusion reasons. Is there a more efficient way to write this beastmode? CASE WHEN exclusion reason 1 IS NULL THEN CASE WHEN exclusion reason 2 IS NULL THEN CASE WHEN exclusion reason 3 IS NULL THEN CASE WHEN exclusion reason 4 IS NULL THEN CASE WHEN exclusion reason 5 IS NULL…
-
Lag Function Giving me Values that Don't Exist?
I'm trying to create what should be a simple table that shows job Last Quarter Salary, This Quarter Salary, and Percent Change. However, my Beast Mode is giving me values that aren't even on my table. The Current Salary is displaying fine, but the previous quarter's salary is giving me a fictional number. Here's my formula…