-
multiple Groups shown in just one column
Hello DOMO - Good Day! I am using the Data governance dataset that has the users and groups. what we wanted to show is the pages/dashboard and then all the groups that can view it. currently, I can show the different pages and the different groups in different columns. just wanted to know if we can show all the different…
-
Variable names in String
Hi, The current variable selector accepts the values either in Default (Numeric) - Gives a comma separator automatically. Percentage Currency - Adds $ as prefix. Do we have any work around to avoid comma? Do we have any work around to use other currency symbols as prefix with currency format?
-
Calling all Windowed Beast Mode and FIXED Function experts!
I think I'm close on this but am struggling to get my expected result. Here is my end goal—a chart showing data by date, with a line for the "Best Ever" value. Things making it tricky: I need the date range to be dynamic, i.e. user can select different dates I need the "best ever" value to be pulled from across the entire…
-
Calculation of previous dated values
I am trying to calculate trailing period (previous period) calc. I have year(variable selector), month(dropdown selector chart using column from table) If i select Year = 2024 and Month = Feb, I should get the data for 2024-JAN. Tried this formula but failing to get the correct figure. RecordDate(date format col) is…
-
Multi value comparison
Hi, I am configuring a multi value comparison card. I have Sales column which is being configured in Gauge Value. In Comparison Value, I want to input the value of Sales Column itself but of previous year. I want this comparison to be dynamic because on my dashboard I have dropdown filter (Year, Month, Quarter). So if I…
-
Dynamic data comparison
Hi, I want to perform QTD, YTD without using Domo inbuilt features dynamically. Like, I will have a dropdown for Year using dropdown chart using the Year column from dataset. And variable selector for QTD, YTD. User may select any of the variable selector and any one year from the dropdown. Example: Variable Selector : QTD…
-
Median Value in Total Column
Hey all I'm creating a heatmap visual that compares our engineers' ticket cycle time against projects and uses the median value. When I add a total column to the graphic, the column sums the values above instead of calculating the median across all projects. Can the visual be adjusted to calculate an overall "Median"? ref:…
-
Display state selected
Hi, I have a map card which has the values populated for all states. I would like to display the selected state name in a text box. However, I noticed, when no state is selected, the text box displays the state name which is in the first row of the data which is misleading. It should either be blank or print some message.…
-
Reset filters on action or event
Hi, Can we implement a Reset all filters(global & custom) whenever user selects OptionB from OptionA in the variable selector? Variable selector values: Option A, Option B. Global Filters: Geo, Region, Type, Mode. Thanks in advance :)
-
FIXED Function Documentation: FIXED Add Label?
In the kb article for FIXED functions, an example for FIXED ADD is shown where the City dimension is added in the calculation. This is straightforward, but what I can't figure out is: how on earth is the user displaying the name of the city on the chart? Obviously the function will return the value: MAX(SUM(`Total Sales`)…
-
Calculate Sale Frequency
Attached below Sample data. The database table has location and sale date fields. I need to calculate Sale frequency report, which mentions if a particular location has a Weekly sale, bi-weekly or monthly sale wrt to the Sale date. Appreciate your help on how to calculate this in Domo? Thank you
-
Control Chart Type via Beast Mode
With the recent enhancement around beast modes that allows a beast mode within a beast mode it has become easier than ever to utilize variables to control x-axis, y-axis, sorting, filtering, etc. through beast modes. With that limitation out of the way I believe the next logical enhancement would be to add a Chart Type…
-
SUM('Revenue') BUT IGNORE ALL FILTERS PLEASE!!!
Hi all About to through my Mac through the window if I can't sort this. How do I write a Beast Mode that sums data whilst ignoring ALL filters? Many thanks
-
Beast mode for the substring_index
I'm trying to extract the substring from an URL. URL: www.ab.com/level1/level2 I'm looking taking the level2 out of URL. What is the beast mode formula I can use here? I want to get: level2
-
Calculating Percent of Total, and Getting Correct Totals
I have this table where I'm using count(distinct()) to get counts of various attributes, but when I add a "Percent of total" column to each one, the percentages add up to more than 100%. In addition, my totals at the bottom of the counts are incorrect. I've attached a screenshot of the issue along with an example of the…
-
Beastmode field not aggregating in bar chart
I have a dataset containing the following data: The Sessions field is a beastmode calculating the rank of the customers phone number. (Running total of how many transactions they have) rank() over (partition by Location.ID, PhoneNo order by TransactionDate) I am wanting to create a horizontal bar chart with the number of…
-
Beast mode calculation: Last compared to past average?
Hi - I'm trying to figure out the calculation to identify an action needed. I know how to do in Excel, but still learning the SQL / Beast Mode equivalent. I have a count of total items. If the count of total items from last week is 20% less than the average count of total items from the past 6 weeks, I want it to be marked…
-
Division By Zero - Be Aware - Failed IFERROR, IFNULL, and GROUPBY
When you're performing calculations over 100s of millions or records sometimes you come across division by zeros in which you're hoping the software you're using would manage accordingly, I ran into a scenario in an ETL scenario where it lead to having more than a 10% revenue shortfall in my numbers. Generally in Domo if…
-
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…
-
Rolling Averages Feature
I was looking for a more flexible way to create rolling averages. Of course possible in a Domo Dataflow/Magic ETL → but then you need to fix it on the periods you want to "roll over". Is it possible in a beast mode or is there maybe a card type/feature that makes it even easier?
-
Beast mode referencing
Hello, I wonder why this won't work. I get that the CASE WHEN can't have MAX() within it, but I thought by referencing the beast mode that uses the MAX() would process it as a subquery that references the output value instead of the formula MAX(). If this wouldn't work, is there an alternative to this? I needed the…
-
Nested fixed functions
Hi All - We are using fixed functions to calculate the average LTV per year for certain audiences. In the end, we want to be able to sum up the averages into a total 4-year LTV for the audience, which requires another fixed function. However, we're hitting errors when we wrap our calc in the new fixed function to sum up…
-
Returning the number of days in the selected date range
It would be great to be able to call for the specific date range (and number of days) selected in a beast mode so that my visualization would dynamically update the calculated field as the date range was modified. My recent use case was a turnover rate calculation where I ultimately had to divide by the number of days in…
-
Branching/Hierarchy in Pivot Table, Mega Table
Hello, Is there a more elegant solution to create Branching/Hierarchy in a Pivot Table (or any other table)? Something to look similar to this: This was created using the Formula Editor in ETL, but I don't like the solution and was hoping for something more elegant and flexible:
-
Run rate beastmode calculation
Hi all, trying to formulate a beastmode calculation to give me weekly run rate so I can do a WoW chart. No matter how I modify the query, I keep getting a "Calculation Error : All fields must be aggregated or in the group by clause". This is the first time I am seeing this error. Any insights and advice would be…
-
Starting Day of the Week - Monday
Hello, can anyone help me find a solution on how I could start with Monday for the weekly data? My data is dynamic, so it has to update on a weekly basis - I used Last 4 weeks. I have a table with weekly data showing like the one below, and when I created a bar chart in DOMO, originally, when graphed weekly, it will start…
-
Dynamic Goal line on a bar chart
I need to create a goal line dynamically on a bar chart. I have used scale marker in properties, but it is giving a static line. Can someone please suggest how can we achieve dynamic goal line. Thanks
-
Need help with Date Range/ Period to Date
As you can see top right, Domo has a selection Date Range, Period to Date, and if I click on Week to Date, my 3 cards will update date dimension to current Week to Date, Month to Date, Quarter to Date. I'm trying to create a filter or a button to do same functions Period to Date: WTD, MTD, QTD, YTD without clicking on Date…
-
Beast Mode Syntax
Hi, I am trying to create a column that shows the year that a financial instrument was created and then I need to add 3 to it. It is going on the bottom of the x-axis so it will show up like '2022-2025' , '2023-2026', '2024-2027', etc. The problem when I go to write the beast mode below is that it thinks it is a math…
-
Dashboard Table using previous day values in calculation
Hi, I need to create a Dashboard that calculates oil usage for Engines. Below is the excel table with calculation I need to recreate in Domo. Basically need to take the tank level and oil added to day tank and engine from day before and subtract today's tank level to get daily usage. Also sometimes there wont always be a…