-
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,…
-
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.
-
Beastmode YoY Variance Calc
Hi All, I am working on a beastmode that I thought would be relatively straight forward, but is giving me some issues. I am trying to do a YoY variance calc starting in 2022. The problem I am running into is that the 2021 numbers are not being subtracted out of the 2022 numbers. When I look at the previous year info, it's…
-
Date and Time - Looking at "Last Hour"
I am stumped and not sure where to go to try and figure this out. I have data being pushed into Domo where one of the columns contains date and time. I live in MST timezone. If I look at data from the "Last hour" it thinks that my last hour 7 hours in the future. How do I get my card to understand that my "Last hour" is…
-
How to calculate the total sum of a field in beast Mode
How can I calculate the total sum for a given row based on the condition. e.g. for every G_Account No. I will like to calculate total Amount, for Transaction = 0 and Transaction = 1 aggregated by year: I have used the formulala: sum(sum(`Amount`)) over (partition by year(`Posting Date`)), however it correctly calculates…
-
Create time column for Line chart
Hey guys! So I want to create a line chart that shows the sum of a total over the course of a 24 hour time period. I have a timestamp column where I extracted the time but tbh it looks weird. So I was thinking to improve the chart, is to create a column that include all time over a 24 hour period (not military time) and…
-
Mandatory Single Select Filter
I made a Pivot Table which needs 3 Single Select filters to be done by the user, otherwise it will be summing the values (which I don't want to happen because it will show the data incorrectly), so the only way to make it completely proof of human errors is making these mandatory, but I can't find this feature. I saw this…
-
How to Create a Dynamic Period over Period Beast Mode in a Table
I have a table chart that I am trying to show the percent change in sales period over period. An example would be sales grew by 5% in June 2021 vs sales in May 2021. With this, I want to be able to dynamically select a date range to view different periods of time like "previous year" or "last 12 months". Any…