-
Using Beast Mode to filter on multiple values?
Since using Domo, I've come across multiple scenarios where I need to filter fields based on multiple columns, and I haven't found an easy way to do this in card building. So far, I've resorted to hard filtering everything out using the ETL, but that isn't very flexible. Here's an example of what I'm trying to filter:…
-
Removing number abbreviation in line chart?
Hi All, I have a line chart where I'd like to display the Y-scale and amounts in the thousands, without the K or M abbreviation. Is this possible? For instance, $50,000,000 would display as $50,000K, and I can't find any way to remove that 'K'. Is a beast mode my only option here? Thank you!
-
How do i compare
I have a data set that is for fire drills we have a set scheduled shift i want to see when it is ran on a different shift so above the scheduled shift is the set shift the "Shift" is the one it was actually ran on. I am guessing it will be an IF and then else statement but not sure exactly how
-
Drilling between custom charts
Hello, I'm trying to make a tool using custom charts for our building, but I'm not sure about the feasibility of my design idea. Essentially, I'm trying to recreate the drill down process to Zip Code shown in this DOMO video: https://www.youtube.com/watch?v=UUZ_RvKX8O8&ab_channel=Domo, but instead using custom maps of our…
-
Convert Week Numbers to Start of the Week Date
I am trying to create a table graphed by week, and the analyzer converts the date columns to week numbers. Is there a way to convert these week numbers to start of the week date? eg. 5/23/21, 5/16/21, 5/9/21... 4/4/21
-
Dynamic Goals by employee title
I'm trying to set up a card to show employee performance against a corporate goal that is variable based on the employee title. Certain employees need to submit a report, and the # of reports they have to submit is either a certain number per day, per week, or per site visit, depending on their title. I have one dataset…
-
Excluding null values when using rank function in beast mode
I used "rank() over (order by asc)" in the beast mode, but I am getting blank rows on the top, followed by the correct rank . Is there a way to exclude the null values when using the rank function?
-
Percent of total by month in Pivot table
Hi, I have a pivot table card that shows the units and $ for products sold each month. How do I show the percent of the total $ that product is for that month or the total column? (see highlighted below). Rows: Region, Product Columns: SoldDate Values: SUM of Units, SUM of Price Thanks, Angela
-
Problems with Window Ranking Function
Dear friends, I am working in a CFD chart , to measure scrum metrics through the year for different squads. For one specific Squad, the chart is changing the date order when presents on Area chart, as you can see on the image below. Analising the scenario, it´s possible to identified that for this squad i had only…
-
Can PDP be changed at the card level?
Good evening, I have PDP in place for a data set in Domo but am wondering if there's a way to open up the policy for specific cards. For example, I have a sales data set where, the way the PDP is set up, salespeople can only see their sales info when they log in. If they want to see where they rank against other…
-
Card setup
Hi, I am not sure if this is possible. In my attached image, the bars in the Y axis are a beastmode calculation for a percentage Below, in the highlighted section, a user is wondering if, instead of the %, it could instead show the denominator of the percentage It does not seem so as the "data table" section in chart…
-
Distinct patients that need to schedule a follow up appointment
Hello , I am trying to figure out which patients did not schedule a follow up appointment after their last visit. I want to show last Kept visit per patient and if the patient needs to book an appointment . The problem i am having now is that one patient can have several Kept visits. . I want to show their last 'K' (kept)…
-
Alerts not sharing in Buzz channel for specific datasets
I have alerts set up and shared with a Buzz channel on several cards but the alerts only post to the channel for specific datasets. I still receive the notifications regularly otherwise. Does anyone know why this is happening? The data and card permissions are all the same.
-
How do I show a delta value for specific bars in a stacked bar chart?
I need a waterfall chart that supports stacked bars. Since DOMO's waterfall chart currently doesn't support stacked waterfalls I'm creating a waterfall effect using a stacked bar chart. For example: This requires me to duplicate the data from the first bar to the second bar and then visually hide it. However, I don't want…
-
Formula not summarizing in analyzer
Hello Dojo, I have a calculated field I am trying to apply to a time series chart that does not seem to want to summarize. The formula changes based on one of the variables - objective. case when `Objective` = 'CLICKS' then (case when (sum(`Clicks`) / sum(`Impressions`)) < .0082 then 0 when (sum(`Clicks`) /…
-
Adding an average bar to chart
I have the following chart and I'd like to add a dynamic average bar that would change for each value on the x-axis. In other words, this "average" would be plotted for each month and should change with each month such that it represents the average of all values for that given month. The result should not be constant…
-
Find the difference in forecast and revenue in first quarter and distribute the difference amount
Find the difference in forecast and revenue in first quarter and distribute the difference amount to rest of the quarter's forecast For eg: forecast for Q1,2,3,4 is 1M each and sales bring up revenue of 800k in first quarter then the difference 200k should be distributed to rest of the quarter's for cast so Q2,3,4 forcast…
-
Finding out which division is missing
I have a MS form that each division is supposed to fill out monthly. I pull the excel to domo. Is there a way beast mode or other to see which division hasn't completed it for the current month?
-
Change the value when hovering over a bar?
Good afternoon, Is there a way to change what's being displayed as the bar values in the image below? Ideally, I'd like there to be the current hover over Percentage of Category (94%, in the example below) to display above the hovered bar instead of the 8,105,205 value. Is that possible? Thanks, Joe
-
What are "segments" in the context of page-level filters?
Hi, The documentation about page-level filters talks about the "Allow segments" option: But what are "segments", in this context?
-
Cards suddenly show "US$xxx" instead of "$xxx" in summary number
Suddenly, our cards using the $ currency format for its summary number are showing US$ instead of $ - I suspect this is a setting that was installed in a DOMO update. Is the only workaround to do a CONCAT($) type function? This would take a while as we have quite a few of such cases and individual beastmode calculations…
-
Freeze cards at top of Page
Is there a way to freeze cards at the top of a page. Like a header card that shows the date. When you scroll down the page, I would like to make it so the header card is still visible.
-
Remove Color Rules
Hello, I added color rules to share with the dataset - is there a way to delete these rules for some of the cards? I try removing them from some cards and they still persist. Thanks!
-
Filtering a set of rows by event time (across different time zones)
I have a dataset, for example, with 3 events in each of the US time zones -- all coming through as 7pm local to the time zone in the dataset. I need to sort them by the time occurring, so in the example below, California events would be listed first, then Colorado, then Chicago, then New York. How can i do this? Can I do…
-
Doing a moving average using window functions in Analyzer
I have this salesforce lead historical dataset (which tracks Lead stage changes) and I want to show a month-on-month moving average of the number of days it takes a lead to convert to the next stage (e.g. 30 days from Stage 1 to Stage 2) with Stage as series/dimension in my card. The dashboard/cards that I'm creating is…
-
Can you have a card with calculated rows that have different data types under one column?
I have a financial report that shows: Row: 1 Gross Retail Revenue ($ value) Row 2: Retail Discounts ($ Value) Row 3: % Retail Discount = Retail Discounts/ Gross Retail Revenue (% Value) Row: 4 Gross Wholesale Revenue ($ value) Row 5: Wholesale Discounts ($ Value) Row 6: % Wholesale Discount = Wholesale Discounts/ Gross…
-
Auto Refresh a card from Federated source
Hello All, is it possible to configure auto refresh at certain time interval when we have card ( visual ) in view mode I am only talking about federated connections in DOMO.
-
Is there a way to nest beast modes in another beast mode without exposing the full calculation
Looking for any advice suggestions on the following. First, I wanted to ask, if I make a change to a saved beast mode, and another calculation is using that beast mode will that calculation automatically update? Second, I would like to nest multiple beast modes in a calculation and use a case statement to select which…
-
Any graph/plot that can help show moment of people between different categories over time?
People are classified into groups based on their activity. And the group a person can belong to changes over time. So people move between these groups as time passes. A person can belong to only one group. Is there a graph on Domo that can help me visualise this? i.e. How many people moved from Group 1 to Group 4 in ANY…
-
Possible to filter on one dataset based on the results of another dataset in a page?
I have a user table and an activities table. I want to track the activities over time, but since there are too many activities, if I include a user details for every activity, the dataset will be too large. I want to be able to filter the activities by features of the user. And the features are contained in the user table.…