-
Filter Page via URL?
I am working on building a page that users will frequently filter by a single field, AccountID (it's a page of account performance metrics, designed to filter to see a single account's performance over time). I'm hoping to configure a page filter via the page URL. The idea would be to have a dynamic link in SalesForce that…
-
beast mode % calculation
I wanted to calculate % of active user using the following beast mode, but soemhow it only gives 100%. I could not figure out what went wrong. In this exmaple, %of active user should be 2215/(2215+3273) , but it shows 100%. This is my beast mode: COUNT(DISTINCT case when `useractivity_status` = 'Active User' then…
-
conditional formatting text in single value gauge
Hello is it possible to format the font colour in the single value gauge to represent variances between metrics? I imagine that this uses beast mode and I don't want to use the comparative gauge as the arrow is not needed....unless there is a way to suppress the arrow. Many thanks Guy
-
Sorting a flex table on Total without affecting graph column date order
I have created a flex table that shows changes over time in the graph column, with another column to show series total. I want to be able to sort the series with the highest quantity at the top. The issue is whenever I do this it causes my graph column to show the dates in the wrong order. So for example, if I have a graph…
-
Matching colors throughout dashboard (stacked graph)
I have 3 different stacked bars in my dashboard. All three come from different datasets, but they have the same series values. The series values in each card are shown in different colors, which makes my dashboard very confusing. How can I set different values in the series to have the same color throughout the dashboard…
-
How can we display two values on x- axis?
I have a forcasted value, and actual value received every month. As Forcasted values are constant, like manual file uplaod which is decided by sales org in starting of the year. So How can I display the forcasted and actual revenue recived each month of the year. Which graph to be used, and how. Sample is attached. Where…
-
Insert a vertical line between cards
So I'm designing a dashboard on Domo. I want to insert a vertical line in the dashboard, to highlight seperation between two cards (instead of a horizontal line, which the dashboard currently allows me to make). I can't find a way to do this. Anyone has any sugestions? Is there a way I can add a border to cards maybe (just…
-
Table Card is limiting output to only 500 rows
I'm building a large Table Chart and have it set in the Analyzer to show All Rows. Unfortunately when I go to view the card after saving it states "Warning not all Data Shown" and says that it limits the data to only 500 rows. Any ideas on a solution for this? The only reason I'm using a table chart is because there are…
-
Making a top 5, bottom 5 filter card
I have two cards which show: 1) a bar graph of revenue per product. 2) a bar graph of fill rate per product. There are more than 40 products. I want to add a filter in my dashboard for "Top 5" and "Bottom 5", instead of making four new cards for top 5 and bottom 5 products (2 for revenue and 2 for fill rate). Anyone has…
-
Card data in dashboard doesn't match card data in analyzer
I've been trying to combine two surveys performed at two different times (Qualtrics). I added a column called 'Year' before merging so we could filter by year and compare the two. This works well in the analyzer, but as soon as I leave it DOMO can't seem to find any 2017 data. I've checked the dataset, it's definitely…
-
Progress Bar Card Takes out Percentage and Progress Color When Optional Gauge Name Added
I'm trying to figure out what I'm doing wrong here, whenever I add an Optional Gauge Name it takes out the funcitonality of the bar, making grey (see screenshots).
-
Country Slicer
Hi- I am trying to add more countries to my country slicer. Does anyone know how? At the moment it is set to three countries. Thank you.
-
Custom Summary Number Not Cleanly Exportable to Powerpoint ?
When I found this Knowledge Base post (see link), I was excited to see that it is possible to create a custom summary number, especially to string together more than one metric...:…
-
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…