-
Multiple measures in one card?
Hi All, Is there an option for inputting multiple fields into the Pie Name? My data is structured like this example: I would like to: 1) Show the % breakdown of Total Cleans by Clean Type on a Pie/Donut Chart (% examples seen below the table) The Pie name option offers one input:
-
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…
-
Period over Period and global date selector
Hi, I have noticed if you have any period over period charts in the dashboard and on the global date selector you select a between x date and y date all period over period charts and widgets stop their comparisons to the prior periods. Is this normal? Thanks Paul
-
Smarttext showing actual dates used
Hi guys, Quick question about smarttext. I have a dashboard and the widgets show stuff like This Year etc but I want the dashboard to actually show me the dates somewhere. So if the user select last week somewhere it would have 18/07/2022 to 24/07/2022. Can this be achieved? Thanks Paul
-
How do beastmodes handle filter context?
Please can someone explain what happens under the hood when we slice beast modes (BMs) by dataset fields and/or when a filter is applied to BMs (categorical field filters/date filters) BMs using SUM() or COUNT( DISTINCT() ) when sliced or filtered don't behave as expected. (expectations being the issue). In one case, I had…
-
Can this be built with a card and beast mode without pre aggregating
HI, As the title says can this be built without having to pre aggregate the data via a view or ETL. I have hourly data for 14 days. 7th Jan 2019 to 20th Jan 2019. data set is much larger but as an example. So the data is datetime and a count figure. e.g. 07/01/2019 01:00 6 07/01/2019 02:00 9 07/01/2019 03:00 10 07/01/2019…
-
Calculating Summary Level Average of a Calculated Field
Hello, As you see below, the table breaks down weekly average transaction by week for the current period and year, how do I get the average of both weeks at the summary level? WPSA-Transaction is a calculated field that uses this formula to calculate average per week (SUM(`CY_TRANSACTION`) / COUNT(DISTINCT `STORE_ID`))…
-
Removing the borders between domo cards
Hi , I am trying to remove the borders between two cards as they are related but cannot find a way to do so.It'll be great if anyone has any suggestion. Thanks
-
How to view the status of the "prevent drilling to final data grid" checkbox for multiple cards
Is there a way to view the status of the "prevent drilling to final data grid" checkbox for multiple cards at once? I was hoping to see a column for it under the card governance table, but no luck. Thanks!
-
Customize hovering for domo slicer items
Hi, I am trying to add additional details in hover for an item in domo slicer chart.Pls let me know if any one has implemented that.
-
Automated Feeds from Verizon to Domo
We are trying to automate the data feeds from Verizon to Domo. We tried to use the email connector, but all we get from Verizon is a link. Has anyone worked on something similar? Thank you!!!
-
calculate percentage difference between 2 values which is in a column
hi all, i am new to domo and would like to seek your kindly advise regarding on my question. i make a ETL and the structure is like below. and next step i make a pivot table and segregate the "monthly_balance" by "source" (actual and budget) the next step is i want to calculate the "monthly_balance" percentage difference…
-
Card Data
Hi Guys! I have a warning about not all data being shown in my card although i have selected all rows. Does anyone know how to fix this issue? Thank you!!!
-
Pivot Table summary values
Hi all, I'm very confused about what is going on with my pivot table. The row&column totals are correct but the underlying cell values within the table are only showing a value from one part of the sum instead of the entire sum? What's worse, when I drill down, it shows the correct sum Tried moving to a Mega Table and the…
-
Filtering table -- cells can have multiple values
I have a dataset table with filters. Some cells have multiple values. Say I have a column called "Device." Row 1 can have "Desktop, mobile" and Row 2 can have "Desktop." I want to have a filter called "Desktop" that shows all rows containing any instance of "Desktop." When I do the beast mode formula: case when `Device`…
-
Dashboard display based on current time
I have a dataset with "Shift 1" and "Shift 2" values in the "Shift" column. Shift 1 is midnight-noon and Shift 2 is noon-midnight. what do you think the best way to have that dashboard update and only show the current shift based on the current_time would be, ideally using a beast mode so that during shift 2 you could…
-
Period over Period in a table
I'm attempting to do a Period over Period in a table, but want to keep the date range to previous week/month/quarter to keep it auto-updating and grouping the data in a particular way. My idea was to create a new column in ETL that is the same as the column I'm trying to do a Period over Period calculation, but from the…
-
Card Alerts
I'm working on setting up some alerts, however i can only choose the card summary number to set the alert up on. I've watched the tutorials online and they show that you can set alerts up on multiple card variables. Does anyone know how i can set the alerts up on multiple variables for one card?
-
group by and sorting by date
I have daily data (years of it) that will be grouped by category (columns summed by group), but also need it to happen within different date ranges. Last week, MTD, QTD, YTD etc. The only way I can think to do this is maybe in the ETL creating a new column with case statements for each category/date possibility, but this…
-
Quickbooks reports display
We are pulling a standard Quickbooks Online report (P&L) with the Quickbooks connector. But the report data is just individual rows. How do we display the report like a normal P&L would display in Quickbooks?
-
Can this card be built without pre aggregating the data
HI, As the title says can this be built without having to pre aggregate the data via a view or ETL. I have hourly data for 14 days. 7th Jan 2019 to 20th Jan 2019. data set is much larger but as an example. So the data is datetime and a count figure. e.g. 07/01/2019 01:00 6 07/01/2019 02:00 9 07/01/2019 03:00 10 07/01/2019…
-
Comparative Gauge using Scale Abbreviation for Value Change
Hi there! I am trying to have a comparative gauge show a value change, but the whole number and not abbreviated into thousands (K) or millions (M). I can't seem to find a way to get it to stop abbreviating on this particular card type. Any suggestions?
-
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…
-
Is there a way to combined and calculate 2 cards in 1?
I want to combine a revenue card in positive numbers and a expense card also in negative numbers to a PL card. is that possible? each revenue card and expense card shows multiple users that are already sorted in pivot table. I want to subtract expenses from the revenue per users.
-
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…
-
Domo beastmode and pivot question
Hello, I'm trying to automate a file to run calculation in DOMO on a card. In the attached I added a sample data and a pivot table to show what I'm trying to get to. I was able to get the pivot completed in DOMO, but the additional column Collection Total, I cannot figure out how to create a beast mode for this, I'm trying…
-
Capture error in a Card
We're currently using a Range Selector card to allow users to filter our data based on a MIN and MAX date. The problem is that we sometimes have no data when users initially access our platform and they see the error "Error: The maximum value is less than the minimum value" and that leads this to thing that there's an…
-
Adding a new column of data to a existing card
I have created a card in which I have mentioned which courses have distributed how many certificate but the problem is I only have Course Id in this table and I have course name in some other tables. It is possible to add that column into my card
-
Drill-path showing in dashboard
Hello! I know it is possible to see the drill path in the card details. Can we directly click on the card in a dashboard and see the table from the drill path show up directly in the dashboard (without going first to card details)? Thank you, Helena
-
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…