-
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…
-
Beast Mode calculation
I need to calculate average of how many applications forward to HM by all recruiters. In m the below example I have 3 forward to HM in the 'To Step' field and 5 recruiters. So the average is 3/5 = 0.6 Recruiter From Step To Step A Recruiter Screen Forward to HM A Background Check Hire C Recruiter Screen Hire C *Apply*…
-
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…
-
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…
-
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):
-
Chart Showing only Projects with Cost; how to show all projects?
Hi all, I have a simple Table Card with only two filters, one for project number, and one for project phase. 97 projects meet this criteria. One piece of information I'm displaying in the Table Card is the planned project cost. At the moment, only 50 projects have a planned project cost. The chart is only showing these 50…
-
Rank Top 5 of the week
I am trying to solve 2 things and would really appreciate your help. When I take out the Sorting filter for SUM of Quantity and Fiscal Month with week (No Aggregation), the number of quantity changes, and the number of products per week also changes. This may be a data issue but is anything odd in this card? Before: After:…
-
Percentage with Series in Bar Chart
I am trying with no success to calculate the Utilization% of our employees using a bar chart through time. I have a bar chart with the counts of days per period of time and with the requested series that are the utilization types. Formula: SUM(StaffedDays)/ SUM(AvailableDays). This is the counts bar chart that is working…
-
New application for enhanced data Viz
I wanted to inquire if there is any new application in the recent release that could enhance data viz or any other application that I should consider using to make any reports more meaningful for the client. Your insights on this matter would be greatly appreciated.
-
Best way to get multiple data types in a visualization?
Hey, I have total sales (in the millions), avg. selling price (max $20/unit) , and then a % metric. I want to have them all together in a time series chart to show trends. I can't figure this out for the life of me because I can't get them all appropriately graphed without taking one off the graph completely to see. Make…
-
Route map
Hi, Is there a way to have a route map create a triangle? The idea is to have 3 variables with different locations and to mix and match them and for them to create a triangle, however, I only see where you can put long and lat for 2 locations and not three. Is there a way to have three locations?
-
Goggle Sheets - Can a single cell be accessed and used?
I have a google sheet of goals that has a calculated cell that sums all in the column. Is there a way to access this number and use it? I have another dataset that gives me actual sales, and I want to use a filled gauge that shows actual to Goal. thanks, Brian
-
Sum of multiple filtered values
Hi, I am trying to create a % by taking a filtered value in Column A and dividing it by other, multiple filters in Column A. I am able to create the numerator, however, when creating the denominator, I can't get it to register more than one filter. I've tried 'AND' and 'OR' statements, but no avail. See below: SUM(CASE…
-
Time Line with Volume
I have a request on how to create a time Monthly Stacked bar chart of Total Retail Volume with Total Member Volume and represent it by hour for any given month. I am have issues with grouping the times between 7am to 8pm; I just get every data point for the given month I don't know how to group together. Here is a picture…
-
using IF then WHEN
Hi I want to add another variable to the above equation but can't get it to work. In my Excel days, I would use an IF statement. Here is my equation: when 'primary class' = 'supermarkets and grocery stores' THEN sum(case when `Split answer` = 'Female' then `Value` else 0 end) / sum(`Value`) Thanks Ben
-
Beast Mode calculation when data is in rows and then how to chart
Hi All I have a dataset (a sample is attached) where the 2 series I want to track are in the same column, identified by the Split Answer (i.e. male or female). I want to calculate the % split answer value by dividing the value by the sum of all values where the Split Detail is held constant (i.e. what is the % of female…
-
Create X-Axis to Only Display Day over Several Months
I am wanting to recreate the X-Axis here only showing days - then show changes MoM using lines. Ultimately, I want to create a filter that allows users to pick how many days they would like to go back and allow that to be compared. Any suggestions?
-
timestamped date to only date
Hello everyone, Is there a way to work out the formatting of dates that are originally dates with timestamps to only dates without having to change anything inside the ETL? Screenshot below: Basically, I want to remove the timestamp part and just keep the date. Is there a way to work out this formatting on the dashboard?…