-
Option to remove page numbers/filters on export to PDF
We often export dashboards to PowerPoint or PDF to share with external partners. However, we don't always want to include all information from the dashboard, but since the page number on PDF is automatically included, it looks strange if some pages are missing from the report. It would be incredibly helpful if there was an…
-
routing ETL failures through zapier
Is it possible to send ETL failure messages to Slack using Zapier or a similar service?
-
Remove character limit on filters
We have many dashboards displaying survey data, which include a lot of open-ended responses/long text comments. Our sales staff need to be able to filter to a specific partner's survey responses, and select specific comments for inclusion in an exported report for the partner. Currently, I have these text responses set up…
-
How to get 2 decimal places only
Hi, I am using a beast mode calculation that results in a ratio for forward to manager : hire CONCAT(Sum(CASE WHEN To Step = 'Forward to HM'THEN 1 ELSE 0 END)/(COUNT(DISTINCT Requisition Number)) , ':', Sum(CASE WHEN To Step = 'Hire'THEN 1 ELSE 0 END)/(COUNT(DISTINCT Requisition Number)) ) The result is this: How do I get…
-
Grand Total Beast Mode not calculating correctly
The beast mode below is not calculating correctly in the Grand Total Column. CASE WHEN SUM(IFNULL(`Billed Amount`,0)) = 0 THEN 0 ELSE (((SUM(IFNULL(ABS(`Billed Amount`),0))) - (SUM(IFNULL(`Actual Material Cost`,0)) + (SUM(IFNULL(`Actual Labor Cost`,0)))))) / SUM(IFNULL(`Billed Amount`,0)) END
-
WEEKOFYEAR is not aligning to ISO-8601, is this correct?
Hi, I recently utilised the Week of Year function for a date column. I'm unsure if this is incrementing from 0, but the value for the 12th of Feb 2024 returns 6. I would expect it to return 7. . Can someone confirm if this is intended? It looks to use Sunday as the start of the week in this function. Best, Sam
-
start of the week in the date filters
Hello! I have the date filters as presets in a dashboard, and I have already chosen 'Monday' as the first day of the week. However when I choose 'last week' in the date filters, the data are shown from Sunday to Saturday throughout the whole dashboard. Is there a way that I can have the daily data from Monday to Sunday…
-
Help with SQL query
My first post so apologies if I have dropped this in the wrong forum. I have a slightly more complex dataflow than Magic ETL will handle and I am hoping I can manage this with SQL, however my SQL is a little rusty (read metal falling apart). The requirement is possibly quite common in that I need to measure how many…
-
Auto-Collapse all Subtotal Rows
It would be great if there was an option to auto-collapse all subtotal rows. Sometimes there's so many of them where doing it manually isn't really an option, plus any new rows would appear without being collapsed.
-
Pivot table: Change Subtotal to Average
Hi everyone, I am facing a problem of presenting averages as the 'Subtotal' instead of the sum as subtotal in pivot table. The following picture is the context of this issue: The columns are working days and the rows are monthly data for shop 1,2,3…. The source data is daily data. However, for this table, each cell is…
-
App Studio - Brand Kit Availability
App Studio - Brand Kit availability to expedite custom themes within App Studio
-
Display estimated file size next to export options
It would be convenient and helpful if Domo could display a file size, either accurate or estimated, next to the Export options of Excel/CSV.
-
WORKFLOWS Q&A from Domopalooza
The product team enjoyed answering questions from the audience during the final session at Domopalooza. Below you will find the answers to all questions related to Workflows (including those that weren't mentioned on stage). Q: Can I use a WorkFlow to change a default date variable within a Domo dashboard? A: Yes, your…
-
CLOUD AMPLIFIER Q&A from Domopalooza
The product team enjoyed answering questions from the audience during the final session at Domopalooza. Below you will find the answers to all questions related to Cloud Amplifier (including those that weren't mentioned on stage). Q: If we use Cloud Amplifier with Snowflake...it will consume credits from my snowflake…
-
MAGIC ETL/DATAFLOWS Q&A from Domopalooza
The product team enjoyed answering questions from the audience during the final session at Domopalooza. Below you will find the answers to all questions related to Magic ETL and Dataflows (including those that weren't mentioned on stage). Q: When are you going to upgrade the MySQL version in MySQL DataFlows? A: We do not…
-
How do you create multi-select controls?
As far as I know Variables can only have Controls that are single selection, is there a way to create mult-select variables and by extension multi-select controls?
-
Group By issue
I am doing a group by tile in magic etl. i have different values for different ID's and need to sum up all the values in each ID. For some reason some of the ID's are not summing and I get null in column for the ID. I did formula to make sure all null values before grouping are 0 thinking that would fix it but for some…
-
Allow users to specify the color of Magic ETL tiles
This would be a small change that could help organize extremely busy dataflows. While you can currently change the color of the line
-
Show Configuration AND Notes panels on Magic ETL tile simultaneously
Currently, a user can see either the configuration of an ETL tile OR they can tab over to the notes section. It would be nice to see both views at once when writing notes on the configuration or editing the configuration based on the existing notes.
-
Customizing Pivot Table columns
Hi All, I have created a pivot table from a data flow. The current setup is "Months" in the columns and "SUM of Sales", "SUM of LBs", and "SUM of Cases" in the Values. The output gives me columns of January Sales, January LBs, January Cases, February Sales, February LBs, February Cases, and so on. Is there a way to switch…
-
Number Formatting and abbreviated Numbers
Could we add the chart property 'number format' to table cards and could we have it that we could partially abbreviate numbers. For instance, 1.1567B could be 1156.7M. And other such similar features.
-
Nested Beast Modes (need to still be able to insert beast mode text if we are only allowed 1 level)
Glad to see DOMO is allowing for nested beast modes now. It would be nice if they would allow references to beast modes that have beast modes referenced within them, but it seems like this is a beta launch and are working towards that. IDEA: While it is not possible to reference a beast mode that references another beast…
-
Beastmode Preview
When selecting "Validate" for a beastmode it would be nice to have a preview presented at the bottom of the window pane. Then you can see if it is behaving as intended with columns used in the beastmode next to the outcome to compare. It would also be nice to see a more in-depth error as to why it did not validate.
-
dashboard not reflecting filtered values
I have a dashboard which has filters by semester term and college. There is a column for type of housing and a metric in the dashboard. The metric should display upon the filter on college as a whole as it is constant across all terms . However, it displays only upon filtering the terms, as the data is present across rows…
-
Forcasting Data by Zip for a 24 month period
I am looking to forecast mover data out 12 months looking at a 24 month period of historical data for each zip code in the US. Currently we run this with a spreadsheet and a forcasting formula. Looking for anyone who might have done this before or has any ideas how this can be done in Domo. Open to other tools other than…
-
Trying to create vertical bar chart that shows Count of Jobs based on Hours of each Job?
Hello, I am trying to create a distribution that shows the count of transactions ("jobs") grouped into buckets of hours. I thought using a window function to partition the hours buckets by Job (X-axis) and then doing a count(distinct) of jobs as the Y-axis would work, but it's not grouping correctly. When I set the Hours…
-
Reloading Recursive Dataflow Data
Hello, I have a recursive data flow running daily adding on and updating our sales data. It was discovered that the join wasn't using a fully unique identifier so some rows of data have been cut out over time. I want to clear out the data and resend it all to domo so that I make sure I have it all. Is there a way to clear…
-
Can I see the basic dataset length between different steps of an etl flow?
For example, I want to know how many rows are in the table before and after a pivot.
-
Using LAG() OVER function to get difference in a Snapshot dataset
Hello! I am trying to get the right formula to calculate the difference in data within a table (same data APPENDED to create snapshots). Here is an example of a beast mode I have been playing with. I have unique data by Opportunity ID & Snapshot YearWeek in the rows summarized in this chart, I would like to take the 202413…
-
How to do percent of totals for different totals
I have totals , value, dimension, three columns which i want to show as percent of totals vertical graph, However, my totals is a different column and is distinct to each dimension . I want to display botton 10 rows for dimension that has the totals with the value in ( percent of total graph) How do I achieve this. I tried…