-
Beast mode to only show matching creative types in grouped bar chart?
We are using a grouped bar chart to compare client and typical engagement rates by creative type (see 1st screen grab). The report is filtered by a SalesQuote field where client results have one value and typical results='Banner Average'. These are unique rows in the data set (see 2nd screen grab). There are six 'Banner…
-
Export Dashboard as Multiple Excel Files
We have a dashboard that has 4 different tables and we want to schedule a report to send these as either 4 different Excel files or 1 file with different tabs for each table. We're going to send these reports to people outside of our Domo instance, so the Excel file is a must. Is something like this possible? If not, is…
-
IncreasingTooltip Fields Number
I was wondering if there was a way to show more hovering options in a heatmap than the below Replacement Macros. I am trying to show more field values when I am hovering and I ran out based on the options available. In essence, I am trying to find a way to increase the number of Tooltip Fields available so that I can…
-
Export card to Excel with card filter values, card title and description
Hi, I would like to request a feature to allow exporting card to Excel format with Header section including Card title, Card description and Filter values as this is a highly requested feature from our end users. We can do it in PowerBI, AWS QuickSight easily. Hope to see this new feature soon. Thank you for considering.
-
Ability to color code the "Other" Category for Pie and Donut Charts
Somewhere in the settings for pie and donut charts it would be great to be able to hard-code a color for the "Other" category that gets created when there are many items in the series. We have a lot of color rules setup for various fields and it is annoying/hard to read pie charts when the "Other" category's color keeps…
-
Deleted Users and Scheduled Reports
I would like to know if deleted users will continue to receive reports. After a user is deleted I am still able to view their account by using their Account Id in the url .domo.com/admin/people/<AccountID>tab=profile . So I know Domo retains their data but I'm unsure whether scheduled reports will still be sent to their…
-
August 2023 Community Forum Highlights
Hello Domo Community! 👋 August has been a standout month with many new users joining and interacting with the forum. We appreciate everyone’s efforts as you continue to find new and creative solutions to your daily challenges. You put the INTELLIGENCE in BI! Leader Board's Top 3 Are we really that surprised to see these…
-
Connect DomoStats Across Instances
Need the ability to get Domostats for multiple instances under the main instance. We use separate instances to keep our clients info separate from others while our company utilizes the main instance as storage of all information. The issue is keeping track of users login information and who is in these instances are not…
-
Can you use Magic ETL to 'explode' table of transactions to all days?
Table A has transactions that show an item's "Old Status" and "New Status" along with the date of the transaction. For example, row 1 shows that item XYZ changed from "Regular Price" to "Promo Price" on 1/1/2023. Row 2 shows that item XYZ changed from "Promo Price" to "Regular Price" on 1/4/2023. Row 3 shows that item XYZ…
-
Select all/none with a filter card
I am building a domo embed/everywhere page and want to have the ability to filter by country/countries across all cards. I have tried using the differnet Filter cards and teh most suitable seems to be the 'Checkbox Selector' however this does not appear to have a select all/none option whic make the filter extremely…
-
Allow heatmap tables to compare to other columns
Currently, when setting color rules for a heatmap table, we can only compare the values to a constant value. It would be very helpful if we could compare the values to another column in the table as well.
-
How would I get a percent change for each t value from baseline and chart it as a bar line graph
/* Get RCI avg of all scores that aren't baseline CASE WHEN `summary_order_rule` > 1 THEN AVG(`RCI`) Get RCI avg of all scroes that are baseline CASE WHEN `summary_order_rule` = 1 THEN AVG(`RCI`) END Get %change between baseline and followup scores for each summary order ((avg_followup - avg_baseline) / avg_baseline) * 100…
-
MySQL Rank over Partition/Window Functions
Hello! I know there was a post in September 2018 talking about how Domo's MySQL version doesn't support Window functions thus you can't do Rank over partitions in MySQL dataflows - anyone if this is planning to change? It's cumbersome to have to kick out datasets to Magic just so I can rank them using partitions. Thanks!
-
Outage/Long Load Times
Anyone else experiencing service disruptions this morning? I'm struggling to load pages, save ETLs, load cards, etc.
-
Instance Hygiene
Trying to clean up an instance and find where data can be a visualization vs. ETL. Wish to remove cards that not have been used in the last 6 months. When looking at "last view" timestamp, which is accurate when it comes to page vs. card? For example, cards exists that have not been looked at, but these have appeared on…
-
Charts with multiple columns on X axis
I want to create a chart in DOMO with multiple columns on X axis in the below way? How can this be done? I tried to add multiple columns on the X axis but it doesn't take.
-
Cookies on Domo Everywhere
Ability to access Domo embed via Edge requires user intervention for them to "Request cookie access". This is to do with blocking third party cookies. Users using Safari are unable to login at all preventing their ability to use Domo embed. Can we speed up the process to enable a cookieless seamless cross browser…
-
Hyperlink to Sharepoint
Hi, I want to create a hyperlink to a sharepoint file from my domo card. The hyperlink is working correctly to the sharepoint destination. I would like the user to be able to choose a record and be taken to the matching record using the link, the only field I have to utilize is 'Name'. I found a discussion with this…
-
Add Legend Position options to card Appearance settings on dashboard
Currently the position of a card's legend can only be configured within Analyzer, which means that the legend will appear in the same location in every dashboard where that card exists. Depending on the layout used the legend can take up too much space on the dashboard, so it would be nice to be able to configure the…
-
CY vs PY and Multiline Chart
Hi All, I am trying to build a multiline chart that would have 2 Y-axis line chart. Y1 Axis to show Cumulative Line of YTD Sales vs PY to Date Sales and Y2 Axis to show YTD Average Sales vs PY to Date average sales. I have tried all the available line charts and seems not to be the one as per the picture attached. Also,…
-
Default Dashboard instead of Overview?
Hi friends! Is it possible to have users open Domo to a specific dashboard each time, rather than to the Overview? Thanks
-
Filtering on an Aggregate FIeld
Hi everyone. I'm a novice at SQL and more specifically, DOMO. This is also my very first post on this forum so forgive me if I've not followed a proper format or given enough specifics upon first request. I currently have a table card that aggregates a dataset by sum. For example, there are 4 line items and I have a BEAST…
-
Help use a beast mode to dynamically filter a dataset
I have a beast mode that returns the name of the current day. I want to filter a dataset to show only the rows where the Day column in my dataset are equal to the name of the current day. Can someone help?
-
Unpivot and Pivot
Happy Friday! I'm not sure how to start. The data in the yellow section is what I currently have in the magic ETL. I want the result to look like the data in the green section. I've tried to Unpivot the data and Pivot them but have been unsuccessful. Could someone shed some light on this issue? Thank you very much!
-
Expansion of Current Week
Hello, We have a weekly bookings pivot that is currently collapsed on the subtotals by WE. However, we're looking to expand this but only for the current week. If I expand the current week, say WE= 9/01 and save it with that expanded, when we get into WE= 9/08 will it automatically collapse 9/01 and expand 9/08 or will it…
-
CY vs PY and Multiline Chart
Hi All, I am trying to build a multiline chart that would have 2 Y-axis line chart. Y1 Axis to show Cumulative Line of YTD Sales vs PY to Date Sales and Y2 Axis to show YTD Average Sales vs PY to Date average sales. I have tried all the available line charts and seems not to be the one as per the picture attached. Also,…
-
Pivot Table switch values to show as columns or rows
Been working with Pivot tables for a while now, and one of the huge things I miss is the ability of selecting whether the values should be displayed as Columns vs Rows, something that you have in simple spreadsheet programs. This has proven useful when you want to show the same metric by different aggregations for example,…
-
Month Over Month % Change of Total Number
I have revenue figures recorded at random intervals of days throughout months. It has not been updated since June, so I cannot use the automatic date filters in Domo without manually going in every month it gets updated and changing things around. I was able to get the most recently updated month and the prior month totals…
-
FIXED Function As Background Filter
I have a headcount dashboard where I would like the cards to render 0 values in case of any filter combination resulting in the headcount <3. I created a beast mode calculation using fixed function to use it as a background filter in the cards. however when I am adding it to the cards and try to save it, it throws an error…
-
Help Pivoting Data
I have a file where I want to have each row show me the charges based on either the charge code or charge name. In this example, I used the name. I have looked at the data online, and in the ELT. The problem with I’m seeing in the ELT is I would have list the name of every code we have in the number 3 position (shown in…