-
Weeks one week different
Afternoon, Working in a data set and I have three dates 10/4/22,10/5/22,10/6/22 and when we build a graph card and set the display to week it is showing these dates as week 41. But these should be week 40, last week. Just to test it we put in todays date of 10/10/22 and it says week 42, which is next week. Seems somehow…
-
Line Chart with Weekends Denoted
Hello, Has anyone found a clever way to denote weekends on line charts? I'm looking for one continuous line that changes colors depending on whether it's a weekend or not. The closest I've gotten is with a bar chart. Let me know if there are any ideas! Thanks, Jeff P.S. My Beastmode for indicating weekend is as follows for…
-
How to Remove Duplicate rows in analyzer?
I have used the LinkedIn connector to export the stats. I see duplicated rows. How do I avoid them?
-
Gauge Series
Is it possible to use two different groups on a Gauge chart? I have 1 number but the number is put together using two different groups (series). A few people asked this question a few years ago but I was wondering if this has been added into Domo?
-
Heatmap: Only drill in one category
Hello, I am using heatmap to explore my data and drill into it. However, I want to drill only with the the "category 2" and ignore the "category 1". This is the original card (cropped "category 2 values"): This is the drilled card I got when clicking: This is the result I want ("category 1" ignored when drilling): Any help…
-
Beast Mode to replace null with 0
Hi, I have a pivot table that counts the "EventID" for each row of data, per person. Some people did not have activity so there is not a row of data to count. I tried doing a beast mode for the "Values" field of the pivot table that replaces the null cells with a "0" so I can have the color settings make the cell dark red,…
-
¿How can I classify an object based on conditions?
Hello Community, I have a dataset in which I have the course code, name and number of tools used. What I require is to be able to classify these courses by levels, which to be at level 1 must use at least 2 tools from an established list. To be level 2 you must use at least two tools from level 1 and three established for…
-
Freezing card at end of Fiscal Year
Hello everyone, I was curious to know if there is any mechanism in Domo where I could freeze the content of 50 cards that are part of the same dashboard so that on the last day of the Fiscal Year we "freeze" the cards and the dashboard and then the data would become static but obviously with drill down capabilities. It is…
-
How do I remove duplicate rows in a card drilldown?
I have a card that is created by counting IDs and when I drill down into the card, it shows all the rows for that ID. I just want to show unique rows for a user ID. Attached is the screenshot for my data. I want my drill down to look like this. Basically, I want to remove the duplicates in the drill down. Is there any way…
-
Sumo Card
Hi, Is the sumo card an old feature now covered by the pivot table in the analyser? I can never get it to load in pivot view so was wondering if I was missing anything. Thanks
-
Why is my card grouped by month in the table but not in the chart, and how can I fix it?
So I am trying to create a rolling avg card, I have successfully created the 3 month lag in the BeastMode and tables as you can see below and it is grouped by each month. However, in the actual card/graph there are several values for each month instead of just one September, for instance there's like 5 Septembers. Any idea…
-
Vertical bar with 2 or more series
Hello, I need to create a card with vertical bar with date in X axis and count of case in y axis and 2 series : owner and request type. Is there a way to do it ? with stacked bar per user ?
-
Date range selector
Hi, Is there a way to make the range selector do different steps in the data. e.g. I want the steps to be weekly or monthly but it always steps for each day. Thanks
-
How to calculate % of projects assigned?
Hi there. I'm trying to setup a beast mode calculation but not sure the best approach for it. I have a column that shows the number of days it takes for a new project to get assigned for example if opened on 19 Sep, assigned on 22 Sep - it would show up as 3 days. I'm looking to do a quality check to see what percentage %…
-
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…
-
Legend includes colour rules
Hi folks, The legend on a link chart is including the rules set for the colours. How can this be removed to just show the label Thanks
-
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.