-
Group on account name
Hi, I am new to Domo. I currently have a card using Salesforce data that shows the average deal size per opportunity type. I can show this per month and per quarter per filter. For example: Account Name Amount Close Date Opportunity 1 Customer A 50 24 Oct 19 Opportunity 2 Customer A 100 24 Oct 19 Opportunity 3 Customer A…
-
Change a number to a text
I have an 'ID' field that has been imported into Domo as a number but I need it to be a label or text. I can see how to go from a text to a number but how to go from a number to a text? What is the beast mode logic that will allow me to make this update?
-
Why Pie Chart legend filters the opposite way
In a pie chart, when an user click on a slice of the pie, it filters out that piece (highlight that piece, and grey out all others). However, when an user click on a value in legend, it filters out everything but this value? Does anyone know how to fix it? In the attached example, I wanted to see Global, but it greyed out…
-
How to get a filter to select date_time to date_time
Hi all, I can not find a way to create a filter to performance something for example, selecting between '2019-01-01 06:00' and '2019-01-02 7:00' on the card. I can only select the date, not the time. I tried to use beast mode to extract time and put it in a separate filter, which would not work because it simply filters…
-
Google Analytics traffic data showing incorrectly in Domo
I am having some issues with the cards that are connected to Google Analytics. I have multiple cards that use the Google Analytics connector that are showing incorrect data points (upwards of 500 users off) for website traffic by segment. I am wondering if this is due to the settings of the cards.
-
Horizontal single bar chart skipping categories on Mobile Device
Is there a way to prevent category labels from skipping in the Domo App? I'm guessing it skips every other category to avoid overlapping but it seems like there's enough space to display all categories. I see there's an option to allow overlapping on data labels but not category labels.. The first screenshot is from PC web…
-
Is there a way to update document cards programatically
Hi, I have been using document cards to display within Domo various pdf reports that I receive regularly. Is there a way to update document cards programatically so I don't need to log in and upload manually each time? Cheers
-
how date filter card works when there are more than 2 data sets in a dashboard
I have a dashboard with cards built from 2 different datasets A, B. Both datasets have a date column "Event_OccuredAt". Date filter card is from dataset A "Event_OccuredAt". 1. I created a single value card to show how many new users in last month using dataset B based on another date column "User_Created_At" in dataset B.…
-
Calculating YoY and QoQ in Pivot Table
Hello, I am trying to create a pivot table displaying QoQ and YoY revenue growth over the span of 6 quarters by product, but I am having difficulties building out the proper beastmode to show every quarter simulateanously. I have tried to use some suggested formulas…
-
Grouping my data
I am building a card that lists out quantity for each Action (STARTS, RESTARTS, TERMINATES, STOPS). Each Set of Actions can fall into a different Week (WEEK1, WEEK2, WEEK3, WEEK4 & WEEK5). My data is summing up but it is creating multiple duplicate lines (See Screen shot). How do I get each action to show only once and…
-
Is it possible to add column head in pie chart Legend table
Hello, in pie chart legend summay table, is there a way to add column head so user can know what is the value. Thank you. Olivia
-
how to hide raw data from charts
Currently, for the charts in the dashboard, if users click futher, they are able to see the raw table. Is there a way I can hide the raw data? Thank you. Olivia
-
Calculated metric using Segments
I have a dataset with multiple segments which filter the visits to particluar page based on the page flow. Page Flow is A1 -> A2 -> A3 ->A4 Total Visits to website - V Segement A - Visits to page A1 - V1 Segement B - Visits to page A2 from A1 - V2 and so on. I want to calculate the percentage of V2/V1 i.e a conversion…
-
Informative pop ups
Hi all, I'm looking to add more information to my dashboard but without cluttering the page! A great way to do this would be to have little "?" icons on the card for which you can hover over to see more information about the card. I was wondering if anyone has seen anything like this or can think of any new and novel words…
-
Adding a date line market to chart?
I have a horizontal percent complete gantt chart. I currently have "Show Current Date" checked on in the chart properties, but I was wondering if I am able to add more vertical lines from the date x-axis to make the chart easier to read. For example, my chart goes from Oct 2016-Jul 2022, and I would like to have dashed…
-
How do you Filter on Date that is Null
I have created the following beast mode to attempt to filter on dates that equal null CASE WHEN 'opportunity date' IS NULL THEN 'Is null' ELSE 'Is not null' END I can see the blank dates in the data but when I add the BM as a filter the only option I have is to select 'Is Not Null'. How do I get the filter to have the…
-
Filter card with 'search' bar
It would be great if there was a filter card with a search bar available. For example, when you use a card which shows the overal sales for a company with a link to the sales per customer. With a search function, users could easily find the customer they want to analyze without having to open the card in a new page to find…
-
table card for null value
My data looks like this, when id is blank, it means the file has not been used. I wanted to create a table card to show which files have not been used. In this case, I wanted to show file B, E in the table card. But if I make selection in filter for Id in ' ' , nothing comes up. Can anyone give me some ideas why or maybe…
-
Quick Filter in Dashboard
Hello, I am working on a dashboard which requires a minimum number of actions to use. One card contains total sales with a link to sales per customer, I have added a quick filter to look for specific customers easily. But to see the filter, you first have to click on the card. It is possible to add the filter on the…
-
Sorting data by success percentage
I have a card where we are looking at blood draw procedures year to date, graphed by month. So, we have the date of the blood draw as a column, we have the count of distinct needle sticks, and then one column that categorizes each blood draw as successful or unsuccessful. We are not so much worried about the actual counts,…
-
Parameters/Filters to select two dates to compare
I have a situation where we are creating a snapshot of a dataset and want to perform two types of comparisons: * By default, compare the latest snapshot to the previous snapshot * Allow for the consumers of the cards to choose the two date fields to compare Here is an example of the snapshot data (simplified): Snapshot…
-
Alert Each Time a Row Enters Alert Criteria
I'm trying to figure out the best way in Domo to alert one of my users and I don't believe the actions available to me are what I need. Before submitting an idea suggestion I figured I'd ask here. Scenario: * Project Management is tracking the hours spent on a project and wants to get notified when a project reaches 25%,…
-
Pivot - Not showing all the distinct values in the filter
Hello All, I'm new to DOMO , I have a very simple pivot with 3 filters columns ..if I don't use any filter columns data looks good ..when I use any one of the column which are required in the filters data is not correct ..looks like DOMO is not selecting all the distinct values from the column which I use in the filter. Ex…
-
Date is changing from M/D/Y to the number week in the year.
I have a grouped and stacked card that is showing revenue for the last 3 weeks. I have the date filter set up to show last 3 weeks filtered by week. However, the data format is showing the number of weeks in the year instead of the week start date that is in the actual data. My column 'Week Start Date' has Sunday dates on…
-
Page Filter: set default value
I would like a page to load pre-filtered, but allow the user to change the filtering via a page filter. Currently I have a page filter for "Fiscal Year" like this: * FY20 * FY19 * FY18 * FY17 and 98% of the time a user wants to see FY20. Is there a way I can set "FY20" to "Checked" in this page filter, allowing the user to…
-
How to display two total numbers, such as spend and savings, on a bar chart.
I have a grouped bar chart that is essentially showing spend and savings broken out by categories such as hotel, food and beverage etc. The summary number displays the total spend. However, my issue is that I need to display the total savings as well. Does anyone know how to do this? It can be in the summary number or the…
-
Year over Year Value Change
I have a card that shows year over year value. However, I want to show year over year change (i.e. 2015 to 2016, 2016 to 2017, etc.). Attached below is a screenshot of my current card. I want to add a line showing the dollar change year over year.
-
Single Value Card Limited to 25,000?
I have a single value card that shows the total tickets we have in our IT Help desk tool which is basically just a count of all the ID's for each ticket, and each row is unique to one specific ticket so the total rows is the same as a count of all of the ID's. I noticed that the card now has a caution symbol on it and says…
-
Adding Tooltips to Hover Text in Heat Maps
Good afternoon, I really enjoy using hover text to provide more insight in my Domo cards. This question is regarding heat maps. I am trying to add a "count" of a variable not represented in the heat map to the hover text as a sort of FYI to the viewer. However, the tooltip feature is grayed out. Can you advise if these are…
-
Applying color rules in a column
I have designed a table cad which has string and numbers. I want to apply color rule on the cells which has numbers only. In the added image I want to add color rules in the highlighted column but, currently as the column has both texts and numbers, DOMO does not allow me to set a condition in the color rule. I there a…