-
Cloud Amplifier - Databricks - Unable to retrieve schemas
All my catalogs can be retrieved/validated just fine except for one that returns the "Cannot retrieve schemas" error or "Cannot validate table" error. I've attached screenshots below. 99% confident this is a Databricks issue but cannot pinpoint what is different about this catalog vs the others… I am using a personal…
-
Passing filter from Parent Page to Child page - Global Filter
In domo we need to an option to pass our Parent page filter to child page.
-
Carrying date range in hyperlink
I am using pfilters to drilldown on multiple columns. But the set date range isn't carrying when the link is clicked. How can I open an anchor link so the new page has the date range the first page had? CONCAT('<a href="https://domain.domo.com/page/1234567898?pfilters=' etc
-
ETL Calculation
Please see above scenario. Those are quotes tied to a project. You can see that quote 90795(column D) is a first revision of quote 90439. My goal is to create a calculation that would show binary output as shown in column E. Basically check every 'Project Name' and if there is a revision to a quote (marked in column B),…
-
How come MySQL does not support window function, specifically lag in dataflows?
Hi, I am currently building a dataflow and trying to get the best out of both sql dialect. I use Mysql to order my data (because redshift doesnt order properly) and then use another datflow in the redshift dialect to be able to use window function. What I am curious about is to know why Mysql does not support window…
-
Dataset on Workflow Start Form
Hi, I'm using the brick "Workflow Start Form" available on app store to start a workflow using a custom form and parameters. That part works greate, but i alse need to query a dataset from there and the card have no option to link one (only allows to link a workflow). Can anyone tell me please how can I link a dataset or…
-
YTD vs Year Prior
Hi guys, Looked in other posts here but couldn't find the exact answer. I'm creating a table card that would show YTD vs Year prior (Bar charts are not an option since comparing many different categories. The best I could find to show Year prior is SUM(CASE WHEN YEAR(DocDate)= YEAR(DATE_SUB(CURDATE(), INTERVAL 1 YEAR)) AND…
-
Order by in ETL?
Hi, I am working on taking some mySQL dataflows we have stored and turning them into MagicETL dataflows. I am wondering, does anyone know of an 'order by' function in ETL that is applicable? TIA
-
Precision Loss With Dataset APIs
Hi folks, I'm hoping to get some pointers on getting precise decimal data while using the Dataset export API. I ran a request to retrieve data for a dataset on my domo instance using the API docs and was able to get my file downloaded onto my notebook. However I'm noticing that the decimal fields seem to only be returning…
-
Change Dataset on Form and Dataset Brick
I'm working on a Form and Dataset Brick. I've got some background in coding enough to change a few table elements. What I'm trying to do now is change the dataset. Right now the table is pointing to a dataset that was seemingly created when I created the brick. I renamed the dataset "P&F Test Form". Everything is working…
-
Why do private embed links resolve to a "public.domo.com" address?
Our private embeds resolve to an address at public.domo.com. Is this normal? For example, if I go to a link like: https://mycompany.domo.com/embed/pages/n1234 I get redirected to public.domo.com address like this: https://public.domo.com/embed/pages/n1234 The embeds do not seem to actually be public. When trying to access…
-
45 token limit for embedding reports
We're running into a 45 token limit when embedding reports (i.e. we're doing some custom filtering using tokens pulled from Domo). Is there a way to get around this limit?
-
Sharepoint REST Connector
I am working with another company to try to bring data from their Sharepoint instance into Domo. They have given me their App ID & Client secret value but I am getting an error message when I try to connect. This is an existing app, they haven't made us a specific one. Is there an error with the connection or does the…
-
Conditional formatting based on multiple columns
I want to compare two columns and their values in a card. I have column A and B. I want to apply color rules on the lower value cell between the two cells. I know you can set the color rules based on individual columns. I know you can create a beast mode and set a flag for the conditions. I currently have the color rules…
-
App Studio: Integer Filters need RANGE
Please let us see the min/max/avg range for numerical filters on the App Studio control panel, like we do in Analyzer and on regular card filters: Needs to show this VERY important column-level metadata: The lack of range could cause a user to misinterpret how the data is aggregated.
-
App Studio - Move/Copy Card Functionality
I love that in the Admin > Cards area it now shows "Dashboards and App Pages" for card locations. A further "nice to have" enhancement would be to see the App title listed under Move/Copy when looking at a cards settings. In this example- I know this particular card is both in my overview and on our Analytics Hub app.…
-
Color Rules: Prevent table card from inheriting colors
If I set a color rule on a bar chart, and build a table card as the drill, I cannot remove the color rules from the table. The color is inherited from the bar chart, and the only change I can make is to uncolor the WHOLE table row, but I can't simply remove color in the first place. In my use case, the only reason to have…
-
Compare MAX date with YOY: Month-to-Date (MTD) Comparison
Trying to create a sql statement in magic ETL to compare YOY: Month-to-Date (MTD) by MAX date. My current code from is: CASE WHEN (MONTH(MEMBERSHIP_INSTANCE_PURCHASE_DATE) = MONTH(CURDATE()) and YEAR(MEMBERSHIP_INSTANCE_PURCHASE_DATE) = YEAR(CURDATE()) and DAYOFMONTH(MEMBERSHIP_INSTANCE_PURCHASE_DATE)…
-
Allow sorting of quick filters
Currently, we have many academic years in some reports but usually need to sort by the newest. However, all the order academic years are at the top of the filter and we need to scroll down the filter to get the current year. Having the ability to sort this so the data currently on the bottom would be on the top would be…
-
App Studio Controls/Filters
While creating apps with multiple pages/tabs we don't often use the same dataset for each card we put on a dashboard (app in this case, woohoo for app studio!) Where we are running into trouble here is that page filters only have the option to select a singular dataset rather than all datasets where the field is present.…
-
Year Over Year cards Leap year issue
YoY cards cards where Year to date is the range set for the card do not calculate prior year totals and hence yoy changes correctly until the month is complete. Since a year is assumed as 365 days for YOY cards, the leap year throws off the comparison to prior years until the month is complete. We are relying on mid month…
-
Making the QTY value to multiple rows
Hello, I am trying to take the data below and make the 'ORDQTY' column multiple rows based on Columns C and T and U. How would I do this? The end goal would be for row 2 would have two identical rows since there are a quantity of 2. Row 7 would have 4 identical rows and so-on. I am trying to have 1 unique row based on…
-
Improvements to Headers in App Studio and Dashboards
I wish there were more customization for the Headers function in both AppStudio and Dashboards. Right now we are limited to a single horizontal line and I have a handful of use cases where I'd like to limit the width of the page so I can have multiple headers in a line (see example above). The ability to change the…
-
Please Help - Cant get pivot table working properly
I am having a problem with a formula. I am trying to display Yes for a facility if they have a task event status in Completed or CompleteLate status. If they have a task in any other task event status I want to Display No. In my pivot table in domo I am getting an error of multiple results encountered for same location. If…
-
Domo Office Add-In - Relative Date Filters
Hi, the legacy version of the plug-in that our users are widely used to had the ability to do relative date filtering. Unfortunately, the new version does not include this functionality and is hindering our effort to get users to upgrade. Please enhance the new add-in by adding relative date filtering.
-
enabling embedded App Studio app to have export functionality
We use domo everywhere currently using dashboards and like the design flexibility that App Studio brings but there is currently no option to add the export functions to embedded apps. Adding this even at card level would be a real improvement
-
ETL snap to grid
I like to keep very neat or orderly ETLs. Would love the ability to align ETL tiles horizontally or vertically or snap to grid or something. I think that would help keep a clean workstation.
-
App Studio PDPs
Is there a way to apply app specific PDPs that apply across all reports within an App? For example I want each user to only see their own data whenever entering the app, is there a way to apply this at the app level or do I need PDP datasets for every report?
-
Magic ETL Forecasting Tile
Hi, I have a dataset that I have grouped together into monthly data (using the LAST_DAY function in case it matters). Using magic ETL, I then add the forecasting tile to get a forecasted volume. I have actuals upto the end of May 2022, but the forecast model is only giving me forecast data starting in July 2022. Can…
-
How do I use window function date ranges in DOMO ETLs?
The short version, I need the following query to work somewhere in DOMO ETL: AVG(`Score`) OVER (PARTITION BY Company ORDER BY 'Date` RANGE BETWEEN INTERVAL '90' DAY PRECEDING AND INTERVAL '0' DAY FOLLOWING) More detail: I tried using group by but cannot use window functions, formulas but can't use aggregations, and rank…