-
Add a vertical line on the chart between actual and forecast dates
I have a chart with x-axis = dates and y-axis= sales. Want to add a line between actual date and forecast date to show the left part belongs to actuals and the right part belongs to the forecast. Additionally, if I can label the left space as actuals and right space as forecast that would be great. Any suggestions?
-
Creating anchor tag for cards
Hello, We are using iframe to load DOMO report in our application. We are passing DOMO url and token to iframe source. We have one application which sends email to users. EMAIL body contains one hyperlink. On click of that, we are navigating user to HTML page where iframe is added. This Domo Report have 2 cards. Now, we…
-
Why have the dates changed?
So I have put together a multi data source dashboard for our company. Yesterday, before everything ran overnight, all of the years worth of data was showing up. This morning, without changing any filters, the graphs are only showing about 15 years worth of data. My instinct said that somehow the update caused to data to go…
-
alternative for parameter in Tableau
I would like to build "interactive chart", so user can choose what will be displayed on Y axis (SHIP TO, SOLD TO, customer group- see attached image). In Tableau I used Parameter for it - but as far as I read this option does not exist in DOMO. does anyone knows any alternative solution? thank you!
-
Card updates later in the month than other cards - Beast Mode to keep previous value until update?
Good morning, I have a dashboard with cards set to update once the month turns over - however several of the cards display data that update about seven days post-month change. During that seven-day period, the cards display no value. Is there a Beast Mode that would allow for the cards to continue to display the prior…
-
Can I display data in Kanban Board format or would I have better luck finding a unicorn?
More and more I am getting asked if there is a way to create a card/report where the data is displayed in a Board format (basically, vertical columns with activities slotted into the respective column). Looking for a creative, "elegant" solution....really surprised there doesn't appear to be a Card Option to create this…
-
Exporting a filtered file
Hi, I recently joined multiple data sources together and we are going through and sifting through the data flow. Almost everything looks good except 5-6 columns have nulls when we are expecting data. For example we have 109,000 thousand rows and all 109k have loan IDs in them but there are only 105k rows with purchase…
-
Dashboard Date Range with Multiple DataSets
I have a dashboard made up of cards from multiple DataSets. When I started adding cards, DOMO automatically adds a date range filter to the top of the dashboard, similar to the date filter that appears in the upper right in Analyzer mode. That date field appears in all of the datasets used by cards on the dashboard.…
-
Formatting a single number card
Hi all, Simple question here. Is there a way to format the number on this card to be a normal number? We had 3,108 Loans last year and I want the number to be in that same format but the best I can do is 3.108K which doesn't make much visual sense. Any suggestions? I have tried all the formatting options that make sense…
-
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…