-
How to get % of total in Nested Bar and Line Chart
I'm trying to utilize the nested bar and line chart to determine to show how many of our signed staff actually start vs. drop out in onboarding. Currently, I have the chart as a nested bar and it works well but when I switch it to nested bar and line, I'm not able to achieve my goals. As some background, the current chart…
-
How can I make the legend of my bar chart display the value?
I'd like my bar chart to show how many answered "Yes" and "No" but can't seem to find where to set that. The legend only says "Yes" and "No" I've attached a screenshot. Any help would be appreciated.
-
Aggregate count function does not work in the denominator
When I use the following statement in a card summary, it works properly. But when use it as a value in a Single Value card, the count function doesn't work anymore: SUM(CASE WHEN ROUND(100*`Score`/`PossibleScore`)>=60 THEN 1 ELSE 0 END) / COUNT( `AttemptNumber`) For more context, the Attemptnumber column has 450 rows where…
-
"The Pivot Table is Only Showing Part of the Data" Error
In our KPI cards using pivot tables, I keep getting the following error. ”This pivot table is only showing part of the data. The visible rows and/or columns are incomplete.” There doesn't seem to be anything wrong with the DataSet, and I have not been able to identify the cause. Has anyone else had a similar error?
-
Schedule Dashboard To Include CSV Attachments
Hey all, I am trying to figure out if it is possible to schedule a dashboard with 3 table cards to include those cards as csv attachments when emailed. My alternative is to schedule those cards one by one, download them, create a new email and attach each csv, then forward them onto the customer, but I was hoping to remove…
-
How can you customized a label when using defined time period.
-
Faceted bar chart gone
Is anyone else missing the faceted bar chart options now? I was able to select this a short time ago, now the option is gone.
-
How to get correct bubble sizes on a lat/long map
Bubble sizes on the lat/long map are not appearing correctly in the legend. First, the smallest I am able to get the bubble (using the "small" scale marker) is still very large, and it does not correspond to the size of the bubble that appears in the legend. In the screenshot attached, I circled a bubble with a value of 1,…
-
% of Total Using Distinct Count
I need to show a % Total of Accounts in the below card. I used the following to get the below % of Total accounts. However, there are multiple rows per account name. The # of Accounts column is calculating a Distinct Count, but the % of Total appears to be calculating of the # of rows, not a distinct count of the Account…
-
Plot two lines (separate metrics) on a Line Chart
Hello -- I thought this would be simple put perhaps not. I have email open rate & email bounce rate as green measures. They are both % 0-100 so only need a single Y axis, and plotted by week so single X axis. Unfortunately it appears Domo does not have the option to plot two line charts together. I get that I can mangle…
-
Locked dashboards and locked cards
Hi, Could someone confirm this is the correct behaviour. I have locked a dashboard and shared it with colleagues who have the standard editor role within domo. While they can't choose edit dashboard at the top right they can edit any card within the dashboard. Do I have to lock each card individually?
-
CSV size limitation in scheduled reports
Hello, we've noticed a modification in scheduled reports (with CSV file attached). In recent days, the CSV attached to our scheduled report is limited to 25K. Do you know if there was a modification of attached files (CSV) to a scheduled report recently ? Is there a way to remove this limit ? Thank you for your help. Michel
-
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…
-
Grouping up columns to do a margin analysis
I am trying to match YTD net sales with YTD Cogs by product line to create a margin analysis in DOMO. I have the beastmodes calculating the correct YTD formulas but the columns are not on the same rows? I am not sure why but they are shifting duplicates of the rows downwards to show 2 different products per net sale and…
-
Missing Values in Quick Filter
Hi, I have a dimension field added in quick filter but it does not shows all values. It is a string field and when added to quick filter it shows up in ascending order and if I scroll down to the filter I can see only until letter 'G'. Can someone help me debug this?
-
How can I display % change against last year's week in Dynamic Textbox?
Hello everyone, I am trying to create a little bit of dashboard storytelling and show the % change from week X in 2022 against week X in 2021. I am looking to do that inside the dynamic textbox. Is that possible? Thank you so much
-
Line and bar combinations help
Hi, I am trying to create a chart by weeks showing Sales as a bar Budget as a bar and then the variance between the 2 as a line. I want the scale for the variance to be on the right hand side and the scale for sales and budget on the left. I am trying lots of combinations but can't seem to find the one that fits. Would…
-
Variance bar line cards - multiple variance lines question
I have a yoy card with three bars and two variance lines. I only want the variance line to show for the current period. I tried unselecting it in analyzer and saving, but that does not work. I also tried unselecting it while viewing it and saving the card and that doesn't work either. Any other suggestions?
-
Image Cards - using SVG Files
I can't seem to upload an SVG image to put on my dashboard as a header. Is this not allowed?
-
Multicolour background in multiline chart in DOMO
Hey, I would like to add multiple scale markers in the multiline chart. I would like to divide Y-axis in 3 ranges and add colour based on range. Is there any solution for this? Thanks in advance !
-
Can we default the "Show description on Card Details" to be unchecked in our instance, please? This
-
Is it possible to build a map at the Census tract level?
I'm looking to visualize some data set at the Census tract level, but can't seem to find a card or app that does this. Is this possible? If so, what are my options here?
-
🎥📅 Build DDX Bricks in Domo - free webinar 11/2/2022 - with Noah Finberg
Overview DataCrew is excited to invite Noah Finberg, Manager of Data App Innovation @ Domo, LinkedIn, to present a 202-level overview of DDX bricks. In this Ask Me Anything format webinar, the Domo community will have the opportunity to learn more about use cases for DDX Bricks as well as get an introduction to app…
-
Customize dashboard export?
Hi, is there any way to customize my PDF or PPT exports of my dashboard? I would like to remove the title of the dashboard from the top of every slide, as well as the filters at the bottom. Also, if there's any way to customize the first title slide that would be great. Thank you.
-
Can't add an existing card
I'm pretty new to Domo so I can't tell if this is a bug, permissions issue, or something else. I added some data, created a card, and was trying to add the card to a dashboard, but keep getting a spinning circle when I try to add that card. I can't even view any cards either - I get the same spinning circle. When the…
-
Create a Bar + line combo chart with 2 y-axis variables
Goal is to create something like attached with 2 variables on y-axis. The bars would represent sales dollars and the line would represent payment rate. Series would be store location. Scrolled through other posts on the site and found that they only worked for 1 y-axis variable. Greatly appreciate your help!
-
Sum multiple values for the same Invoices
Hello, I have a dataset that contains multiple rows of orders. I got an account number that represents the same client but the same client can have multiple orders. I would like to create a transformation that would SUM revenues and expenses that are all assigned to the same account number that represent 1 unique customer.…
-
Can I use a year filter in a column while simultaneously not using it while building a table?
On the left is a breakdown of all 2022 loans by county - on the right is an all time breakdown by county. Is there any way to include these both in the same table? im having trouble trying to show both instances in the same visualization Any suggestions?
-
5 closest in proximity for a single column
I have 3 columns. 1 is the our store, 2 is our competitors, and 3 is our competitors proximity to our store. I am trying to use a table to show the 5 closest comps to our stores. How can I use a beastmode to show the 5 closest comps for each store?
-
Help - Period over Period w/ Beast Mode Week Field
I am wanting do a year over year comparison that uses a beast mode date field for the X axis. The idea is to get actual dates of the week instead of using Week 1-2022, Week 2-2022,etc. It looks like the option to do YoY comparison is not valid when I try to do that. See image below. I am also inserting a view of my beast…