-
Please show App content in user Profile
Admin > People shows me these options: However, App content doesn't show up in the list of Pages. I know there are now datasets to help understand App usage, but at a person level I would like some visibility into what they have permissions to see.
-
Rolling 12 Months Calculation
Trying to get the below into DOMO (below is done in PBI) Monthly - 01/12/2024 - 31/12/2024 (1 Month) - Works for each month using the calculation - COUNT(DISTINCT Incident Number) Rolling - 01/01/2024 - 31/12/2024 (12 Months) - Need help FYTD - 01/04/2024 - 31/12/2024 (Apr 2024 - Dec 2024) - Need help
-
Tool Download - Google Slides
Do we have Tool download for Google Slides just like google sheets?
-
Year over Year Cards
Question regarding year over year cards. Currently I have a card that shows YTD vs Prior year and its working as expected however if I change the dashboard filter to be last 12 months, the card seems to stop working Since my "compare to" field in the card is set to "1 year ago" I was expecting that this card would be…
-
New Formula Functions in Magic ETL
Hi friends, Just a quick post here to let you know about a couple new formula functions that have been added to the Magic formula editor. Not a big enough thing to warrant its own product release, but just a little note here to let you know about them: ROW_NUMBER(), which would normally be used with an OVER clause, can now…
-
Month Name in Control is ordered alphabetically, how to get the Month in the right order?
I have a column 'Month Name' and set it as 'Display as Quick Filter' so that the end users can use the filter to pick the Month they want in a card. However, the Month is not in the right order (Jan, Feb, Mar, etc.). I'm not sure how to do it with Quick Filter/Control?
-
ACE Hands-On Webinar: Building Actionable Data Products in Domo
Hey everyone! I’m excited to invite you to a webinar I’ll be hosting on Friday, January 17th at 2 PM MST. In this session, we’ll be building an actionable data product from start to finish using App Studio, Workflows, Task Center, and Domo's AI Service Layer. Save Your Spot! [Register Here] I’d love to see you there and…
-
Are You Sure? Beastmode Safe Exit
After writing a Beastmode, I shouldn't be able to click outside of the dialog and have the beastmode completely scrapped. There should be a 'draft' option or a 'Are you sure you want to leave?' come on! This is basic UI stuff.
-
Removing the "Introducing DOMO apps" banner
We are already using apps and don't need to be reminded to use them every day. I would love a way to permantenly remove this banner
-
Allow users to rearrange cards in the appendix
Currently, you have to remove all cards from the appendix and then add them to the appendix in the order that you would like. It's extremely inconvenient when you have more than 2 or 3 cards in an appendix. It would be incredible if we could just drag and drop them in the order that we need them in while editing a…
-
Why are multiple "Send Email" blocks forcing all input fields to be required?
Hello! I am working on a workflow that has 3 parallel loops that will send emails. I added the first "Send Email" function to the first loop and was able to enter only the fields that I needed to (Recipient Emails, Body, and Subject), but when I tried adding the second "Send Email" function in the second loop, and all the…
-
Format Numbers at the ETL Level
Does anyone know if it is possible to change the formatting of a number at the ETL level instead of on each inidivual card? For example, changing a number that is currency so it shows up with the $ instead of just a number…
-
Provider Prior to Upgrade
I am trying to determine who provided the evaluation prior to an upgraded premium procedure. I have all the data I could ever need, but I'm not sure of the logic to make it happen. The task is made more difficult because there could be multiple evaluations prior to a procedure, and evaluations on different dates than the…
-
Make 1st letter of a field value uppercase in ETL
Is there a way to make the first letter of a value in a field uppercase? Not the entire word, just the first letter…
-
how do we know if our domo plan supports writeback?
and if it does not, what plan(s) do, and is there extra cost and how much? We were looking to use this: https://domo-support.domo.com/s/article/360043437093?language=en_US Brian
-
How to view the SQL query on the jobname
There are a few Jobs on the workbench that uses the sql queries to filter out some columns. I was able to identify the job name but where can i find that window for SQL? Thanks
-
FIXED () in Magic ETL?
'MTD' / SUM(
CASE WHEN Class 3 = 'Sales' THEN Amount ELSE 0 END
) FIXED () I have this BeastMode called 'MTD %' that calculate the % of each GL Account based on Sales (so Sales = 100%)And it was working correctly with different branches. Just wondering if I can create this in ETL?
-
Domo Ai
My Domo AI queries can be inconsistent at times, even though I've added the required dictionary information. Do you recommend limiting the number of columns when working with Domo AI?
-
How to remove all grid lines except for X & Y zero lines
The subject pretty much lays it out. I want to remove all gridlines on the visual except for X & Y zero lines. I use grid lines sparingly, especially on scatter plots, but sometimes I want to include the specified lines for esthetics or whatever but can't seem to figure out how to accomplish that. The closest I can get is…
-
Slack Data Connector
Has anyone created a dashboard from the Slack data connector that could share their experience?
-
Alert for Field Name Change (within a column)
The current set up involves a dataset that is updated once a day and this is then uploaded to DOMO for further use. If a field within a column is changed and there would've been cards that are filtered on this very specific field within a column, the cards will go blank. Has anyone counteracted this? Please bear in mind…
-
Convert a time to a number
I have a user that has his own dataset and I am converting it so that it is all done through an ETL but the issue is that he has a Average Handling time of 06:32 but he wants to see it as 6.32. I am have had to convert the times to decimal to work and then covert it back to time doing the following: SEC_TO_TIME(…
-
Variable connected to a Filter Card
Part 1: I created a variable that allows me to select a different field. I then use this variable in a control on the dashboard. Part 2: I am trying to use the control I created in part 1 to change one filter card that is connected to this variable. The goal is to have one filter card that changes based on the variable…
-
Datasets Running Twice with a Small First Run
For some reason datasets are running twice with an initial small run of <5 seconds that is considered an "API update". This affects ETLs which have their trigger set on "when datasets update" as well as alerts. What happens is that the ETL starts running off of the 2s dataset run above, after which it will run again when…
-
MTD Last Year, YTD, YTD Last Year with Rank & Window Tile
Say my dataset has these columns: branch_id, gl_id, amount, Month End Date, fiscal_year, Month Number I'm trying to recreate below SQL Window function with Magic ETL so that for every Month End Date*branch*glid combination has a corresponding MTD Last Year, YTD and YTD Last Year. SUM(amount) as 'MTD' SUM(SUM(amount) OVER…
-
Uploading Excel - Data Type Issues
When uploading an Excel document, where all of the data in the columns are formatted as "text", DOMO will change the data type to number, every time I upload it. I know there is an option to change the data type using MAGIC ETL, but here is my problem. In our data we have account numbers with preceeding zeros, for example…
-
Data Freshness - Cloud Amplifier (Nov 2024 Release)
In the recent release Domo announced Freshness Check for Cloud Amplifier integrations. This tends to work perfectly fine for Snowflake Datasets and updates the data on the scheduled intervals but does not reflect 'Last Updated Time', in the Overview tab of the Dataset. [This was posted by DomoSupport, on behalf of a Domo…
-
Filter visualization on dashboard help
I have a dashboard that I added a donut filter to at the top containing Category A and Category B. Below it, I have a single bar chart with no series that shows the amount of new paid companies in a given week. At the bottom of the dashboard, I have a standard table with the complete list of companies. The intended…
-
Calculating country from lat long - latitude longitude
Hi, I have a data set containing lat long information, but I need the country information. Any idea how to calculate that in an ETL or Beast? I see there are lat long maps, which show the country information correctly, but I would need that in my table. Example: Location Longitude Location Latitude -149.5485 -17.7538…
-
Have Smart Text show exact time dataset was updated
By default, smart text shows the relative time a dataset was updated. For example, Dataset A was updated: 7 Hours Ago. Is there a way to display the exact timestamp instead of the time elapsed since the dataset update?