-
Get the total result based on sum of column 2 / sum of column 1
I wanted to get the result based on Col2/Col1 result, expected result here is .3545, when we do average in last column i'm getting .3788 (1.8942/5). Is there any way to achieve the expected result.
-
Query in card building in DOMO.
Hi, I need to create a card in DOMO similar to this, Based on this, I choose type as "Pivot Table" in Domo with Rows as C1 and C2 Columns as year, month Values as Count(Sum of C3), Avg. Duration(Avg of C4), Engaged(SUM of C5), Transferred(Sum of C6) where C1, C2, etc are different columns in dataset. And now, card in DOMO…
-
Filter to Compare on a table different years but same period of time?
Hi! I'm trying to compare a value (total hours) on a table, for the same period of time (this year vs last year) and I want to be able to do it with a filter. Example: User wants to see total hours between Sept 1st to Sept 5th for current year compared with last year same period. The table that I'm using is a pivot table…
-
Compare data from two views of the same dataset, dynamically
Hi there, Context: I have a dataset with daily snapshots appended and it has one batch date field. Ideal: I would like users to be able to select two dates Date A and Date B to compare the snapshot view from both dates. Simple solution: Split the dataset into a Date A dataset and a Date B dataset in the ETL, create visuals…
-
Heatmap - No data
I have created a heatmap for online activity, though some spaces are showing up as "no data" and greyed out. Is it possible to assign a value of "1" to where there is no data, so the heatmap would be more visually pleasing or something similar so there is no grey section? thanks!
-
Timezones
Is there a way to convert timezones for certain graphs within beast modes? I am looking at online activity for different clients within different timezones ( the metric is 'appt_created_time_utc') and cannot figure out how to adjust each graph to reflect their specific timezones.
-
Resizing text box glitch
Hi folks, While resizing a textbox in a dashboard the scroll glitches and sends me down to the bottom of the dashboard. When I scroll back up the textbox is huge. Each time I try to resize the visual, this happens. I've saved and edited it again but it continues and this has happened on two dashboards now, using blank text…
-
Display Data based on User?
I have report that contains student data and would like for the data to filter automatically based on user (teacher) so that this report can be created once and shared with several teachers where teachers would only be able to see their students and not anyone else's.
-
Division Question
Hello, I am trying to find a formula to see the total utilization for online scheduling vs offline scheduling for certain exam types. Online vs. Offline exams are within the same SQL column ('appt_source' will either = 'OFFLINE' or 'ONLINE') whereas exam types are within a separate column ('Modalities'). Any suggestions on…
-
DDX Bricks cards with Domo Campaign Apps
Hey, We have a client who has a dashboard with DDX Bricks cards. And he needs to send the pdf reports to multiple people as an email attachment. So we decided to try Domo Campaign Apps. Can we use a dashboard with DDX Bricks cards in Domo Campaign Apps? Appreciate your feedback on this. 🙂
-
Removing Item when building a card & New Beast Mode window
Can you please return the feature that allows me to simply click the 'x' next to the item when building a card. In order to remove a dimension or metric I now need to select it and open up the properties and select "Remove". Half the time the configuration doesn't even open, or I have to wait an incredibly long time for it…
-
How can I remove items from a mega table using a beast mode?
I have a table with 5 columns: The first column (A) lists parts, the second (B) lists countries, the 3rd (C) is a concatenation of the first 2 columns, and the 4th (D) is a concatenation of the same list of parts but other related countries. There are many more countries in column D than in column C, so most of the values…
-
Text unique values - only count for each option
I'm trying to create a table that shows the total number of times a person selected 1 of the 5 available options from a multi-select field. Audience field options: C-Suite VP Director Manager Below Manager Right now the table is showing me all the possible unique values by row but I want the amount for each value for all…
-
How to calculate a ratio like 2:1
Hello, been looking at this one and cannot see how to make the calculation in a ETL or Beast Mode. What I am trying to achieve is a ratio or products sold, for example we sell 2 used and 1 new i want to display a ratio of 2:1. Is this possible? In my data i have the following available: 1) N/U = Text value of New or Used…
-
Minimum reporting size?
Two questions: How can I set up minimum reporting sample size in a bar graph? How can I set up minimum reporting sample size in associated drill down? as in, will the minimum reporting size constraint from the mother card apply to drill down? I am trying to present number of terminated employees (voluntary and involuntary…
-
Hide/filter out cards on dashboard display
Hi, I was wondering if there was a way to hide cards from a dashboard under certain circumstances. For example if the data being filtered was a certain value, a specific card would disappear. This will be for clients to export dashboards to PPT and not need to clean up superfluous elements. In a similar vein, I'm also…
-
Odd behaviour with FISCAL Calendar
HI, We have had the fiscal calendar enabled on our instance and the fiscal year loaded in. I have noticed some very strange behaviour of the cards and was wondering if this is something domo haven't setup correctly or just limitations of the feature. In our fiscal year we have a fiscal month running from 03/01/2021 to…
-
% Sold of Available Inventory (aka Sell-Through)
I am stumped on this one. I have two tables: an orders table and an inventory table. orders contains a record for each order placed by a customer; and inventory holds a record of how much inventory is available at the start of the period. Note that qtyAvail does not update... it is a reflection of how much that store…
-
Is there a way to make column headings on the DOMO table cards dynamic?
I have several DOMO [mega] table cards that display data in numerous columns, including a column for last month, this month, next month, and the month after next. Every month I need to go in to the beastmodes and change the title to reflect the change in months. The beastmode formula/data automatically reflects the change…
-
Rank based on 2 metrics?
I created a RANK beast mode on a card. It's currently based on the 2nd column in this screenshot, TOTAL: Current Run. As you can see, we've got some ties. Is it possible to (forgive the layman terms) create a tiebreaker of sorts? So if there's a tie in one metric, it then looks at another to make a final determination on…
-
Beast Mode Formula for Previous Complete Weeks
I need to display results in cards from the last complete weeks in a dataset. (This dataset is on a 7-day lag. Thus making it not compatible with the Period over Period cards. Which is cray cray to me. There should be an option to align to the data set rather than today's actual date... I mean... lots to love about Domo.…
-
Period Over Period Calculation Challenges
I am trying to calculate the difference between periods for a specific metric and am running into some trouble. (As you can see from the screenshot below, the Beast Mode calculation I am using doesn't seem to be working.) To generate the column totals, I am using this beast mode successfully for each desired date…
-
Ignore Row Context / Power BI 'ALL()' Equivalent?
I mocked up a simple example to illustrate what I'm trying to accomplish. The question is: how to create a beast mode which will ignore any filters and/or table row context applied to a column, in this case `Store`. The goal is: calculate Average Order Value for the entire dataset (Total Company), so individual Stores can…
-
Single Value Card - Footer use Todays Date mysql like a summary number?
I'm creating a card. In the footer can I put something that will reflect today's date?
-
Date Filter Card Will Not Toggle
Hello! This is my first time posting on the Dojo. I am trying to set up a 14-day and 30-day card filter for my org. The one used at the moment does not toggle. So if I select the 30-day card filter, it will stay at the 30-day filter if I deselect the check box or slide the slicer. It will only go back to default if I clear…
-
What type of chart is this below?
I've seen the chart on the right hand side on a domo video. It looks like a multi value widget but has a graph on it as well. Any idea what it is? Thanks
-
Status tracking for hot board
I am wanting to track a hot board status for part numbers and want to use the status to track through the process. Is there a formula or beastmode that can remove the in process data once the ticket has been fulfilled and reads 'completed'. For example… Once the part number 3333-000 by Robert Storey was completed can the…
-
Fiscal periods in one report
Hi, I am looking to produce a simple report with the following headers Date | YTD Value | Last Week Value I have a dataset linked to my own fiscal dataset that has information for week start, year start, week number, period etc. I am slightly confused on how to write a beast mode for the above as using the built in…
-
Where do Cloned Beast Modes Come From?
Good Afternoon All, I'm working through managing beast modes for my company and noticed that we have a "cloned" beast mode. Our company uses mutliple datasets, and within the datasets I have noticed that while we can have the same beast mode listed in the dataset twice with diffeent names, however the wording cloned beast…
-
Google Ads Data
I am trying to bring in my CPC, Cost per conversion, Total Spend data etc. for my Google Ads. The columns coming in are way off what they are supposed to be. How do I go about getting the correct data in and then converting those amounts into $ amounts?