-
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
-
Y Axis on Horizontal Bar - Allow Long Labels by Default
I was thrilled to discover the "Allow Long Labels" checkbox on the horizontal bar chart - however, I only think to go into Analyzer and apply it when I realize my labels are cut off in the first place. I would love to have Long Labels allowed by default, and we can uncheck to shorten to the ellipses version of labels Can…
-
How to visualize survey responses - 4 statements, 5 possible answers
We collected survey responses from customers for multiple programs, where they submitted their disagreement/agreement rating for 4 statements. An example of how the data is collected is attached. I would like to have a drill down that shows the distribution of those answers for each statement for only one program (bonus if…
-
Replace personal identifiable information with avatar
Has anyone ever replaced a user's information with a non-identifiable avatar in a table on a dashboard? Here is the use case: We want to show a snapshot of what was recently watched on our video streaming platform. Our model is that a group buys a subscription, and then all its members can use the platform and watch…
-
Color Coding or conditional formatting in DOMO?
I am trying to make a scorecard for budget…etc… Let's say our budget in Jan was $14,418,053 and are actuals were below that. How could I turn that budget red? and vice versa if actuals were above budget it would be green? Is this possible in DOMO yet or are there work arounds. Thanks, Garrett
-
Ability for Non-Admin Users to Use "Save as" to Duplicate Locked Cards
We would like to have published reports be locked down to prevent changes to official content, but accessible to users to manipulate unofficial copies of them. Currently, the "Save as" option (which allows for users to duplicate cards to their overview and manipulate them without changing the original card) is unavailable…
-
Aggregating Data for a Beastmode - Counting Survival Analysis
Hi there -- I have a dataset that has an individual record per employee that states if they are active or terminated and that gives their current tenure or the tenure at the time that they left the company. I'm trying to do a survival beastmode using a bar chart where I show 100% at tenure = 0, and then at tenure = 1, I…
-
Bell Curve - Large Data
Hello, I am working with a large amount of rows, due to sales items having multiple sizes/colors. Looking to build a size/bell curve to present to the client but when I use the Histogram, it doesn't group by the category names/sizes but in the table view it shows the units by group. Histogram: Thank you in advance for the…
-
Favorite Chart Type Collection - A New Dropdown Option
Hello! Has anyone ever wanted a new dropdown option in the Chart Type area for their favorite/most used charts? It would be helpful to have vetted chart types used for specific purposes in one place. Furthermore, it could also serve as a collection of "approved" chart types for business units. Would anyone else find this…
-
How to invert x/y axis at Scatter graph?
I Would like to invert y and x axis at my Scatter graph where the bottom would be the positive number and when goes up it reduces. Same for X axis. This is the card I'm trying to fix: and I want to look like this (from a excel file chart):
-
Average Session Duration Y/Y
I am importing GA4 data and trying to display Y/Y in a multivalue on a dashboard. I used SEC_TO_TIME(Avg. Session Duration) to change the data to time format, but it's still not showing appropriately. Any ideas?
-
Pivot table conditional formatting for text and column totals to the left
Hi, I have a card where I need to show a % total of an opening number and would like the text to be green if 100% or greater and red if less than 100% - in the chart properties I can set colour rules but this only seems to apply to the fill colour, is there any way to have the fill colour remain the same but have the text…
-
Edit Bar Charts more dynamically
Hi, I was hoping we could begin using Color rules a bit more dynamically. I was hoping we could assign color rules to different fields in the Card. For instance, elements that are not being used in the Bar chart but elements outside as well that are impacting the Bar chart directly For instance, if I have 3 variables in…
-
HTML Easy Brick Refreshes Unexpectedly on Interaction
HTML Easy Brick Refreshes Unexpectedly when Function to Reveal/Hide Text is Executed from Area Link We're working on developing a custom landing page where team members can click a section of our logo to reveal additional links related to that category of dashboard. In the HTML Easy Brick I was able to create area links so…
-
Can I take out columns such as "__created__," "__modified__," etc., from my collections?
I am creating a ddx brick in DOMO. My ddx brick has collections support in that when a user makes changes to the brick, the changes are written to collections. However, in addition to user changes, columns like "__created__," "__modified__," etc., are also written to collections. Here is a visual demonstrating what I am…
-
CSP Error
I am building a ddx brick in DOMO. When I am editing the card, and I click "Run," everything functions fine and works correctly. However, when I click "Save and Finish," the brick/table loads all of the Column Headers but none of the table cells, and regardless of whether or not I refresh the page, the table cells do not…
-
Average Date Calculation
Hi, Is there a way to do an average date calculation in Domo? I am working with a table that has close to 30k rows and all we are trying to do is get an average date for the date column. Is this possible? I looked in the beast mode functions and could not confirm it was in there. Thanks
-
Can I show 2 values as a stacked bar and other values as single bars?
I've been asked to create a bar chart that shows 4 values: Prior Year, Actual, Forecasted, and Goal. The request is that the Actual and Forecasted amounts would stack on top of each other for easier comparison but I'm struggling to find a chart type that will support this. I looked into the Grouped & Stacked bar chart…
-
Show Column Description on Column Hover in Table Cards
As a way of shortcutting a data dictionary card - it would be very useful if you could hover over a column title and have the column description show as hover text. Or even have the ability to add custom hover text to each column via the card editor here.
-
Option to select which fields will be shown as subtotals in pivot table
When building a pivot table, it is not possible to choose which fields will be summarized as subtotals and which will not, and for each field that is dragged to the rows, a subtotal row is added and this field divided the table's data to segments.
-
Filter behavior on dashboard/app vs Details View
I wish the default behavior for filtering via-the-legend at the dashboard/app level would mimic what happens when viewing a card in full screen/via the details view. When I click a colored block in a legend, I'm intending to remove that color from my view and allow the chart to re-scale. I think it's confusing that this…
-
allow users to duplicate (save as) locked cards
Hello, My goal is to have published reports be locked down, but accessible to users to manipulate unofficial copies of them. I would like to lock pages and cards so that only a users assigned to a group that owns the card or page (or is an admin) can edit them, but want all users with a user role that allows them to edit…