-
Editing Capabilities
Hi, I'd like to have a bit more freedom to edit some of the visuals I work on when it comes to creating a report. For this one specifically, I would like to be able to make the font size in the legend bigger and it sounds like there isn't a way to do that.
-
Can I change the font size?
I am having trouble changing the font size on the legend of a generated report. Is there a way to do this? Do I need to do it in the card? Or do I have to use the PDF editor?
-
How to Include Subtotal Percent in Pivot Table?
When in the analyzer, I selected a pivot table Next, Chart Properties --> Subtotals --> check the box for "Show Subtotal Rows" This gives me the subtotal for each subcategory. Is there a way I can also show the percent total for each subcategory?
-
Roll up rows in table chart with similar fields
I have a dataset of brands and corresponding data. I would like to have any rows with the same ID and device to be summed up and in one row. I don't want to use ETL for this because there is another column that distinguishes these rows so they may need to be filtered separately at times. Thanks
-
Show a 0 instead of "No Data" on Map Cards
It would be great to add a feature to map cards to show a 0 instead of "No Data" on map cards. It would look a lot cleaner and save a lot of effort having to build out an ETL solution every time. If that's not doable, changing the formatting for "Hide No Data Items" would be helpful. Being able to keep the state name in…
-
Replace "No Data" with a 0 on Map Cards
How do I change a map to show a 0 instead of "No Data"? The only option I've been able to find is "Hide No Data Items", which is unusable. I couldn't find anything in the card settings, and I'm hoping it doesn't involve an ETL solution. Thanks!
-
Line chart formatting
How would I go about making one of these lines a dotted line and keep the other one how it is? Would it be in chart properties? if so, where? Thanks
-
How to change column font color
Hello! Please I would like to know if it is possible to change the font color, just the first column of a pivot table in Domo. I invested some time trying and searching the web, but I couldn't find it, if anyone knows and can share this knowledge I would be very grateful! Thank you very much
-
How can I format the date in a YOY chart
Hi all, Is there a way to format the date in a YOY chart? The tables in domo allow for you to customize the dates (1st picture) but I am working with a YOY chart and it doesn't want to let me do the same thing. (2nd) I am trying to take the year off of description at the bottom of the Y-axis and just have the month display…
-
Numbers disappearing on bar charts with small bars
Hi, I have a dashboard with a Grouped and Stacked bar chart. Oftentimes when one of the bars is very small, the data label disappears and only shows when hovering over the bar or legend. Default: Hover: Ideally the data labels need to appear by default. No matter how much fiddling around with the chart properties I do I…
-
Filtering null values on a card
I have beastmodes to calculate change in margin over years and I am trying to filter out when all three columns are null to keep only active fields. ( If one column has a change then all three columns should show) only filter when all three are null. I made a beastmode but it seems to be giving me some trouble.
-
How can I edit this card to only show one column's data label?
Hi all, Below is a visualization that shows three different data labels. Is there a way to only include the data labels for the "variance" line? We already keep the production numbers in a different table on the same dashboard so being able to clean up the visualization a little bit and only include the variance number…
-
how can i create a calculated field based off buckets?
Hi all, Recently I created pricing buckets for the amount of loan a borrower took out. This works Right now, we have two different visuals that show 2021 vs 2022 This is ok but we would rather be able to see both of these graphs in one with the different years in different colors. Is there any way to do this? The only way…
-
Trying to Count the number of Appointments in my data
I feel like this should be simple but I'm struggling with how to write the beast mode to where I get a whole number and not an average. I'm trying to count the total number of appointments in my sales data. This is what I've written: Count(`Bay Text`)/(COUNT(DISTINCT`Invoice #`)) I've attached a photo showing what the data…
-
Can you set a max number of lines on a multi-line graph?
I am working on a dashboard that utilizes a multi-line graph. For this dashboard, you filter down to the specific products that you want to compare and then look at the line graphs where they are overlaid together. This dashboard has worked fine in practice, but if anyone goes directly to the card or accidentally resets…
-
Why have the dates changed?
So I have put together a multi data source dashboard for our company. Yesterday, before everything ran overnight, all of the years worth of data was showing up. This morning, without changing any filters, the graphs are only showing about 15 years worth of data. My instinct said that somehow the update caused to data to go…
-
How to calculate % of projects assigned?
Hi there. I'm trying to setup a beast mode calculation but not sure the best approach for it. I have a column that shows the number of days it takes for a new project to get assigned for example if opened on 19 Sep, assigned on 22 Sep - it would show up as 3 days. I'm looking to do a quality check to see what percentage %…
-
Datasets join issue
I'm trying to create a card that can be used to present to budget owners how much they have currently spent for the month compared to the budget they've been given. In order to do so, I have to create a dataflow that involves joining 2 datasets; One is Netsuite, which stores all the journal entry transactions, and the…
-
Date Filter Card Will Not Toggle
Hello! This is my first time posting on the Dojo. I am trying to set up a 14-day and 30-day card filter for my org. The one used at the moment does not toggle. So if I select the 30-day card filter, it will stay at the 30-day filter if I deselect the check box or slide the slicer. It will only go back to default if I clear…
-
Is it possible to add context to legend entries
Is it possible to add context to legend entries? For example if my legend breaks things down as: pending, in-transit, out for delivery I want to be able to add hover text that says something like: pending: at the warehouse, pending shipping label creation in-transit: with delivery partner, moving between shipping…
-
How to create a card that includes top 3 rows (based on top 3 values)?
I an trying to create a card that shows the top 3 reasons for termination based on the number of responses for each reason; I would also need it to show all other reasons when you drill down. The dataset has 2 columns: Reason for termination (10+ reasons), number of responses. Thank you in advance!
-
Filter multiple months by specific days of the month
Hi - I'm looking for a way to take a card with a date range of the previous 13 months and have the ability to filter it for certain days of the month so I've got more of an apples-to-apples comparison. Ex., if today is July 15th then I want to filter the exact days to include so that other months on the card only show data…
-
How to show a specific date with an aggregate (max)
Hey guys, So I'm creating a card that looks at the sales of our employees each day and then lists the day with the max sales. Our Data is structured by transaction, so I had to create a Magic ETL to Group the sales by date and employee in order to find the max by day. The problem I'm having is when I try and display the…
-
How specific can I get with dynamic scale markers?
Hi all, I'm working on a year-over-year card where I want to add a goal line that represents a 10% reduction from the previous year. However, this is a card that I have a slicer for, so I want that line to be dynamic as the data changes. Is that possible? The furthest I was able to get was to create a percentage scale…
-
Independent filtering within a dashboard, using the same column
Hi, I have a dashboard that tracks our current sales performance for the day with various comparisons, which works great. I've had a request to produce a version of this that would allow end users to select two dates, and then comparisons would run between these dates. I'd need to filter different cards, with different…
-
How do I change the data from being horizontal to vertical using a calculated field?
My data is currently horizontal so each column has a different month with the totals below (example below). I would like the data to be vertical so that it is easier to display the data visually within domo. I have placed an example below. I am not sure how to make a calculated field to display the date and totals…
-
Period over Period - Specific Date Field instead of Current Date
We want to use the Period over Period charts since they make comparisons between different periods very quickly. As you know there are some requisites to build a PoP chart and one of them is the "Date Range". We noticed that this field takes into account the current date so, for instance, "This Year" today it will give the…
-
Analyzer - Filters get rearranged alphabetized after saving.
Hello, I noticed recently that after I save a card and go back in the analyzer all the filters used to filter my data to build the card are getting rearranged alphabetized. I rearrange them and hit save..BOOM! rearranged again. This is not how it always has been and is becoming very annoying. Is there a new option that I…
-
Unique Count based on Revenue Amount
Hi All, I am working on a beast mode to count the number of contacts that have generated greater than $100k in revenue. I've tried the beast mode below, but it's only pulling null values. I kind of expected this to not work, but had to give it a try. (CASE when `Revenue Amount (Global)` > 100000 then COUNT(DISTINCT…