-
Bargraph for Employees/Hour when I only have start and stop times
This will probably be obvious in retrospect, but I cannot figure out how to generate a chart based on the data I have. I have data in the following format: Name Store Date TimeIn TimeOut Alice 0001 1/5/2024 6:00 12:00 Bob 0001 1/5/2024 7:00 11:00 Charlie 0001 1/5/2024 7:00 9:00 Denise 0001 1/5/2024 8:00 12:00 What I need…
-
Enable Preview Up to Point in ETL
Most of the time I don't need to preview the entire ETL. It would be nice to be able to drag/select the tiles of the ETL that I would like to preview up until.
-
April 2024 Community Event
@eddiesmall - what is the start time for next week? Streamyard link reports 8am and also 10am Mountain. Which is it? "April Edition: Domo Unplugged – Deep Dive into Post-Domopalooza Product Announcements! April 25, 2024 08:00 AM Save the date for our monthly virtual meetup session on April 25th at 10 AM MT, as we…" P.S.…
-
Add proxy logins from domosupport to activity log domostat
Currently the only way to see proxy logins is via the activity log in the admin section. I would like to be able to see proxy login information in the activity log domostats so I can setup alerts, build reports, etc… using that information.
-
Date and hour values to timestamp
Hi Domo, I have two columns: a date column (date datatype) and an hour column (0-23 integer type). What formula could I use to combine the two columns into a timestamp, assuming the minutes, and seconds are zero? Thanks,
-
Formula to get percent complete
Hi. I have data with Plants and Tasks and whether the tasks are complete are not. I need a formula so I can have a percent completed for each plant based on the number of Yes tasks they have compared to total tasks. Then I need to group by plant and bring that percent into a table. Could someone help with this? The…
-
PDF exports from App Studio
We are wondering if there is any way to export a PDF from a DOMO app. We cannot seem to find the option anywhere, so not sure if it’s possible at this point. We like to schedule emails to users with snapshots of dashboards when they update and want to do more with workflows on this front in the future. That then gives…
-
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),…
-
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…
-
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.
-
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…
-
Final Summary- DP 2024 Product Features
For the second year in a row, we created a one pager which shows all the features released and even discussed at Domopalooza. In the past it has sometimes been understandably hard to remember if what you saw was GA or a sneak or something else. So we strive to be transparent so you have one place to check and remember.…
-
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…
-
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…
-
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…
-
Creating a Cumulative Concat Function on a Text Field
I currently have an ETL looking at distinct Opportunities by their close won day. However, this issue is now looking at Distinct accounts within the same dataset. At first, I thought to use the count distinct function on the account ID in a groupby. However, since multiple opps can be tied to one account and each one can…