-
Show Subtotal Rows - suddenly not working for my pivot tables
Hello! Previously my pivot table cards have "show subtotal rows" turned on to show the subtotal sum of certain values. I logged in today and realized that all of these pivot tables stopped showing the subtotal row, even though I didn't make any changes. Is this something that I can fix quickly? Thanks!
-
How to calculate a percentage based on another beastmode
Hi I am trying to calculate a percentage of customers who repeated, out of all customers. Basically count(distinct repeat customers) / count(distinct all customers). This has to be done in beastmode so users can select a date and the repeat customer % will be dynamic. This is the raw data, Cumulative sessions is used to…
-
Card Sharing
I am having an issue with a card on a dashboard not being visible to select users. I created the dashboard then subsequent cards and shared users to the dashboard Share Permissions Then after initial launch I added a card. I am getting users reporting that the card I added after the initial launch is not visible When I go…
-
Retention Rate from Month 0
Hi all, Wondering if it is possible to calculate the retention rate of monthly cohorts by calculating the number of active users in any month over the initial month of acquisition (Month 0). I have created the table below showing monthly active users by cohort. An example of what I'd ideally calculate is in the 2023-1 row…
-
Domo calendar
Hi, I have a calendar view that is displaying data for multiple months, is there a way to force it to show the latest month on the dashboard ? I need it to display data for March and allow the user to navigate to previous months.
-
Updating header with the last month
Hi, I have a dashboard with a header for last month (YoY), is there an option automate this ? The dashboard will always show data for the previous month.
-
Creating groups in Domo Cards
We have a quick question using the summary features of the cards. Is there a way to group data elements without creating additional columns in the datatables? For example if I have Companies A – F in my data table and want to group them: (Company A, Company B, Company C) = B2B (Company D, Company E, Company F) = B2C For…
-
Histogram Represent Y axis as %
I am using histogram card to show the distribution of users in a percentile. Currently the Y axis is using count of users and the graph is showing user count in a percentile. I would like to change this to a user % and would like to show % of users in a percentile. So for example 2% to 7% should show % of users ( 50 /…
-
Drill down to zip code map not filtering to rest of dash
Hi All, I've successfully created a drill down U.S. map card that takes you to zip code level. However, when zip code is clicked the rest of the dash is not updating. But when I click other cards on dash the drill down U.S. map is being filtered. What am I doing wrong?
-
Can You Display Keywords in Smart Text
Using summary numbers in notebook cards is extremely helpful, but is it possible to display a dynamically inserted top performing creative type, ad group or keyword using similar logic in a notebook card. In other words. Can you display a Dimension value dynamically based on a specific criteria? Thanks in advance for any…
-
Sort line chart based on datefdiff
I've a line card and a beastmode with a datediff. I want to run the line from 1 till 20 in this case. But I can't get it to work. It still displays in a random order whatever sorting option I pick. What am I doing wrong?
-
Remove demo dashboards/pages from a new user's account?
My organization has noticed that demo dashboards are being added by default to recently added user accounts. I'm unable to find a way to view/remove them. Is there any way to remove these demo dashboards through my admin account? Also, is there setting I can disable to to make sure these are not added onto future accounts?
-
Freeze Numeric Value in Pivot Table Card
Is there a way to have a value be frozen and operate independently of the column? Example attached…the highlighted column would stay static.
-
Mapbox Pick List Brick Works in Preview but Not When Saved
Hello! I installed the Mapbox Pick List Brick app and adapted the code with a custom dataset. When I use this code in the editor, it runs and works in the preview without issue. Once I save it, the map and list elements fail to load. I copied my code to Fiddle for reference: The gif shows what I see when I'm building and…
-
Period over period cards interactions with filters
Hi All, In one of my reports we're using a dataset that refreshes daily but at the end of the month we have to wait a few days for pricing on accounts to settle so the report will re-run the prior month position until rolled forward. The issue I'm having is when it comes to the end of the month all of my cards that are…
-
Is there a way to add more dataset slots to a DDX brick?
I need to add more dataset alias slots to my DDX Brick, but I can't seem to find where to do this. Does anyone know where and how this is done?
-
What is the best way to filter open-ended comments on a dashboard displaying survey results?
We have several dashboards that we've built to review customer survey data. We always have several open-ended questions/comment boxes on these surveys, with thousands of responses. Currently, I have these text responses set up as drop-down selector filter cards, which then populate table cards that are used in dashboard…
-
Number abbreviations
Hello! Is it possible to abbreviate numerical quantities displayed as currencies inside analyzer? For example, in the picture below it says 21 but that is times 1 BN. Is there a way to include the 1 BN abbreviation without having to do any sort of modification inside the ETL? Thanks!
-
How to show a unique count for a different period than the selected date range?
Hi All, I have a card where I am showing a year to date breakdown of assets, in order to show this I have 'This Year' selected for my date range. However ideally I want to show a count of unique accounts as at the end of the prior year, a count of unique accounts as at the end of the current month and the difference…
-
Prepopulate Filter
Hi hopefully this makes sense. I am trying to prepopulate a filter based on the users last input selected. The rows in my dataset have a staring city location and an ending city location to get possible routes. The first method I tried was to join every starting location on every ending location and then from there join…
-
Is there any way to hide cards on a scheduled report?
Hi All, I want to publish one of my dashboards as scheduled report however I have a few cards at the bottom of the report for validation - is there any way to keep these on my dashboard but to hide them in the scheduled report? Any help would be greatly appreciated!
-
Tracking Cards with Errors
Hey All, Our organization is trying to find a good way to keep track of cards that are broken. We want to be able to address any card errors as soon as they come up. Right now it doesn't look like any of the DomoStats or Domo Governance datasets allow to report on card errors. Curious if anyone here has had a similar need…
-
Is there a way for a DDX brick to go outside of its frame?
Looking for a solution similar to the way the dropdown filters work in dashboards, where a card/brick can have a fly out or content extend past the frame of the card in a dashboard. For instance, a small calendar widget once clicked expands into two full month views past its frame, but doesn't take up much dead space on a…
-
SORT on Pivot Table not working anymore
Hello, since a few days I have Pivot Table cards that dosen't let me sort them using the little 2 arrows in the column header ? Was working fine and then stop working. When I convert the card to mega table, it work. I'm I the only one with this trouble ?
-
What are the best practices/recommendation for displaying dashboards in the users primary language?
We are expanding our services to Puerto Rico and will need to provide dashboards, scheduled reports and visualizations in Spanish and potentially other languages. What tools or best practices have been used within Domo to support multiple languages.
-
How to change smart text in the card title to show current date/ last updated date?
Hi All, In one of my dashboards I have various cards that update daily, ideally I would like the last updated date to update in the title when refreshed so it would read "PM AuM & Flows (Mth) by Service Type (£000's) as at 23rd February 2024". I've tried using smart text in the title to use the last updated date but this…
-
Default date in Domo is Sunday, I need it to be Monday
Is there a way to change this? The reason it matters is if I am building a pivot table, and my date field is in "Columns", and I select Graph By = Week, it uses Domo's default week start date, which is a Sunday. So my columns will have week start dates that are Sundays. Problem is our company calendar runs off week start…
-
Pivot table conditional formatting for text and column totals to the left
Hi, I have a card where I need to show a % total of an opening number and would like the text to be green if 100% or greater and red if less than 100% - in the chart properties I can set colour rules but this only seems to apply to the fill colour, is there any way to have the fill colour remain the same but have the text…
-
Sort Not working as Desired
I need this Table to Sort by the Sub Total in the Total Column. But the CustName is being forced into the SORTING Option because I have selected SubTotal Rows. But I need SUBTotals selected because Each Customer has Phases. How can I Sort by SUBTotal Totals and NOT CustName?
-
Have you ever built a survey in Domo?
Has anyone ever built a working, functional, useful survey in Domo? If so - how did it go? If not - why not? Thanks!