-
How to add multiple Name Columns to a custom chart
Hello! I have uploaded an svg with a custom data diagram. Within the diagram and within my data there are 2 columns (component and connection) that I would like the names to be displayed and the colors to be highlighted. However, it is only allowing for 1 name column. Is there any way to add another? Thank you!
-
Ignore filters + include ALL entires of a specific measure in a formula, but filter other measures
I am tracking performance of a manufacturing process, and the various reasons parts get rejected. I can easily chart (Parts Rejected)/(Parts Run) aggregated by day for a reject rate, but I would also like to be able to separate the reasons out as a series. The formula I am after is then: (Parts Rejected by Filtered…
-
Comparing beast mode calculations and resulting in a string
Due to confidentiality reasons, I'm trying to create a card where it shows if a student has Completed or Not completed a series of tests (we don't want to reveal their actual scores). The Complete/Incomplete column keeps showing as Incomplete no matter what I try to do. I tried switching it to Integers (Complete = 1,…
-
Creating a Card Deep Link Beast Mode - Multiple Filters
Have been searching the Dojo and KB this morning for info on this and I'm not finding the solution. Also, not seeing documentation on Card Deep Links (do see for pages) - is this still supported? I have a card that shows inventory information and users are asking for a way to "see" who is buying the inventory most often. I…
-
Shape card image size reduction on selecting background color
Hi there I see that in the shape card, the size of the image changes if I select a background color. I would want to select different backgrounds to separate out KPIs, but apparently it is not possible. Am I doing something wrong? Regards
-
TOP5
Hey Everyone! I'm here again to use your brains! 😁 Our team is trying to visualize a simple TOP5 of interprise partners considering the total sales of each and we need to see that by month for the past 2 years. We already did this: Beast mode code for ranking: The ranking beast mode is working properly when we use a table…
-
Beast Mode Calculation Subtotal/Total
Hi There, I have a beast mode calculating utilization and I want the calculation to occur in the subtotal and total as well however it is not doing that for HTML or Mega Table. It appears to be Summing or Counting. Can someone please assist? Please let me know how I can rectify this. Thanks!
-
Multi-Value chart percent change error?
Hello all, Wondering if there is a way this value is calculated and where the error could be. Chart 1: Current Month - Value 94.83 | Change is -0.62 when compared to 1 month ago (aka previous month) Previous Month: Value = 95.42% Difference Actual: 95.42% - 94.83% = 0.59% Why does Domo calculate this as 0.62% and this…
-
Card filter not showing all options
Hi there I have a card looking at the email domains of users. I want to filter out public domains like Hotmail and Gmail to look at institutional users. The filter is only showing me A-H of what is a long list. Is there a way to get access to the rest of block the domains I don't want to see?
-
Total row sum % instead of doing the % calculation
Hi, I use one beastmode to give me the MTD % of achievement vs the MTD Target. On one card it work with this rule : sum(`product_A`)/(SUM(DISTINCT `product_a_Target_dly`)*DAY(CURDATE())) So it's giving me the MTD % even in the total row. I use the same formula on another card but with product_B.... and the total row show…
-
Beastmode for Week starting Monday
I have a colleague whose reporting week starts on Monday but our Domo instance starts our weeks on Sunday (and needs to stay that way). Most of their reporting is looking at the previous week's data and they are not the only person using the dataset so I can't adjust the dataset. Is there a way to write and a beastmode as…
-
Can you Insert multiple X-Axis?
I'm attempting to build a new chart where there are multiple columns with a single value for an individual. I know this isn't an optimal data set, and I've reworked it for another dashboard, but I would like to keep it in this format if possible. I believe other data visualization tools allow you to add multiple x/y-axis…
-
KPI Table
How do I create something like this in DOMO? Each row has different conditional formatting rules. Please help.
-
Division by Zero ETL Formula
Hi everyone, Can someone help me with this issue... trying to input a formula in Magic ETL and I got a division by zero error. How can I rectify it? I know in some cases the divisor in my calculation will be 0 but that is okay. Case when `ServiceName` like '%Manual_Only%' then (`InCallMin`) /…
-
Waterfall Chart with Variance Analysis
Hi All, Is it currently possible to build a waterfall chart that refers to three separate beast mode calculations (1 calc for each variance)? I can do this easily in excel but I'm struggling in Domo. What I want to show is (all in $): July FY21 - Price Variance - Volume Variance - Mix Variance - July FY22 Any help would be…
-
YOY & Net diff Beatmode calc
I have kind of a unique YOY period that I am trying to create a report around. I am taking counts of leads that come through different marketing 'Marketing Sources', and only looking at the past 15 day window for each. This is straight forward. Take the counts for each source in the `Marketing Source` columns and use the…
-
Filtering using BeastMode with a plus
Hi, People! We have a uncommon situation here. We receive a dataset view by Snowflake with raw data and aggregated data and they are distinguished by a filed named "Data Type" 😶 Anyway, We have metrics in beast mode that look to raw data to calculate numerators and others that calculate denominators looking the aggregated…
-
Add Time to Datetime
I have two columns `timePlaced` is a datetime, while `timeEstimate` is an integer that represents minuets. Using the below beast mode I am able to convert `timeEstimate` to minuets, ex 10 turns to 00:10:00. SEC_TO_TIME(`timeEstimate`*60) When I try to add it to `timePlaced` using the fowling beast mode I get null values.…
-
Dynamic summary title based on date range
Hi , I am looking to display previous two quarters as a summary (e.g jan 2021 to june 2021) and I want this to be dynamic . The issue with my current logic is that it always considers 6 months ago as starting date. For eg for August 2021 - it shows feb 202 to july 2021 while I need it to show jan 2021 to june 2021. Any…
-
50K Row Limits
Hi, I'm trying to share a card with some of my users so they can download the data and when they export it to excel it looks like it is capped at 50,000 rows in excel and 25k rows as a csv. Some of my dashboard cards contain more rows than this so is there a way around it? I can't share the full data set with my users…
-
COUNT(DISTINCT *) desconsidering only one filter
Hi, People! I'm here again! The DOMO noob! 😊 I'm stuck with the beastmode problem: Imagine that i have 4 cities e each one of it has a N number of reseller points. In my table, i need to show that N number of reseller points considering all the filters of the page (globals and selections in cards) into one column and in…
-
How can I fix this Beast Mode Window Function to display the proper value in the total row?
I have the following table that is using window functions in beast mode to calculate pipeline coverage. I have these window functions for calculating the visible visible columns: Pipeline/AOP SUM(CASE WHEN LEFT(`Stage`, 1) != '7' THEN `Pipeline` END) / MIN(`AOP`) OVER (PARTITION BY `Selling Lane`) Late Stage/AOP SUM(CASE…
-
Flex Table Sorting by Pct Change
Is there a way to sort Flex tables by the % or value change? I want to show the top 20 rows that has the highest % or value change. I only see the option to sort by total which doesn't work for my use case. Thanks
-
Data label on Variance graph
Hello, Is it possible to change data labels on a variance bar line? Can't seem to find any option to do so. Thanks!
-
Changing Background color of a cell based on other cell
I have this beastmode formula going right now: CASE WHEN SUM(`Real Time`) <= `Today Goal` THEN concat('<div style="background-color:red; color:white; margin:-20px; padding:20px">',SUM(`Real Time`),'</div>') ELSE concat('<div style="background-color:green; color:white; margin:-20px; padding:20px">',SUM(`Real…
-
Dynamic Text to work with Global Page Filters
Hi, I am trying to create a dashboard that has data from various datasets but each dataset has its own date column. I want the dynamic text to work with the Global Date filters - not finding anything within the knowledge base of this. I've found if I clicked on a specific graph with the month it would drill down the data…
-
Does anyone know how to build this card in the covid dashboard?
Does anyone know how to build this card?
-
measuring cross-purchase with purchase category in both row and column
I'm trying to create a table that shows cross-purchase with customers, so what customers who purchased in one value of a dimension also purchased in a different value of the same dimension. Kind of like those old distance charts that have different cities plotted against each other on x and y axis, with the count of…
-
Problem with showing top-n results in an horizontal bar chart with series
I have an horizontal bar chart. Let's say the Y axis is factories, while the X axis is number of incidents in each factory in some time period. I want to show only the 10 factories with the most incidents, sorted by number of incidents. When I'm not using any series, the simplest way of doing that is to sort on COUNT of…
-
% of Contribution
Hi, I try to show the % of contribution and need some help with the beast mode. Right now, I have a Pivot table. Store are grouped by Sales Leader and the timeline is "This Year, By Month". I want to show the % of contribution of the store, in the Sale leader group and see evolution over month. I have try this beast mode :…