-
Transforming Date Range to Zero
I have a simple dataset that has activities over time. I like to break that down by week so I can see the week to week workload of the team. For some of the activities being tracked in the data there might not be anything so in my line chart it shows as a blank and the line graph breaks. I've looked at "hide empty values"…
-
Count Distinct Variance
Hello, I am currently creating a bar chart where I use a count distinct formula for unique client IDs as the y-axis, and the series is location. I've noticed that when i add or remove the series from the bar chart, the y-axis's values change. I'm not sure what is going on, any advice would be helpful. Thanks!
-
Fix colour rules across multiple datasets?
Hi There, Can we copy colour rules to a new data set instead of having to create a new set of rules? Generally, we use the same colour rules across various datasets, if these could be set to default against a similar field name it would be a HUGE benefit. For context, there are 3-6 repeated categories that require 3-5…
-
Can't Read Long Column Headers in Color Rules Dialog
The color rules dialog has limited horizontal space to display the names of dataset columns. If the column names are similar and exceed this length, there is no way to differentiate them or to know what color rules are already set. As a typical example we have a column named "COL_SUBCLAIM1CATEGORYNAME" and a Beastmode…
-
Column Selector in Cards with Filter
Hi, Is there a way to build a filter with different column values in it and then build a beastmode that will select the column based on the filter selection? For example lets say I have full price and markdown data in different columns. I would like to build a filter that has options for full price and markdown and then…
-
Subtract Dates
I'm trying to exclude old items from my card. I'm using the following as a simple filter but it comes back as invalid. What am I doing wrong? Yes, I've confirmed they are both date fields. (CASE when DATEDIFF(`Close Date`,`POV End Date`) > 365 THEN 'Do Not Count' Else 'Count')
-
Date dimension/formula problem
Hi, I'm not sure what I am trying is possible but here goes. I have my data stacked as per @GrantSmith's excellent post. What I need is a calculated column for the last year column that only includes the value if "Another Value" from the This year row = 'Y' So only show 600 if another value =Y from period type this year So…
-
Snowflake Federated dataset refresh rate
I have created a Snowflake federated dataset with a Cache TTL of 900 seconds. I have some confusion about the following. When I add reload data to my base table in Snowflake, I expect the Federated dataset to run in real-time or after 900 secs. But I don't see my 'Last run' section getting updated on the Dataset Overview…
-
Trying to Find the Top 10 part numbers by $'s for the year for each plant department.
I have a large table showing plant department and their part numbers with the quantity scraped / dollar amount scraped as the values. Is there a way to only show the top 10 part numbers by department in dollars? Trying to be able to always keep track of what top part numbers are being scraped. Thanks
-
Horizonal Bar chart
Hello, how do I create this kind of chart in DOMO?
-
Success rate calculation
I'm trying to work out the success rate of applications submitted, attached is a basic flow diagram of how this calculation works. I have setup an ETL which filters out any withdrawn applications and separates the approved and refused applications. Is there a way that I can sum the values of Approved Applications and…
-
How can I make a window function (or fixed function) ignore interactive filters?
I have a window function that takes the total count for a given error code and divides that by the total number of samples run. If a sample is run and does not generate an error, i.e. it completes successfully, then there is no error code. In order to calculate the Error rate (we use Errors per Million Samples), I need to…
-
Changing Number Formats with a Quick Filter
Hello, Yesterday I received a request for the ability to change number formatting on a card with a Quick Filter. The format of the values is currency with no decimals. The ask is for a toggle to display the value in 1,000s. Any ideas on how I could add this functionality to a card? I know I could duplicate each row in the…
-
Period Over Period Multi-Value cards zeroing out when user changes the date
Good afternoon, I have several Multi-Value cards displaying both month-over-month and year-over-year values. They work great as is - but the values change to zero when a user changes the date at the page level. Is this supposed to happen or a side-effect of shoddy card building? Thanks!
-
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…