-
Mandatory Single Select Filter
Hi all, Is there a way to make Page filter mandatory (so no option to unselect), and only single select? Examples would be if you want to choose the currency to display it in, which target to compare the figures to, etc., but if multiple or none are selected the figures are duplicated. We've put in a radio button which…
-
Can I show a percentage of a Summary Number underneath the Summary Number?
Good morning, Is there a way to display a percentage of the whole Summary Number, underneath the summary number? For example, in the screenshot below, would I be able to display that 20% of Total Streams (the 8.7M number) came from Paid users? Thanks!
-
Top Survey questions
I have a data set with 30+ questions as columns. Other key columns are a user column and a topic column. The question columns are text based with values of either 'Yes', 'No' or 'N/A'. So basically each row in the dataset includes a topic and a user's answers to the 30 questions. I'd like to build a card that shows the 3…
-
Drill down on metric counts
I have several tables that are counting the presence of a date in a given field. Our end users are able to click on the grouping to see all loans in that group with one of the date fields present, but when they click on one of the count cells it returns nothing. I think conceptually I understand why this happens (there are…
-
Month over month Offset/Lineup
Hello, I want to build a card month over month offset or lineup. Example, if today is *May 1, 2020 Friday* then it would compare and align to *April 3, 2020* since April 3 is Friday. Then May 2 would align to April 4 (saturday), May 3 to April 5 (sunday) and so on. I use period over period charts.
-
Is it possible to set a default landing page as a user (different than company's landing page)
Trying to set a landing page as a user or admin, which is different than company's set default page. Is it possible or company setting will overwrite this and I can't select a separate page as landing page for myself?
-
Color Rules by Rank
I have a Tree Map Card for Top 10 Products and I wanted to have some sort of Color Rules by Rank for example; Top 1 should be Blue, Top 2 should be Green etc. Is this possible?
-
How to set default page level filters?
I'm trying to set default page level filters, by setting up default values and clicking "Save Filters" at the top of my dashboard. These filters apply for me, but not for other people who have access to the dashboard (they see the page without the default filters). Can anyone explain?
-
Set a default date filter to "today" on dashboard
Hello, I have a dashboard I'm building with a calendar card that can also function as a date filter. To get this to filter correctly, all of my other cards are scoped to "all time" on their dates. I would like when a user lands on the dashboard that it would defualt the filter to "today" instead of "all time." I'm unsure…
-
Bar chart with Fluid Target
Im trying to add a fluid target line from a column in the dataflow to a bar chart. It seems I have the choice of adding a target and losing my series, or vice versa. Is there a way I can do both? I have tried line bar, grouped bar, and a few others but still cant get the result im looking for.
-
Unable to select apply to selected cards in card interaction settings
I have built a dashboard with about 8 cards on it. I have a filter card that I just want to have it affect only 2 cards. However, when I go to Interaction Settings and try and change it to only apply to selected cards, the option is greyed out. See screenshot below. I have been able to do this before, so I'm unsure as to…
-
Delete an Annotation
Is there a way to delete an Annotation? I can see how you can hide them but if an Annotation was made in error, I don't see that we have an option to delete. Even at an administrative level, I don't see that this option exists.
-
How to select most recent data for bar chart
Greetings - I recently posted asking about defaulting to the most recent data for a single value chart and got a great solution; now, I'm struggling with the same issue with a stacked bar chart where I don't have the option to use the value from the last row of data. My data is usually updated around noon; until then, I'd…
-
Can we creat a custom sort for series in domo stack bars?
I try to creat a customer sort for series in doomo stack bars? but they only have sort by total or sort each category? can we create a custom sort for that?
-
Flex Table 'Change Value' Column
Hello, I am building a flex table card to track MoM change across multiple metrics. For all the applicable columns the numbes are shown with the designated value formatting (currency, number, etc.) I have assigned to the series. However, for the Change Value column it is only showing the value in dollars for all my…
-
How to View/Download large tables
Help, I need to know how to view and download large tables in Domo. I've been using the Sumo table but the downside is I can't download the pivoted data as shown in Domo. The new mega tables and pivot tables work, but there seems to be a data cap and only part of the data is shown, which is very confusing. A team member…
-
Removing gridlines from stacked bar chart (but keep the x-axis)
Hi, I am looking to remove the gridlines from the stacked bar chart, but keep the y and x-axis (the 0 grid line) Does anyone have experience with this?
-
Y axis disappears for a grouped and stacked bar with line chart
Hello, I have a grouped,stacked bar chart with Line. On the X-axis, i have 5 columns grouped and stacked along with a line date wise . Issue is when i have nulls in all 5 column for a particular date and i filter to see the card only for this date, only the date appears , y axis is not visible any more. Is there a Way to…
-
HELP PLEASE - Add Subtotals into Mega Tables Domo
Hi All, I have the following data: OwnerAccountAmountRandalA10 A10 A2 A Subtotal22 B3 B7 B9 B Subtotal19 C5 C10 C10 C Subtotal25Randal Total 66 I need to be able to show subtotal at both Owner & Account level all within 1 visualization. I'm able to show the subtotal at the Owner but I can't find a way to show using…
-
Does filter via slicer on Stories carry on towards Drill Path?
Having a bit of trouble with a drill path I've created. On a stories dashboard, I have a slicer shown below. The card (call it Card X) that the slicer applies to shows the following columns: "Project Name", "# of Instances" So, depending on the bucket chosen using the slicer, we may see "Project Ritwik", "27" vs. "Project…
-
Why I am facing this issue while saving my cards?
I am facing this issue while saving the HTML table card I have created 4 beast mode and they are having code from 500 to 1000 lines in case statements. But they are not giving any error while dropping them in the column and getting validated properly. although the card is taking so much to save and after some time it is…
-
Color rules for gauges
Is there a way to change the color rules of the filled gauges so when one calculated value it is greater than the target calculated value then its green and red if less? the color rules only allow me to put a static number like greater than '10' but i want the target calculated value from beast mode Thanks alot
-
Getting a total for group and stacked bar graph
Hi- Probably a simple question, but for the life of me I can't find an answer. I have a group and stacked bar graph with 2 data points on the left bar and 4-5 on the right. I want to sum up all the data points per bar (ie the # on the top of each bar will be the sum of the parts) and not show any of the individual #s for…
-
Lat/Long Map Not Filtering Correctly
I have a dashboard that I've built that includes 4 cards. For sake of this, I'll focus on 2 of them. One is a table and the other is a Lat/Long Map. The Lat/Long Map has the right circles in the right spots. In the analyzer view, it appears to be working correctly as well (i.e. Quick Filter does what it's supposed to do).…
-
Clickable hyperlink not working
Hello - I'm trying to have a text box export a clickable hyperlink. The data source is correct, but the textbox only populates the link url text, it's not a clickable link. Same issue when it's exported via powerpoint or pdf. Any idea how to make this work correctly? Thanks!
-
Slicer, Checkbox, and Radio Button Cards for page with cards with multiple data sources
Hi all, me again.
-
Top 3 cards to build for a newbie - please suggest
Hi All, happy to be here! We just started to use domo for the business and I wonder what would be your advice on first 3-5 cards that an online ecommerce business would must have? Happy to hear any suggestions or oppinions! Thank you in advance
-
Conditional Formatting One Column Based on a Different Column's Value
Hello, Working with a table and attempting to change the color/format of "Column A" based on the value of "Column B" . I understand that I am able to change the format of the entire row or only Column B based on Column B's value, but not one specified column. Are there any settings in "Chart Properties" that I am missing?…
-
Multiple Nested Case Statements Help
I'm trying to nest multiple conditional clauses together and having trouble. Based on the campaign_name, I want a specific calculation completed and value output of 'Good' or 'Bad.' This formula works properly when only specifying one campaign_name: CASE WHEN SUM(case when `campaign_name` = 'VALUE1' AND `Abandon_Time` > 15…
-
Color Formatting Pivot table
I have a pivot table that shows the sales by location for each month. I need to highlight the maximum sales month for each location. I have used Html conditioning formatting on a single column, but since this is a row-level comparison I am not sure how it can be done. Here's what I have Here's the desired output I am…