-
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…
-
Multiple targets on Radial Fill Gauge
A great feature would be the ability to have multiple targets with labelling on radial fill gauges. Whilst there are a number of other ways to visualise this, the radial fill gauges can be popular, and having the ability to have multiple targets would enable consistent styling when radial gauges are being used. A…
-
Need help with Date Range/ Period to Date
As you can see top right, Domo has a selection Date Range, Period to Date, and if I click on Week to Date, my 3 cards will update date dimension to current Week to Date, Month to Date, Quarter to Date. I'm trying to create a filter or a button to do same functions Period to Date: WTD, MTD, QTD, YTD without clicking on Date…
-
Weekly Average Graphed by Month
I am looking to graph sales data of the weekly average of items sold per month, not sure of the best way to accomplish this. The current dataset that I am working with is essential a transaction detail dataset coming out of NetSuite Analytics Connect, my query references several different tables but I have joined them all…
-
Building User-Generated Card
I've had a request from a stakeholder to build a dynamic card that updates a chart based on their selection of metrics. For example, the dimension may always be DATE but the user wants to be able to select from Digital Impressions, Link Clicks, and Web Visits as the metrics. And the user wants to be able to toggle between…
-
How to show a month position as at 12 months ago
Hi all, I'm working on a set of data and for one of my cards I would like to show a pie chart of the total position for the current month and a separate pie chart for the position as at 12 months ago. I'm not sure how best to show this as the date options only seem to allow for the cumulative last 12 months - I could…
-
Looking for highest volume by a specific day as well as highest volume during a specific week
Hello, I am trying to take the data below and generate which day of the week has the average/max/min on volume. I would also like to know the average/max/min by day of the week and week of the month. How would I go about doing this inside DOMO? Essentially I would like to be able to answer the business question as follows:…
-
Average Nested Bar
Good day everyone. I was trying to build a nested bar, but wanted the gray at the back to be determined by whatever aggregation we use for the calculation. So for example in the following graph, rather than showing me the bar in the back as the SUM of all the individual bars, it'd show it as the actual average of the…
-
Color Rules: Prevent table card from inheriting colors
If I set a color rule on a bar chart, and build a table card as the drill, I cannot remove the color rules from the table. The color is inherited from the bar chart, and the only change I can make is to uncolor the WHOLE table row, but I can't simply remove color in the first place. In my use case, the only reason to have…
-
Combining 2 cards? Trying to find out how to use advertised feature.
At the 1:15 mark of this ad, the user mentions combining two cards showing different but related data ending with an "overlay" of the 2 visuals at 1:50. But, it didn't go into the specifics of how it was done. Does anyone know what feature would allow this? As always, thank you in advance!
-
Total row not calculating right
I have a card displays volumes for each of my customers. In some cases, there are duplicate volume numbers, but the total row only calculates one of them. For example, if customer A has a volume of 150 and customer B also has a volume of 150, the total row only calculates customer A. Any thoughts here?
-
WEEKOFYEAR is not aligning to ISO-8601, is this correct?
Hi, I recently utilised the Week of Year function for a date column. I'm unsure if this is incrementing from 0, but the value for the 12th of Feb 2024 returns 6. I would expect it to return 7. . Can someone confirm if this is intended? It looks to use Sunday as the start of the week in this function. Best, Sam