-
Solution: Beast Mode & Pivot Table Aggregation Error
Use Case: This chart uses a Beast Mode code for the Rows and Values in a pivot table chart. The results provide an error that is hard to understand without knowing what is causing the issue. Based on the results, we can also see the Cases is not calculating as expected. The dataset only has 5 rows of data. The Rows column…
-
Adding Sort to Custom Values
Hi, I have a card that identifies days since last activity date: Days Since Last Activity Date: DATEDIFF(CURDATE(),Enrollment Initiative: Last Activity Date) And I made a bar chart with a custom range using this beast mode: CASE WHEN Days Since Last Activity<7 then '<7' WHEN Days Since Last Activity<30 THEN '7-30' WHEN…
-
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…
-
Pivot table: Change Subtotal to Average
Hi everyone, I am facing a problem of presenting averages as the 'Subtotal' instead of the sum as subtotal in pivot table. The following picture is the context of this issue: The columns are working days and the rows are monthly data for shop 1,2,3…. The source data is daily data. However, for this table, each cell is…
-
Multi-period projection not working with my dataset
I'm new to using multi-period projections within card properties. The good news: I was able to successfully utilize this multi-period projections feature with a nearly identical card, except I selected "fall" terms in my filters. However, when I "Saved As" to create a new chart and simply changed to "summer" terms in my…
-
Previous Month Last Year
I'm trying to make some companion comparison cards so that I can display, for example, on one card the top 10 PDFs downloaded last month this year versus another card with the same month last year. I have the data by month already, and I need to have this for each month, moving forward. Is there an easy way to set some…
-
Pivot Table Collapsing
Hi all, I used to have this card setup so the pivot table was expanded out one level and it worked fine up until a month ago. When I view the card all levels are collapsed in the dashboard view. If i go into the card to expand it out and click save, it keeps defaulting back to a fully collapsed view. This didn't happen…
-
Showing min, max, and average lines for chart with Series included
Following up from discussion here: This has been closed. But my suggestion is to offer this as a feature / option: Create min, max, and average lines based off of totals. A second option can be to create color-coded min, max, and average lines based on each individual Series, but unless there are a very small number of…
-
Is there any way to incorporate search within a table?
I have a table in my dashboard (see attached image) that I would like to incorporate search into. Is this possible?
-
Hi , Am getting the error while saving the card
This error " There was a problem saving your card, If the problem persists, contact Domo Support Team. Please assist on this.
-
How do I save my card when it throws" there was an error while saving your card'
I have tried troubleshooting the issue by refreshing, creating the beast mode calculation again, validating it , saving it and saving the card, still the same issue
-
Expand/collapse rows only working for first level of pivot
Hello. I have a pivot table with 3 values for rows. I am able to expand/collapse based upon the first value, but not the second. When I click on the "+" next to the first value it expands to out all three values … but when I click the "-" next to the second value, it collapses everything back to the first value (i.e. how…
-
Different time zone
Hi! I'm trying to configure the time zone in ETL but my query is resulting in different times when the function calculates the difference, for the same column. ETL time zone function: Imported table from SQL Server: Result after time zone changes: The date range of the table is from Feb 24 to Mar 12. From Feb 24 to Mar 8…
-
How To increase the size and change the Card title font
in the above visual , How do we format( resize , Change color etc ) of the card title "APP DOWNLOADS &INSTALL BASE |By Month"
-
How do you get rid of the max, avg and min in a chart
-
How to calculate Average
-
Shows in Analyzer but not in dashboard
Hi, I've created a YoY comparison chart by month and it shows up fine in the Analyzer mode. But when I 'Save & Close' it doesn't show up on my dashboard or through the PPT plug in. This is the view in Analyzer: Then this is what I get in the dashboard: I'm certain it's Operator error! Thanks!
-
Force a filter selection on filter card
I need (and have often needed) a way to force a selection on a filter card for a dashboard. I know I can set default values, but I need a way to ensure at least one selection is always made. Anyone found a workaround here?
-
Have a row displayed with 0/NULL when filtering by date when there's no data
Tried my best to summarize in the question... I have a data set of Google Adwords Data. I'm putting the data into a Pivot table and have campaigns as a Row. I'd like to have every campaign show in the table even when it has no data to report for the selected time frame. It essentially would the the row for the campaign and…
-
Disable the collapse option
Hi, Is there a way to disable the collapse option on a table so users cannot collapse a table. I want all rows to be visible. Thank you
-
Is there a setting to stop Legend partially hiding?
You can see in area of the card below that I've highlighted, that the top value of this Legend vanishes when I interact with the card. Can I stop this behavior? Thanks
-
Fixed symbol color on latitude-longitude maps
Hello, I'm using a latitude-longitude map chart type to display my different programs across the U.S. map. Each program is automatically assigned their unique color for the plot point (which is fine) but when I filter the data to show single program data, the plot point color changes automatically (from green to red). Is…
-
Comparing weekly data
Say I want to compare 2023 and 2024 March data. In 2023, March starts on a Wednesday. In 2024, March starts on a Friday. If I chart day of month, I can visually see the weekend gaps. I'd like to find a way to compare weeks to the previous year, that executives could easily understand. But because of the movement of the…
-
Optimizing Week Calculation in Domo: Shifting Start Day to Monday
Domo's WEEK function typically starts the week from Sunday, which might not align with your reporting needs. We'll address this limitation and guide you on how to modify the calculation to start the week on Monday instead. Solution: Adjusting the Week Calculation: Domo's environment might not directly support certain date…
-
Need to Comparison Single Value Chart
This chart should be changed based on any date range selected by user and compare the value based on the date range selected by user. For exampale if user selects 10days it should compare with prior 10 days; if 30 days prior 30 days. Is it possible to do in Domo?
-
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…
-
Using Dremio Iceberg tables and time travel feature in Domo?
Hello everybody, Is it possible to create a dashboard that utilice iceberg tables from Dremio to perform time travel? Looking for something similar to this: Thank you in advance!
-
Date Range - Last 3 mo compared to same months last year.
Hi there, I am trying to use a multi-value card in Domo and I wanted to compare the last 3 months to the same 3 months of the prior year. i.e. Dec 23, Jan 24, Feb 24 compared to Dec 22, Jan 23, Feb 23. I wasn't sure how exactly the compare to months works. Whether or not that compare to __ months would be alluding to x…
-
Bar Graph of Open Orders between Start and End Dates
I am trying to create a bar graph that will show number of open items by week or month. The data has an order with a start date and end date, and I am hoping to create just using that. The way I am doing it now, is joining with a calendar in MagicETL, but was hoping there is a way to do right on the original data.
-
Bar Graph Sorting
I am trying to create a stacked bar chart and sort by total sales. I have a field in the legend so I can see the composition of total sales. For some reason it is not sorting the chart descending by total sales like expected. What am i missing here ? setup: as you can see I have sales dollars descending in the sorting yet…
-
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):