-
How to Display Repeated Values in a pivot table?
Running into an issue where a pivot table suppresses a repeated value while in a different group. In the image, I am needing the Care Level "CS" to display "Enhanced Studio" in the "Unit Type" column for unit 237. Currently it is suppressing since the above value is the same… Anyone know how to do this? Thanks!
-
Filtering on missing / null values is awful - improve it!
TLDR: If a column contains a null value, there is no way built into the UI to filter to select null values only. Additionally, if you happen to choose "NOT IN" as your filter type and select a value, NULL values will additionally be excluded even if not requested. I understand that there is a workaround using beastmodes,…
-
Group Total - Aggregated Series
Community, Is it possible to have a drill down that retains the prior level's aggregated top-level value? I.e. I want to be able to drill down from an overview, into a series specific break out (And here's the kicker) while maintaining an additional series that displays the group total from the prior drill down. For…
-
Table card column borders and padding/empty columns for visual enhancement
In excel, financial statements and schedules often include empty columns to visually separate or group together columns showing different metrics. It would be great if Domo had the ability to insert padded columns in the same way. Currently when you have a table card that displays multiple metrics and variances, it all…
-
Select all/exclude selection on filter cards
Ability to choose if you want to exclude a selection, or a select all feature on filter cards. Currently, with the multi-select feature, if you want to exclude one selection you must individually select every single line item one by one except the one to exclude. If you could 'select all' then deselect the one(s) to…
-
Drill Down to an Existing Card
It would be excellent if you could choose an existing DOMO Card to use on the Drill Path screen as your Drill-in-Place Card. I have a specific Table Card that I use for almost everything as a Drill-in-Place bottom level card. Because i use it across cards types, datasets, and drill-path levels a simple "Save As" and…
-
Is it possible to fill in missing dates at the card level | Fill Missing Dates button isn't working
I read the article linked above… Is there a way to do this sort of thing at the card level? The Fill Missing Dates option is not working. I'm having an issue with it dropping dates that have no corresponding values on almost all of my bar charts. My dates are all weekly and there's weeks with no data on every card. I don't…
-
Bar Chart set to show last 12 months, is only showing 11 months of data as the first value is zero.
I have a Bar Chart with the last FY worth of data up to 30 June 2021. I'd like the chart to show the last 12 months of data, however, it is only showing the last 11. There is no data in July 2020, which is why I'm guessing it's not showing the column. The nature of the data is that there will be no entries if there were no…
-
Variable control at card-level does not ever show all variables
The UI on the variable control when looking at a card in Expand Details mode is not big enough to actually work with the variable. It seems to only populate 2 options, and the scroll bar makes it super hard to actually see what they are. Unlike Quick Filters, which expand to the height of however many items are in them…
-
Drill in Place
Hi All - Guess I will kick things off here too :) I know this is interation 1 of AppStudio, but I'm impatient and already playing around with moving some of our global dashboards to AppStudio. Is there functionality build a drill in place on a card in AppStudio editor? I see linking to another card and opening in a pop…
-
Allow NOT IN option on dropdown filter cards
Chart Properties for a filter card allow for a few controls (multiple selections was a big win, thank you) However, it does not allow us to show an In/Out filter, which is default feature on page filters. If I add a dropdown filter card in App Studio, we can use it for "include" but not "exclude". The control panel is…
-
Dropdown Selector: always have pre-selected the latest date on a filter card.
Hi, I have a filter card (dropdown selector) to display all dates available and I would like to have pre-selected the latest date. Is this possible? Right now I added it by manually typing the latest month but I'd like it to switch automatically when the month ends. Any ideas are welcome! Thanks
-
Color Formatting on Directionality
Hi Community, Thanks in advance for your help! I'm trying to highlight directionality of referrer's volumes. I want to compare to each referrer's prior month, not to a total or to an absolute value. For example, we can see that Jacob dropped off in April. We can see that Bob and Smith are trending upwards. These insights…
-
Percent of Series?
Hi team, this feels like it should be very simple but I'm missing the key ingredient. I currently have "Percent of Category" as the data label. I'm using an Overlay chart. What is happening: 🚫 Green / Green + Blue = Displayed Percentage What I need to happen: ✅ Green / Blue = Displayed Percentage Any ideas?
-
Sub-Category of a Category?
Hi All, We are working on a report that has a few different program_namesthat are summed up in a pie chart using orig_loan_amount. I have been tasked with trying to sub categorize our bonds using a taxable/tax-exempt designation The problem I am trying to overcome is that our bonds (identified by pool_name) are actually…
-
Combining Multiple columns into one column using beastmode
I am making a table card that uses multiple different rows. The way I am doing it is creating a variable named 'unit type' that when set to specific values returns a specific column. It then sets all the rows for which that column is blank to null and finally I filter out any null values. bellow is the beastmode I used,…
-
Include Variable modifiers inside a filter card
I have my dashboard set up so that the filter options displayed are modified by the value of the variable. EX: notice how the filter by time options change depending on the time frame adjuster value in the screenshots. This is the best way I have found to do it, but my employers find it still extremely unintuitive. I think…
-
Compare to Industry Trends
Hi community, What's the best way to compare two different series when they are on totally different scales? My hope is to see if our trends compare to industry average. I've got month, year, our total, and the industry comparable. For instance: Date My Company Industry Jan-24 100 50000 24-Feb 150 60000 24-Mar 175 70000 I…
-
Personal Use Domo Platform
The competitor-that-must-not-be-named () has a public version for personal use and distribution. This allows for refinement of skills, freelance use, and public portfolio building. Does Domo offer anything similar? It doesn't seem like it, but I'm surprised that we don't.
-
Need Some Inspiration On How to Represent This Data
Hi folks I need some inspiration on a chart type to represent the following data: User Feature A Feature B Feature C Feature D Feature E User 1 Yes Yes No No Yes User 2 No Yes No Yes Yes User 3 Yes No No Yes Yes User 4 Yes Yes No No Yes User 5 No No Yes No Yes User 6 No No Yes No No User 7 Yes No Yes Yes No User 8 Yes Yes…
-
How to show the series list in order (largest to smallest on a symbol line graph?
Hi all, Just a quick question on using a symbol line graph, is there any way to have the key shown in the same order as the data is presented on the chart? I.e. in the example below I'd like the triangle to be at the top of my list, then the square etc. Thanks in advance!
-
How do I flip the x axis on a vertical bar chart?
I have a vertical bar chart that has a goal of 25. The user is confused because the goal is "anything under 25 is good" but with how the chart looks it looks like you are trying to reach 25 because the goal is set at the top of the card. Is there a way to flip it so that the x axis is at the top of the card and thus makes…
-
Using Weighted Data with Cards
When working with data and building cards, is there any way to utilize beast modes to apply a weighted value across multiple variables? There is a weight variable within the dataset, and we are trying to apply those varying weights and display the updated values on a dashboard. Does the SQL syntax have the capability of…
-
Multi-Value Card - Revenue and YOY % Change
Hello Community, I need help creating a multi-value card in Domo to show total revenue and year-over-year percentage change based on filter selection. The requirements are: Yearly Comparison: If for example FY25 is selected, show FY25 revenue and compare it with FY24. Similarly, for other fiscal years. Monthly Comparison:…
-
Compare to Budget - Actuals in one Dataset and Budget Values in second Dataset
Hi community, BLUF: How can I compare budget to actual? We have data in one system that holds our actual sales amounts. We have data in a separate system that holds the budgeted sales amounts. I want to show the actuals and the budgeted in the same card. This seems easy enough in theory, but I've been struggling to…
-
Toggle Series through a filter
Hi, I want to build a sales dashboard that allows me to cut the data by selecting the relevant data series from a slicer. example: Bar chart showing sales by month with various drill down options. Currently I will need to build 4 more charts that show the bars split down by each of, country, agent, Product, Channel.
-
Identifying what data came from which connector on a card.
Hello all, and thank you for any help. I have my magic ETL flow built out so a report is pulling information from two different connectors. There does not seem to be a batch ID or file path as options for me to select, which I thought would be the method to identify which system they pull from. Does anyone know how to…
-
Multi-Line Chart with a "Stacked" Y-Axis?
Hi, is there a way to create a multi-line chart with a "stacked" y-axis? I've been able to do this in Tableau, yet I can't find an easy way to accomplish this in Domo. I've attached a screenshot of how it looks in Tableau. Here you can see that each line has its "own" y-axis. Having all of these on the same y-axis makes…
-
Can you fix the headers in a pivot table
Hi All, I have a pivot table in my dashboard showing a last 12 month trend in the columns and a list on people in the y column - the issue I'm having is if I filter for a specific person then the columns with no data disappear i.e. if there is only quarterly data my picot will only show 4 columns. Ideally I want to fix the…
-
Trellis/Tiered Date Settings - Bug/Enhancement
When using the tiered date settings on a normal calendar, it displays the quarter and year - It would be good to be able to customise the display format like the category scale. This would enable having one or the other if both aren't wanted. Currently, the Tiered date settings don't appear work with a fiscal calendar. A…