-
Word cloud in DOMO
I see that we do not have inbuilt feature in DOMO to do the text analysis within DOMO. I have got several comments extracted from survey. I want to create the word cloud only with the words and not the entire comments which is what displayed when using the word cloud in DOMO. I want to split the comments into words and…
-
Is it possible to create a tooltip for one column in a table/card?
Say I have a column "Masked PhoneNo" that shows ***7890. Is it possible to hover over this text (usually a column in a table) and display the full PhoneNo (123-456-7890) which is a different column in my dataset?
-
Card Title and Description Text Formatting Options
Currently there are no options to format Cart Title and Description text. Potential use-cases for text formatting include: (1) to call attention to Smart Text values (2) to use title text as chart color legends (ex. see the "1. integrated text" example on this page:) Desired formatting options are to be able to use Bold,…
-
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…
-
Compare values in a series against overall average
Hi Domo community, I'm looking to create a card that shows which segments are bringing our Net Promoter Score (NPS) up or down. My idea for a visualization is below. The centre line is the monthly overall NPS and then the 4 bars (International, United States, Canada, and regional) are the series that show the different…
-
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…
-
I need to make a bar chart that combines multiple columns based on date
Simply put, I want to display how many users completed each program in Q4 2023, and I want to later be able to select a different date (so later, for example, I can see how many people completed programs in Q1 2024). I want my users to see the most popular progams during a given time period. I think a bar graph will…
-
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…
-
Histogram Buckets Beast Mode
I have created 5 buckets and I am not sure why only the last bucket is showing on a bar chart. I can see more buckets in the underlying data. Any insight on this? For reference I am using a case statement to create my buckets. Something like this. CASE WHEN (SUM(min(1)) over (partition by cat1,cat2 order by sum(value)…
-
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…
-
Pivot table values on row or column
I didn't see any posts about this in the Analyzer Ideas section, so if there is already a post out there, I will upvote that if someone can send me the link. Anyway, pivot tables should have the same functionality as Excel where you can move the values to either rows or columns. The current solution is to create yet…
-
Need an option in our domo instance to have user specific timezone.
We need an option in our domo instance to have user specific time-zone. If a user is in EST time zone, he/she could see have an option to view the date according to their time-zone rather than a universal time zone. Example: Run time of any dataset is 9PM IST but someone from EST time-zone could view the dataset run at…
-
Custom colors for waterfall chart type
Currently, the waterfall chart type is one of the only bar chart types that does not allow for custom bar colors via the Color Rules tab. I know we have some limited options for color customization with waterfall charts but these options impose some limitations in their current implementation. For example, when…
-
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…
-
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…
-
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?
-
Median Calculation
Does Domo calculate median? How so? I am building a card - a table specifically - and am looking to put median price instead of the average. How is this possible? And most efficient? Thanks
-
Looking to create a benchmarking bar chart showing +/- % from prior year
I am wanting to create a bar chart similar to below. I want the +/- % to be based on prior year CPM. I am not seeing a bar chart that would operate similarly to this - does anything have any experience with this? Thanks
-
Trying to create visuals like PBI in DOMO
Hello, I am in the process of exploring Domo visuals and charting. I am familiar with other visualization tools but want to see how I can do the same on Domo. Can someone guide me in achieving the visual I have created earlier on other tool. Motto is to see, How I can achieve it. What are the major differences I benefit…
-
Change chart sort order based on variable value.
Hi, I have created a variable that I am using on the y-axis of a bar chart. With the toggle letting switch between categorical and date values. I would like to be able to alternate how the y-axis is sorted based on which variable value is currently on the chart: Date values: The date values are calculated by year and I…
-
Download Line chart forecast values as an excel or csv
Currently, when I create a line chart forecasting values into the future, I am able to see these values okay on a chart. However, when I try to export the chart in excel/ csv format, the future dates disappear and I can only see the actual values corresponding to historical dates. Will it be possible to download this as an…
-
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
-
How to Sort by ASCII (caps first)
I have a user complaining that their pivot table column sort changed recently. It used to sort capital letters first. For example, it used to sort DOMO before David, but now it sorts David before DOMO. Now it ignores upper/lower case when sorting. I prefer ignoring case when sorting, in general, but is there a way to sort…
-
How to change color of bar charts (top 5)
Hello. Can someone help me if there's a way to use a different color to indicate the top 5 items in the bar chart dynamically?
-
Calculated line on Bar Chart not the same as Summary Average
I am trying to figure out why the calculated line for a bar chart I am creating is different the the Summary Average of the same metric. Is this a rounding issue or something else? Thanks in advance.
-
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.