-
Pivot Table to allow Sorting by Column vs. Grouping
We need a setting to switch whether columns should group the values (current behavior) or sort them when using pivot tables. By default, pivot tables will group all your Values by the columns you select which is useful when you want to see how a specific group is performing on a linear succession, like: But often you want…
-
Stacked Waterfall Graph
Please could a stacked waterfall chart be added as a standard card type within Domo? Here's an example from the web. Thanks!
-
Pivot Table Week over Week % Change
I want to show the WoW % change for my data but not really sure how to go about it. My raw data is daily and I grouped it into weeks in the pivot table. I want to add a column to my table where it will show the % change of sales from the previous week.
-
Top N items in tree map
I'm working on a tree map and its way too clutter due to the large number of items in the data. Is there way to limit the number of items showing in a tree map? I want the top N items based off sales.
-
How to show Actual Grand Total rather than "Grand Total"
Hello, I have a card built that only has two columns, and both columns have numerical values that I need to see a total of. However, when I activate the Grand Total option for the card, instead of showing an actual total it has the "Grand Total" text since it is the first column on the card, and I cannot add any other…
-
Drill improvements/Default Colour Rule settings.
Hi! I often build a base table for most of my cards, something that is usually a pretty bloated process as there is no real way to duplicate drill views unless you copy/save them as a card. When building a table and adjusting colour rules, experienced users will note the difference in options available where the user can…
-
Drill in from Aggregated Column
Currently if you have a table card that only shows aggregated values (eg a count of records or sum of values) your drill path will filter to the aggregated value instead of records related to the field that is aggregated. It would be great to have the drill path filter to the records related to the aggregated value, i.e.…
-
Faceted Bar Chart Labels
I'm using a Faceted Bar Chart to show a conversion metric for sales. It's probably my favorite chart I've used so far and really scratches an itch my end users have had. It's pretty basic, it has a sum of opportunities, a sum of sales, and the resulting conversion. My issue that I'm having is the label on the right side of…
-
Filter by Rank?
Hi, I am trying to show and display the top 10 values of my 'physical vacancy' column listed below. I know I can go in and create a new column that shows rank but I don't want to alter the dataset. Is there a way to do this using a filter on the card? Sometimes the data changes so the top 10 today will not always be the…
-
Calculating a final value from two selected values that exist in the same column?
I have two columns—one column has revenue, the other column states which quarter the revenue was collected in. Is there a way that allows a user to select a quarter to calculate the difference in revenue between the selected quarter and another selected quarter. So, I am basically looking for a solution that would enable…
-
Defaults for Card Types
To keep consistency with how data is presented across multiple dashboards, you'll either need to have a template of each card you want to use with the customization you want to use by default, or be sure to manually recall what you want each one to look like. Would be great if by card type, we could customize some of the…
-
I want to add the Min, Max and average lines to a stacked graph ...how do I do that?
At the moment Min/Max/Avg is only available when you don't add series. Once you have series on a stacked bar for example you automatically lose your Min/Max/Avgs. Is it possible to add it?
-
Option to label the date range on a card
I often hide the date range on card details because there is no way to indicate what the range is for. Launch date? Expiration date? Data upload date? Would LOVE to see a text box perhaps here (yellow highlight below) that would allow me to write text before the date range. In the example above, I would write "Activity…
-
How do I remove the "Warning: Not All the Data is Shown" from a filter?
I'm adding a filter to categorize our sales into 3 groups. I get this message no matter what settings/chart types I try. Screenshots show all-time for the date field, but when I tried to do the bare minimum needed for the page it's on (one year) I still get the message. How do I remove this? Any workarounds or…
-
Is there a way to bucket columns similar to excel in DOMO?
I am trying to have a pivot table that shows weekly plans vs actuals. Is there a way to add a top layer of that to group the value columns into the top three pillars? Supply, demand, revenue. Thanks
-
Colour change depending if beating last years amounts
I have a bar graph with a comparison line showing the previous year. I want the bar to show a different colour depending on if were beating the previous year or not. e.g. red if under and green if over.
-
Pivot Table Sorting
I have a card that shows total sales by sales rep (count and volume) for the previous quarter. I'm trying to sort top down by count, then volume for the previous quarter but I keep running into issues. When I add the date field (so the oldest month appears on the left) I can't get the totals to sort properly either by…
-
Filter metric by Beast mode dimensions
I have a Beast mode that configures source and medium dimensions into broad categories because Google's default channel grouping dimension is incomplete. (CASE WHEN Session Medium LIKE 'cpc' THEN 'Search' WHEN Session Medium LIKE 'paidsocial' THEN 'Social' WHEN Session Source LIKE 'google' OR Session Source LIKE 'bing' OR…
-
Beast Mode - Checking data from a different row to generate result
I'd like to create a Beast Mode that takes a value and checks it against another row in my table. I have a bunch of human annotation data. I want to look at a content_id and then flag if that content_id has been in the QC job. I've made a rough sketch of how the data looks (apologies for the formatting. This is my first…
-
Scatter Chart
I would like to create a card that shows the revenue we make from each customer in a scatter chart where the size of the bubble depends on the profitability of each customer. i am very new to Domo so please bear with me
-
Unable to Display Stacked Bar Due to Partition Beast Mode
At the base, my dataset is broken up by employeeID, months, and planID. For each of the employees, month and plan; the employee receives a $ value based on performance, called "Earned" and they also have a column "Funded" that indicates what they were funded for the plan and month. I am trying to create a card that…
-
Stack-Bar Line Graphs
Hello, I'm trying to create a Stacked Bar Line Graph where I am able to have a the below bar graph broken out by month with an additional line graph, that graph consists of revenue numbers split by whether they fall under one of two catagories. The line graph I am trying to add would be a count of all the opportunities…
-
Best Way to compare Events
Hello! im trying to make a flexible card that is able to compare two points of time based of events that might have happend. For example this current period vs the school holidays fortnight. Or Event A vs Event B where the events are easily changed to different periods
-
Any way to get text value from one column based on text value of another column?
I've got a data set that is a series of user and assistant responses. I'm trying to build a table visualization that will show me all user questions where the assistant did not have an answer. My thought was that I could search for the default “no answer” response in the assistant response columns, but am stuck at how to…
-
Display volume bar and 100% stacked bar chart as 2 options for a same card in a page
Hi I want to reduce the clutter in the dashboard page, hence I would want to see the bar chart and the 100% stacked bar chart in the same card when each of these options are selected as slicers at the dashboard level. I want to avoid displaying 2 separate cards as it consumes more space. Is that possible?
-
Card Border Color Enhancement
Currently, we can only change the background color of cards. It would be a nice to have a functionality that will allow us to add border color so that we can easily differentiate similar components or for users to recognize the separation of each cards on the dashboard.
-
Percent Change Beast Mode Calculation
I cannot figure out how to do the beast mode calculation for this. I would like a percent change column for the most recent month to the current month? How would I do this? I've tried watching videos and this data seems to be set up differently then those videos.
-
Breakdown of Yes or No Values
I am looking to create a graph or table that shows a breakdown of who answered yes and who answered no in a specific state. E.x. in GA 100 people took the survey, 45 answered “Yes” and 55 answered “No” in FL 50 people took the survey, 20 answered “Yes” and 30 answered “No” What graph/table would you use to display this in…
-
Multiple Events aligned on a single Calendar Card
Hi, As the title suggests, it would be good to be able to add more than one Event field and date field populating the same calendar card (even if they have different date fields) and to be able to control what the output of the data label on each day of a calendar looks like in a month view instead of having to force a…
-
Checkbox Selector not showing all values?
Good morning, While trying to create a Checkbox Selector to use as a filter, I've run into an issue where the card is only showing some values instead of them all. It's not even a massive data set; it's 15 values. However, when creating the card I see the dreaded "Warning: Not all data is shown" message (14 of the 15 are…