-
Is there a way in Domo to show/hide columns in a table type of card ?
so I have a table card which has 10 total columns (i.e. column 1-10). I want to give an option on my end application (where I would embed my dashboard) to user to see only selected columns dynamically in this table. So a user can select that I don't want to see column 5 and column 8, so this table should hide those 2…
-
Changing color of line in line chart
Can someone please tell me how to adjust the color of a line on a line and bar chart? And also how to adjust the axis values (so the Y axis match their respective color - line or bar)?
-
MAX on dimensions on card build
Hey. I am building a card and I am aggregating data over time (ie last X days). I have this issue that I want to use MAX aggregation on dimension field, but only aggregation DOMO allows for this type fields is count. Is there a way to use MAX on these fields? Example Fields: Date, Id, name, spend Row1: 2022-01-01, 1,…
-
Color rules gone from Cards
Hi all, today I opened one of my dashboards and the Color Rules seem to be gone. I did not edit anything. Anyone else had same experiance? What could be the reason? The only thing that happened is that I run the data pull from Salesforce, but nothing on dashboards or the cards.... very strange. Thanks for any input.…
-
Slider Cards not showing all data/options
Is there any way around this issue? It's the first time I've seen it. The data set I'm using is about 43M rows. Now the Region and Record Type cards are showing all the options available but still throwing the warning. Rep is missing about 7 people.
-
Letters spilling out of card
The writing in green on the card in the attached image is going off of the card. I already have the font set to XX-small. Without changing the size of the card is there a way to either make the font smaller, or change the margins so that the whole value fits within the view?
-
See underlying data sources for a dashboard
I'm looking for a quick way to go to a dashboard and then find out which data sources are being used for any of the cards on that dashboard. If that dashboard has something like 20 cards it would be nice to be able to see a list of the data sources used. I know I can go to the data source, and then see which cards it is…
-
Column Width in Domo Dashboard
I have a card/dashboard that has quite a few columns in it. I want to be able to display the full values of some of the columns and limit the spacing of others. Is there a feature in DOMO that allows me to do that?
-
Improving Dataset performance by removing unused columns
Hi there, I have a dataset that has become sluggish and increasingly gives people problems when viewing cards or dashboards created with this dataset in terms of taking very long to load (or load at all), and is sluggish in analyzer as well. To attempt to improve performance of this dataset, I am going to remove a lot of…
-
Group in Beast Mode
Is there a calculated field in beast mode to group names for a filter? For example, data looks like this on card slicer: Customer A- UK Customer A-USA Customer A- Mexico Customer B- UK Customer B-USA Customer B- Mexico Is there way of grouping Customer As and Customer Bs together to show on the card slicer only the…
-
Date Ranges based on Calendar rather than action
I am creating a grouped bar chart where I would like to display the count of Action A and count of Action B that happen in any given week. My issue is that when creating the chart the only option I have is to base the date range on Action A or Action B rather than calendar dates. This causes a problem in that if, for…
-
How to create dynamic X range from backend or Beastmode?
At my index chart I would like to create a dynamic index when comparing 2 products. I need to sum the value sold from each product index and plot as a grouped and stacked bar chart. Sometimes I can have much more volume on "<70" that I would like to see, but to have this today I created at the backend a fixed range.
-
Adding multiple series in Grouped and Stacked Chart
Does someone know how can I create a grouped chart with 2 series? I would like to sum value from 2 products filtered and compare it on the same graph. But it's a index view, so I have to calculate the index (done at the backend of the data) and sum all value from each range I've got, like this image So I choose product 1…
-
Copying values from a table card as text
Firstly, sorry if this wasn't posted in the correct forum, wasn't sure where it would best fit in. A user wants to copy values as text from a table card. When right-clicking the only option is "copy image", this is not what they want. If you press ctrl+C, the values copy as text which is what they want. Is there a setting…
-
Is there a way to create Running Total using Beast Mode?
Hi, I'm building a table card and I would like to create a column that performs a cumulative sum, like the following: | Week | Amount | Running Total | 1 | 100 | 100 | | 2 | 50 | 150 | I tried to do this using SQL Dataflow, it works fine. However, I want to be able to add filters that modifies the Running Total and thus,…
-
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):
-
Compressing bar charts (5 across) onto page
I have a request to essentially create an executive dashboard that will display a bunch of charts, primarily bar charts (going back 13 months), 5 across... Below is a screenshot of something that was created in Power BI. Is there a way to do this in Domo....?
-
Are there any plans to expand Word Cloud formatting Options?
We are trying to break-out of the habit of using list reports and Word Cloud is a great option for some of the reports we want to produce. However, I'm really surprised that basic formatting options are not available. Are there any plans to change this? Provide formatting options to: 1) Set the number of items to designate…
-
Can someone help me with a beast mode to fix this? I would like it to start at 12a and to end at 11p
-
Total Row on a tale card is giving incorrect values
The % you see in the final column is calculated as sum "column 6"/ sum "column 1". So in this case it should have been 14/17 but I get an incorrect answer. This is because the 17 you see is after the duplicates were removed( which is what I need to see) but to calculate the value in the last column it still considers the…
-
Average
I have created a Card for volume by hour. Now the department wants a card Average volume by hour. COUNT(`Case Number`) OVER (PARTITION BY HOUR(`Created Date`)) I'm not sure if I'm doing it right as it's creating duplicate Hours and Volume. I have done it in ETL and getting the result but then I cant do filters as It's a…
-
Is there a way to only show certain totals in a Pivot Table total column?
I created a Pivot Table and added a total column. I only need some of the row totals to populate in this column. Is there a way to exclude some of the totals from reporting?
-
How to exclude BLANK values in histogram custom bins?
My beast mode calculation is the following: CASE WHEN CEILING(`Flow Velocity (ft/s)`)<= 10 THEN '0-10' WHEN CEILING(`Flow Velocity (ft/s)`)<= 50 THEN '10-50' WHEN CEILING(`Flow Velocity (ft/s)`)<= 100 THEN '50-100' WHEN CEILING(`Flow Velocity (ft/s)`)<= 150 THEN '100-150' ELSE '150+' END I have realised that any BLANK…
-
Percent of total line chart
Is there an easy way to graph percent of total on a line chart rather than the individual values? It seems like it shouldn't be too difficult but I don't see an option.
-
Inconsistent positioning of Total Labels on Bar Chart
Hi All, I have a bar chart that is graphed by month, with a series. I have selected "Show Total Label" under 'Data Label Settings'. I am not showing any other text. All the total data labels appear at the top except for 2 that appear at the base. They appear at the base because these 2 months contain a series with a…
-
Round Function Alternative
Hi, I have a question regarding decimal places in Domo. It seems that the built in Domo formatting options are designed to truncate, v.s. the MYSQL function ROUND. I would like to have some consistency with how my cards looks and I have a specific example where I need to use Truncate(which does not exist as a MYSQL…
-
Beast mode with sum of total regardless of filters
DAX for PowerBI has a few functions that enable you to ignore certain field filters, allowing you to create a total calculation of the data even if some data is filtered out. This can then be used in the denominator to calculate share % without having to include all items within a group. I think the only way to get the…
-
Colors not applied to card on dashboard
I'm seeing a weird issue where the Colors applied to a card are not applied when I view the Card on the Dashboard. When I open the Card in detail or Analyzer view, the colors are correct. I have 4 of the same cards with 1 filter changed on each, and one of the 4 cards correctly displays the colors... I do not see any…
-
Beast Mode
Hi Guys! How do I include the specific `job` selected by the user in the `you're filtering correctly' message? CASE when MIN(`Job`)=MAX(`Job`) then 'You Are Filtering Correctly' else 'Error: Select A Single Valid Job' End Thank you!!
-
Lost ability to select a Date Range Field in Analyzer
Basic Mega Table Card powered by a view of a Data Flow will not allow me to select a new field for my date range. Thanks for help. Apologies if I am posting this in the wrong area.