-
Show portion total as % without showing other portions
I'd like to know how to take the percentage of a metric without showing other portions - for instance: I have footballs, basketballs, baseballs and lacross balls. If I sold 35 footballs, 25 basketballs, 20 baseballs and 20 lacrosse balls in Q1, in Q2 I sold x footballs, x basketballs etc. I want to see the percentage of…
-
Identify Null Roll-Ups in a Pivot Chart
Hi Folks, Question: How do I identify blank values in a pivot chart? I want to filter where all values are blank against any column in a pivot chart but no option. I can't do it in the ETL either because it needs to be dynamic based on a date selection. (dates are the columns) Context I have the fields 'People', 'Dates',…
-
Flip Fields in Stacked Bar Chart
Not sure why I'm getting the below bar charts to show the 2 stacked values in a different order for each. Top graph shows Call + Slides (blue) on bottom of bar, Bottom graph shows Call + Slides (green) on the top of bar. I've not been able to find anything posted and have not seen any setting in the graph settings to…
-
Creating Table Chart with Sales & Sales Last Year
I have a dataset where each dow represents a daily transaction 'date' for the 'productSKU', 'size', 'sales channe'l and also contains other columna where it sums the 'sales', 'stock on hand', 'units sold', etc I am trying to create a calculated field for 'sales last year' as a column for the 'sales' from a year ago for the…
-
Storing Projected Values
I have a graph setup giving me daily data. (e.g. sales). I've used as part of the graph "Multi-Period Projection" and set it for 5 days out. What I want to know is how accurate this is to the actual. Today is 1/31/2023 and sales was $1M, and the prejection for 2/3/2024 is $1.3M, I want to know how close the projection was…
-
Burndown chart
I am trying to create a card that shows a burndown representation of my data. My data has to do with Courses, estimated time to Complete (Duration), and Actual Hours to complete. I think to create a burndown I need a new column that gives total Duration per year of all courses due that year and then I want to be able to…
-
Identify percent of people attending current event
I am currently trying to gauge how many consistent event attendees are attending our upcoming show. For context, we have 2 events every year and every registration for an event is on a separate record which I have categorized by year between 2021-2024. I am trying to roll this up into a table that gives us a percentage of…
-
Dynamic Weekly goals
We have 2 tables: OrderDetail - which stores order info like date, sku, quantity, price, ect SalesGoals - DateWeekStart, DateWeekEnd, SkuQuantityGoal, etc Is there a way we can do a visualization that dynamically shows the weekly sales against weekly Goals? I am new to this, so I am not sure the best way to set up the sql…
-
Filter on Total Column?
Can you filter on a total column? We are using a pivot table to calculate our selling capacity per areas, per therapist discipline but hoping to remove any that have a TOTAL less than 5 for all of the disciplines in an area combined. Wondering if I am missing a simple filter options vs adding a few more beast mode…
-
Heat map totals to use AVERAGE instead of SUM
Hi folks. I have a heatmap with the values as averages of values within the data. I've asked domo to add a 'Total Row' and a 'Total Column' (red outline below) but rather than these also being averages - domo is totalling the rows/columns. I need them as averages. Any ideas? Thanks