-
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…
-
Date Type capabilities
I'm trying to do something again, but I forgot how I did it. Coming from a PowerBI background when you choose the Date type it allows you for some dynamic presentation. Below I did it once, now it doesn't work any more where my columns are showing it by date. Compared to this How do I get it in the format to show…
-
Preview Window Limits in Magic ETL
There is currently a 100 rows preview window limit when you do the preview run on the ETL. We need to increase this as it can help drastically with further work in the MagicETL.
-
Accounts with Profit Sharing Formula and Filter
Hello, We've got some customers that have profit sharing rules in place. As my data comes over it doesn't take this into account so it shows full profit attributed to us. I'd like to have a filter to toggle profit sharing on or off to show either full profit or the profit taking into account the sharing. If, for example, I…
-
Date Formatting in Tables/Charts
Hello, I am new to domo so hoping this is pretty basic to update. My date columns come in the following format "Jan 23, 2024" in my raw data. When I pick my date fields in any cards it only shows the year 2024. In some cases I will want columns or rows to be months or possibly days or weeks. How am I able to pull other…
-
Y Axis on Horizontal Bar - Allow Long Labels by Default
I was thrilled to discover the "Allow Long Labels" checkbox on the horizontal bar chart - however, I only think to go into Analyzer and apply it when I realize my labels are cut off in the first place. I would love to have Long Labels allowed by default, and we can uncheck to shorten to the ellipses version of labels Can…
-
Year Selector / Filtering for YoY Function (more than 5 years)
Hi folks! I have a range of cards where I am quite limited by only being able to show current year and back 4 years YoY. There are times when I need to show much older data or exclude years (like 2020 or 2021). Can we add the ability to select more years / filter the available years etc. Using this in conjunction with…