-
Display Decimal Places
I was wondering if anyone had a solution for this... I hvae a field I built in Beast Mode that has this CASE logic... (CASE WHEN `cost` IS NULL THEN 'n/a' ELSE CONCAT('$',ROUND(`Cost`,0)) END) When i try and put 2 in for the round places and if the value does not have any decimal places to strat with in the raw data it…
-
Page filters to be enabled in Card drilldowns
Hi All, i am trying to use the page filter option in the drill downs. i am able to use he page filter in the first view of the card. if go further drill down then the page filter opions are not available. Could you pls help how to go ahead on this. need to analyse further more detailed insights, need to use the page…
-
Reports or Cards bursting feature
Hi, I'm new to Domo and I have a question in regards to my POC on reports bursting feature. I’m trying to leverage Domo reporting tool to validate the report bursting feature in Domo, below is the POC that we are trying to validate in Domo. POC Details: I would like to check to see if there is a way to generate reports…
-
Zoomed in chart with arrow
Sorry if this is a basic question but I have not been able to find the answer anywhere. I have one chart that displays the chart zoomed in with a blue left pointing arrow which when clicked will display the full detail of the chart. I would like to have this functionality on other charts but I cannot seem to find what…
-
Filter with dropdown AND Search
Is there a way to make a filter card with a drop down option? Also, is there a way to put search bar in a filter? E.g in my filter there are over a 100 values. I want to be able to search (by typing) rather than manually sort through the filter (by clicking the small arrow keys).
-
Not show value labels for a particular value in Series (in a chart)
I am making a stacked chart. I have 4 different kind of values in my series ("Excellent, Good, Bad, Worse). These values are spread out (in a stacked chart) over days. I want to hide one value ("Worse) "completely, and only show the others. I've tried to make the series value ("Worse") gray in color so that it can blend in…
-
Is it possible to set up a collection and make it collapse or expand in story telling dashboard
The new story telling dashboard is great. But is it possible to create collections like in old way dashboard and allow collapse and expand for each collection? Thanks.
-
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…