-
Trying to Find the Top 10 part numbers by $'s for the year for each plant department.
I have a large table showing plant department and their part numbers with the quantity scraped / dollar amount scraped as the values. Is there a way to only show the top 10 part numbers by department in dollars? Trying to be able to always keep track of what top part numbers are being scraped. Thanks
-
Calculating Compound Annual Growth Rate
Hi, I am attempting to use beast mode to calculate the compound annual growth rate of HH AA% and P2+ AA% between the lowest and highest season year identifiers. Any ideas of how to do this? In a typical compound annual growth rate calculation we would utilize the values for both the most current period and the furthest…
-
Period Over Period Multi-Value cards zeroing out when user changes the date
Good afternoon, I have several Multi-Value cards displaying both month-over-month and year-over-year values. They work great as is - but the values change to zero when a user changes the date at the page level. Is this supposed to happen or a side-effect of shoddy card building? Thanks!
-
removing/modifying columns in charts has become difficult
Good afternoon, Recently, when columns are in charts, instead of the "x" icon appearing over the column name, when hovering over it, to remove the column from the chart, we now have to click an arrow and then click "remove". Since this change, myself and others in my organization have been having a very hard time removing…
-
Drill Path Visibility
It would be helpful to be able to see when a dataset has been used in a drill path and which cards have a drill path tied to them.
-
Printing Cards that are Longer than One Page
I know this has been brought up many times in the past and it appears that each relevant thread was closed without resolution. We need a way to be able to print or output a PDF or PPT of a card without it being cut off if it doesn't fit entirely on one page. Currently we have several reports that won't fit on a single page…
-
Hide/filter out cards on dashboard display
Hi, I was wondering if there was a way to hide cards from a dashboard under certain circumstances. For example if the data being filtered was a certain value, a specific card would disappear. This will be for clients to export dashboards to PPT and not need to clean up superfluous elements. In a similar vein, I'm also…
-
Radial Gauge Card - Customizable Gauge Ranges (e.g., High to Low)
I'm working with a customer who is using a Radial Gauge card. Their use case requires that the range of the card be sorted high to low, instead of the current low-to-high configuration. I've included a screenshot of what they are looking for. Could functionality be added to allow the range direction of the card to be…
-
Single Value Card - Footer use Todays Date mysql like a summary number?
I'm creating a card. In the footer can I put something that will reflect today's date?
-
Status tracking for hot board
I am wanting to track a hot board status for part numbers and want to use the status to track through the process. Is there a formula or beastmode that can remove the in process data once the ticket has been fulfilled and reads 'completed'. For example… Once the part number 3333-000 by Robert Storey was completed can the…
-
How to update node.js and Python version?
We have Created cards using custom react app in domo. Now, we need to upgrade to latest version due to end of support for these versions and vulnerabilities. Right now we are using below version in react app: Node.js : 12.10.0 Python : 2.7.13 We use this for Custom app development on Domo. We need to know : Which would be…
-
Move/Copy Card - Indicator and Warning
It would be really helpful if there was some visual indicator on the cards that exist on multiple pages. Similarly, it would be helpful if there was a warning when deleting a card that exists on multiple pages. Both of these would reduce the likelihood that a move/copied card being deleted or updated will adversely affect…
-
Any chance I can add in a percent change over various fields in a pivot table via window funciton?
I am doubtful that it is possible, but I'm holding out hope that somebody might have some insight. In excel I can take the values of two different cells per row to calculate a percent change, but in SQL I only know how to do this when it's isolated across a single dimension. Below is a screenshot of two pivot tables with…
-
Fiscal calendar - select like other date-related filters, bulk enable on cards, apply to beast modes
We want to use custom fiscal calendars in our subscriber instances, so our customers can have their fiscal calendars. However, a few limitations of the fiscal calendar in its current form will prevent this from being useful for our published content. We want users to be able to choose if they want to view a visualization…
-
Why would a copied card have a different Type in a duplicated beast-mode field?
I made a copy of a dashboard that copied all of the data cards as well. The copied dashboard I've been playing around with the tooltips on a map. My modified map is having some different behavior to the original map. In troubleshooting I noticed that the original's field used in Values...is Text, but in the copy, it is a…
-
Card similar to the dataset history chart
I was wondering if there is a chart type in the card builder to build something similar to the chart in the dataset history tab like this
-
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…
-
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!!!
-
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…
-
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…
-
Pendo connection: how to add a date column to a dataset?
Hello! I have created a Pendo connection to domo but a date column was not pulled over with the data. I was wanting to add a column to the dataset and put the date that the corresponds with the data but am struggling to do so. Does anyone have any ideas on how to do this?
-
% Change Columns in Pivot Table
Hi Dojo Community! My team is trying to create a card for a customer that allows them to select a range of years and/or months to compare (they will most likely view one month at a time), apply additional filters as needed, and drill into the table. The card should be structured like the screenshot below. There should be a…