-
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…
-
How can I format the date in a YOY chart
Hi all, Is there a way to format the date in a YOY chart? The tables in domo allow for you to customize the dates (1st picture) but I am working with a YOY chart and it doesn't want to let me do the same thing. (2nd) I am trying to take the year off of description at the bottom of the Y-axis and just have the month display…
-
Numbers disappearing on bar charts with small bars
Hi, I have a dashboard with a Grouped and Stacked bar chart. Oftentimes when one of the bars is very small, the data label disappears and only shows when hovering over the bar or legend. Default: Hover: Ideally the data labels need to appear by default. No matter how much fiddling around with the chart properties I do I…
-
Filtering null values on a card
I have beastmodes to calculate change in margin over years and I am trying to filter out when all three columns are null to keep only active fields. ( If one column has a change then all three columns should show) only filter when all three are null. I made a beastmode but it seems to be giving me some trouble.
-
Aggregate on X axis (group by)
Hi, my dataset schema is something like that: account_id | selected_items I added a column for selected_items_count, so the new schema is: account_id | selected_items | selected_items_count I want to group the table by selected_items_count so that I can see the distribution of selection across the accounts, i.e., how many…
-
Holidays between two dates
Dataset A contains date_start and date_end. Dataset B is a calendar with a field called is_company_holiday. I need to figure out a way (in Magic ETL 2.0) to create a value in Dataset A that tells me the number of holidays between date_start and date_end. Anyone got any good suggestions? Thanks to previous threads that have…
-
Previous, Current, and Next Quarter Date Range in a chart
Hello, I have a GANTT chart that I'd like to show a dynamic date range of previous, current, and next quarters as a default date range. I don't see any option in the date range selector to achieve it. I can either show the previous, the current, or the next Quarter, but not all three. One hack is to choose the "All Time"…
-
Moved to beastmode section
Sorry not sure how to remove a question so just deleted content as I added under wrong section. Now in "Beastmode" forum. Thanks, Katie
-
Broken Trend Chart With No Data
I am using a Monthly Trend chart, and because one month has no data, the line is broken and does not go to 0 connected. Is there a way to make the chart show 0 for the months that do not have data? I have tried beast mode, dataflow with a calendar dataset left outer join, and it does not resolve the problem for some…
-
Yoy Change Multi Value Gauge
Is there is a way to show the Yoy % change dynamically on the multi value gauge The Default options picks the most recent data point for the Value and the penultimate data point for the comparison Hence even though no Year is selected the APP DOWNLOADS multi value card shows the value for 2022 and the comparison against…
-
How do you change the field used for the date range on a card?
I need to make a table with two date fields (report_date and report_sent_date). Domo used to allow you to choose a date field that you used in the Date Range, but now it longer lets me do that. If I just have report_date, that is the date field used on the card. But whenever I have both, it changes the date field to…
-
Month over Month % Change Formula
Hello, I'm collecting data from Google Analytics for my company's website. I'm graphing Date to Avg. Session Duration. I need to add a calculated field for Month over month % change. How do I extract months from 'Date' column here. Below is how I calculated Avg. Session Duration & have graphed it. I want to use the MoM% in…
-
Using a Beast Mode within a Beast Mode? (For Rolling Attrition)
Is this possible? I'm trying to build a rolling attrition report and I have 2 separate attrition beast calculations (one for a single month's attrition and one for more than 1 month of attrition). This works fine for showing point-in-time attrition (a year, a quarter, a month, etc.), but I've now been tasked with building…
-
I have an unexpected outcome of a beast mode calculated column, can you help?
Hey, I've been working on a dashboard that has a radio selector to select which project the dashboard presents data from. In this process, if an option is not set on the radio selector, my dashboard populates with "Please filter on Project" on most of my cards except one which is not behaving as expected. For context, each…
-
How to get last access date from completed column
want to get last completed date of unique item as can see two dates but need last complete date, how to get that
-
Map cropping out Scotland
Any idea why the map is cropping out Scotland? We don't have a pin in Scotland but we need to show the whole of the UK. I have disabled 'auto zoom to data' but it doesn't let me zoom out to show more
-
Is there a way to customize bar graphs?
Hi everyone, Is there a way to customize bar graphs? I would like to have a bar graph that display a person icon to show how many incidents occurred in that month. Does DOMO have a people icon graph?
-
Help With Beast Mode Calculation
I have a dataset that has the following Fields Agent Name - Name of the agent Agent Status= This is the state the agent was changed to . Available, Unavailable, Idle etc. EventTime = Equals the timestamp that the agent status changed to I need to calculate the time the agent was in that state, for example, Agent changed…
-
Visualization options for minutes:seconds format
I'm working with the Average Time on Site (seconds) field from Adobe Analytics. It comes through our connector as a fixed decimal and I'm using SEC_TO_TIME(`Average Time Spent on Site (seconds)`) to format the data in minutes and seconds. This works fine in a table report, but I can't find any other chart type that would…
-
Can't Graph by Month
I've merged two tables and used the following formula to make sure the date doesn't get converted to String The two tables joined successfully. But My chart doesn't let me Graph By - Month The Table format still shows as 'String' under the Date columns. What can I do maintain the dates as 'Date' format so that I can Group…