-
Period Over Period Nested Bar
Hey guys, I'm trying to create a week over week bar graph that shows the next 7 day production vs the last 7 day production. That is the easy part, I'm also trying to group the bars by our different locations. Below is an image of what I have so far. Is there an easy way to split up those total production amounts into our…
-
How to Create Monthly Averages for Headcount?
Hi All, I'm in the process of building an attrition model in Domo in the form: Total Terms / Average headcount Terms is easy, that's just a count of everyone with a term status for that time period. Headcount is where I'm getting stuck. My headcount numbers are currently aggregated based on headcount at the end of each…
-
Comparing two dataset outputs
I am trying to find a solution to compare output of two datasets. Both have same columns and same timeline but I want to create a flag if there is any difference in any of the col when we compare both outputs.
-
is there an easy way to not show zeroes??
I have a table that consists of inputs from 3 different sources. What I am running in to is more of an esthetics issue that I am hoping to clean up. I have areas where a zero appears, and other spots they don't appear. The data are all integers so i understand why there would be zeroes showing but confused why it shows up…
-
Is possible to use text values in a pivote table?
Hello! I am trying to create a table like this in which the values are a text field. I am using the pivote table that allows me to create the headers the way I want them but I think this type of chart only allows me to use numerical values. Is possible to use text values in a pivote table?
-
Division by Zero ETL error
Hello Can someone help me with this error... I am inputting a formula in Magic ETL and am receiving 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 fine. An example of the 2 formulas I've tried below. Thanks for any insight. IFNULL(`Total…
-
refresh interval
Hello everyone, is there a way to set-up the card auto-refresh interval once the dataset has been updated, and which is the default one,? I'm experiencing refresh interval form seconds to minutes, so I'd like to have a more linear behaviour of the system. Also: using Domo Everywhere is there more flexibility about page…
-
Align headers to bottom
Is there a way to have the column headers positioned at the bottom of their cells?
-
Alert message for card is not supporting the card filter
Hi, I am facing an issue with the alert message. In the card, I have a filter for date, which is 2 day lag from current date. So that I wanted to get the alert by showing the data for 2 days lag. I have checked the option for filter in the alert rule part and even though when data gets updated, the alert is showing the…
-
How to SUM working days correctly?
Hi everyone, I have a strange problem. Probably more of a SQL question than a Domo question, but here we go. I have a typical date column (yyyy-mm-dd) and a column called "total working days in month" where it returns a aggregate value of the # of working days for each month. Below is an example (just assume every date is…
-
Percentage
Hi, I'm trying to create a card which tells when someone has marked all the documentation. I have created an ETL to count the Numerator & Denominator I also created a column for percentage which is showing correct see the picture below. The 1 is 100% and anything below it's shows 0.85 and so on. But when I use that column…
-
% of contribution
Hi, I try to build a card where I can view the individual contribution over the total from the sales leader, for the month and where we view each month of the year. So I have a pivot table. Date view is This Year. Row : Sales Leader, Reps Column : Month Value : Sales, Contribution. Right now, I use this rule in my beast…
-
Grouped Bar with two categories and trend line
I am trying to create a bar chart with two categories, quarter and region, and then show a trend for each region across quarter. I am able to that by using a Grouped Bar chart with 2 Categories and a Series. But then I need to add a line that shows the average across quarters for each region. The chart would look like…
-
Domo Maps
Does anyone know how to get DC to show up on a US map in Domo?
-
Grouping by client_id without losing row data
I have a table of client purchases with columns: sale date client ID sale total I'd like to group by client ID so that I end up with total sales for each client however when I do that in the data flow, I lose all date information for the sale. When I use a date formula to pull out sale year and include that in my grouping,…
-
How do I add a stacked bar chart that shows month-to-date compared to last year?
I have a stacked bar chart that has each category broken down into available inventory, unavailable inventory, and on floor inventory. Basically I would like this chart to keep its format, but I would like to compare it with last year. The period-over-period charts that I have messed with have dramatically changed this…
-
Activation Time <10
I'm trying to get a percentage of less than 10 mints, in dataset I have values where start time is before the arrival time and instead of counting them as negative it displaying positive, how Can I fix this. SUM((CASE WHEN (TIME_TO_SEC(timeDIFF(`Start Time (UTC)`, `Arrival Time (UTC)`)) / 60) <=10 THEN 1 END)) / SUM((CASE…
-
Rename filter values to "Other"
I am trying to apply a filter at Card Level. For this specific card, I only want to show the filter options as either "Name 1" or "Other". I want the rest of the values to be bundled under "Other", so I only show two options for applying the filter: Name 1 Other Is it possible to do this via beast mode so it only applies…
-
Domo Beastmode Window Function
Hello! I'm trying to get a window function to work while creating a beastmode so it can be dynamic for my users. I'm trying to show the unique number of users partitioned by rubric. So, my beastmode is COUNT(DISTINCT `user_id)) over (partition by `rubric_id`). This works when I just show the beastmode: However, when I then…
-
Is it possible to create a graph with categorical levels?
Hello! ☺️ I have this card in which every number (1-2-3-4) represents 4 possible levels of a scale (1-> Insufficient, 2-> Regular, 3->Sufficient, 4->Outstanding). Is it possible to create this card but with categorical levels so the card doesn't show 1, 2, 3 and 4 but the categoribal words?
-
Recommendation for best way to create this visualization
I have 2 columns 'years old when moved in' and 'Length of stay in Days' What I am looking to do is create a card (histogram?) that will take the ages and put them in buckets then show an average length of stay in days for each of those buckets. I already used the histogram to show the distribution of ages as a count, and…
-
Weighted Average Price Beast Mode
Hi Everyone, I am working on creating a beast mode that will calculate a weighted average price of subscriptions. Essentially, the formula will take the subscription price and multiply it by the number of subscriptions with that price, then divide by the total number of subscriptions. This is what I have so far.…
-
Aggregate Count of Line Items by Distinct Orders
Hi! I am trying to aggregate line item quantities by distinct order id. I built a Beast Mode that was validated, but I continue to get the message, "An issue has occurred during processing. We are unable to complete the request at this time." I have changed the beast mode multiple times and continue to get the same…
-
Hi Team, I am trying to set an alert but no luck.
There are 7 columns: Site_id, Date, Campaign_id, Ad_type, cumulative_impression_delivered, cumulative_actual_impression_goal, Delta I have created a card in table format using all the above columns and trying to set an alert on Delta column whenever it reaches to the threshold but I am getting below message while setting…
-
Cool blog post on DDX Bricks
Written by Jace McLean, Domo's Director of Data insights. He has more than 15 years of experience in data, analytics and technology. I thought some of you would like to read his post on DDX bricks. Check it out here.
-
How to build acard to show breakdown of revenue by Margin % on transactions
Hi, I would like to build a card to show how much revenue is generated by sales at different margin % bands. Is there an easy way to accomplish this? I think I could add a column to the dataset (already over 100 columns) to categorize each transaction. Is there another way to approach this? I have a Revenue dataset with…
-
I need to calculate cumulative backlog in card for the data filtered by various categories and date
This is the data for my chart. I have to show ticket created count ,ticket closed count and cumulative backlog count datewise . The dynamic filters are severity, domain, sub domain and date. The chart has to be look like below. The below chart is taken from excel report. I have to achieve this in domo. please provide ideas…
-
Beast Mode Calculation
Hi Everyone, Trying to come up with a beast mode calculation to calculate the percent difference between last weeks count and this weeks count. This is the example of how the data would look: Also I would like to know how to do a rolling 4 weeks count so an additional field with header 4 week count and then the percent…
-
Beast mode calculation for aggregating data
Hi, I have a numeric field called "days until due" which contains negative numbers for outstanding items from -1 to -100. I am trying to group these using a beast mode calc. but keep getting syntax errors. For example, when "days until due" is from -1 to -9 days I want it to be grouped as "1-9 days", -10 to -19 days would…
-
Can I save a copy of a card's drill path as a standalone card?
I have a details view drill path that I want to save as a new standalone card on the same page. Is there a way to clone a drill path and turn it into its own card? Thanks!