-
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…
-
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:…