-
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…
-
Single Value Card - No numeric abbreviations
Is there a way to turn off abbreviations of numbers in Single Value card? I have a card that has the value of 1023. It shows as 1.02K (I have it set to 2 decimal places). I can't find anywhere to tell Domo not to use the abbreviation on this card. (ether in the card settings or the value display settings).
-
Add 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…
-
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…