-
Calculate time between two dates during business hours, excluding holidays & Sat/Sun
Need to calculate the elapsed time/minutes between Start Date and End Date, using business hours of 9:00AM to 5:00PM, excluding Saturday/Sunday & holidays. Anyone able to help? either in Magic ETL or Beast Mode.
-
Have a row displayed with 0/NULL when filtering by date when there's no data
Tried my best to summarize in the question... I have a data set of Google Adwords Data. I'm putting the data into a Pivot table and have campaigns as a Row. I'd like to have every campaign show in the table even when it has no data to report for the selected time frame. It essentially would the the row for the campaign and…
-
Adding values to a custom chart
Hi, This one is a bit of a stinker - our organisation has limited the use of DDX bricks currently, and I need to build a risk matrix with set colouring in each square of a 5 x 5 matrix grid. Initially, the goal was to create a pivot table with cleverly hidden columns and colour rules, but as some values were 0, the colour…
-
When using a calendar card, the calendar is not shown when only one value is in the dataset.
The left picture shows the same card as the right picture, but in the left picture there is only 1 value but it doesn't show the calendar
-
Year-over-year sales chart by month
Can someone recommend how to create a chart like in this image? The table in the image is just to show how I do it in excel Thanks in advance
-
How can we apply drill down functionality between two dashboards in domo?
I have two dashboards. When user click on 1st dashboard's any record then it will redirect to 2nd dashboard and also apply filter on 2nd dashboard according to 1st dashboard's report.
-
Sample Data in Business-in-a-Box
Is it possible for an Admin to hide all sample data from other users within business in a box? I see it can be done per card but looking for a faster way to do this.
-
Radio Button Filter Card - Set the default selection?
Hello, I have a Radio Button Filter Card on my page. I'd like a default value to be selected on this card. However, I can't seem to find a property that enables that. When i use Page filters to set a default selection the user can clear the filter, or filter on multiple values (which defeats the purpose of the Radio Button…
-
Compare two peer groups
Hi, I'm not sure if this is possible using DOMO native toolset. I would love to be able to compare two peers groups performance against each other. A super simple select and compare of two things dynamically. For example if this is my data: Campaign | Money Made A | $5 B | $10 C | $20 D | $5 How can I create a card where I…
-
Can we add back button in domo dashboard?
I have two dashboard. I have added hyperlink in table data in one dashboard which is navigate to second dashboard with pfilter. It is working properly but once I navigate to second dashboard then I am not able to back first dashboard. I need to refresh the whole page. Can anyone have idea about it? How can I navigate to…
-
Highlighting "current" on slicer
I have a slicer on my page that's a list of a series of roughly 2-week time periods. Some are past, one is current, some are future, like this: 2022-p24 (past) 2022-p25 (past) 2022-p26 (past) 2023-p01 (current) 2023-p02 (future) 2023-p03 (future) Note that the parts in parentheses are not actually in the slicer-- those are…
-
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 increase the size and change the Card title font
in the above visual , How do we format( resize , Change color etc ) of the card title "APP DOWNLOADS &INSTALL BASE |By Month"
-
Why are my days of the week out of order when there is a 4-day work week?
-
Scheduled Reports
Hi Guys! Is there a way to show more than three columns in the email body for scheduled reports. I know there is an option to include an attachment, but I wanted all the columns in my card to be shown in the emailed report. Thank you 😊
-
I am needing help to create a condition in order to make a beast mode I am working on
I need this beast mode to switch its year offset based on which quarter it currently is. This is the first and most important part of the beast mode since it will effect how the data is read and written each quarter. I have come up with three ways to do this but none work, here is what I have come up with: (CASE When (CASE…
-
How to show different values in same card?
For example to show : to build a card that shows following from data: Users with no pictures Users with no organization connection Users with no job title Users with no department
-
PPT Plug-in (how to remove legends from the chart)
I am using DOMO PPT plug-in to refresh a card. However, I need to remove the legends (below) from the chart to save some space. Any idea how I can do this?
-
DDX bricks and beastmodes saved in datasets
Hi a question if i save a beast mode in a dataset why can i not refer to this field in a ddx. and will this be made available soon. i get this error status":400,"statusReason":"Bad Request","message":"DA0008: The field yAxis of data source alias dataset (mapped to data source with id 6ff2d2ee-9690-4086-someID) is mapped to…
-
How would I pull a list of column names that have no data?
Our Salesforce dev team frequently changes field names and without notifying us, so I'm trying to find an easy way to create a report showing all of the columns that contain no data as this is a sign this field was replaced with a new field or is no longer in use and we need to remove it from our ETLs and cards. Is there a…
-
YOY Progress Bars
Is there a way to compare YTD (fiscal year) this year vs the same period in another year? Current the progress bar is counting all of FY 2021 and comparing that to FY 2023, which we are only about 50% of the way though. Ideally this progress bar would show closer to 50% but I am not sure how to compare just the first 6-ish…
-
How can I create personal cards?
I have a team of people, each with responsibility for some portion of my dataset, taken from a Ticket Management system. I want to create cards and a dashboard that shows each individual on the team a series of data points about their tickets only. What is the best way to achieve this? Is it possible to auto-filter based…
-
How to hyperlink values in a Mega Table
I have a dataset I am showing in a Mega Table, which contains URLs. I'd like to hyperlink the URLs so the user can click on them and go to the site. Is there a way to do this? I've been trying to following this suggestion:…
-
Difference in Business Hours
I'm looking to get the difference in 'business' hours between two date/time fields. The business hour range is 9:00 - 17:00 (or 9am - 5pm), within weekdays. Additionally, If a user enters a Start Date after 17:00, the start date should get pushed to 9:00 of the next business day. For example, the following should have an…
-
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
-
Bubble Chart Zoom not working
Hey all! So I have set up a Bubble chart with two KPIs, one in each axis - each bubble is a store and it's size is the volume of sales. If I try to zoom in into a specific area, it will show it for one second and then that card and those around it will go blank. I can fix the cards around it by dis-enabling the filter…
-
Drill from world map to selected country
I am looking for a solution for best way to drill down from world map i.e. Lat-Long world map by selecting a particular country then being able to drill down to state/ prov of the selected country. I have downloaded all SVG maps I need but am unable to figure out best way to transition from the world map to country for…
-
How to apply a filter across 2 data sources with filter column having diff names in the data sources
I have a column called Frequency (values could be daily, weekly, monthly) in data source 1 and a column called Cadence (values could be daily, weekly, monthly) in data source 2. How can I join these two columns to apply the filter on both data sources?
-
Colour condition for words in a string
Hi Folks, Does anyone know how to create a beastmode that colour conditions each word in a string within a single cell for a table visual? For example: These values have to remain joined by the '/' delimiter so I won't simply separate them into columns. All responses appreciated Kind regards,
-
Table Cards - clicking and drilling on selected columns/rows gives wrong drill filter
Any time I use a Table Card in a drill layer (and even top level i spose) - the user can click on any of the data in the rows. For example, I may have a column that does a count Count of service requests. on a table chart that lists all properties and their respective service request counts When the user clicks on that…