-
Nested Case and Concat Statement
Hi, I am trying to figure out how to create an Etl that expresses: If a particular year has a result then concat that with another column's result. Something like: CONCAT(case WHEN 2015= 1 then '2015', '-', Virtual vs In-Person else '' end) 2015 has a 1/0 constant and I want the result to be if they attended in person (so…
-
trial version Form Builder/Form Viewer
Does anyone know what the difference is in using the trial version? Knowledge says Note: The trial version of Form Builder is not feature restricted. If there are no feature differences what is the gain in moving to the "non" trial version?
-
PERIOD_DIFF
Hi, I wonder what the problem is with my formula. The end date is March 2024 and the start date is December 2023, but I'm getting 24291 as a result, while I was expecting 3. Based on the documentation period_diff will return the number of months between two periods. Is there anything I'm missing here. Thanks
-
Unable to Create Same Time vs Yr Ago
I'm trying to create a dynamic Comparison Value that adjusts the view based on Time Period Selection. I was able to create a Gauge Value that works, but am struggle with the Beast Mode that would allow the end user to view vs same time year ago value. I have the code below and have tried various adjustments, but keep…
-
How To increase the size and change the Card title font
in the above visual , How do we format( resize , Change color etc ) of the card title "APP DOWNLOADS &INSTALL BASE |By Month"
-
Domo Buttons
Hi Team, Is there an option to add a button/or equivalent to a dashboard that when clicked, updates a dataset within Domo? The use case is for maintenance - clicking a dashboard/page button to validate it has been quality checked and the button can capture the username and time of check. Alternatively custom logic I may…
-
Workflow with Form and Writeback
Hello, My use case is as follows: Create a workflow that allows a user to go through a list of items with "Undefined" as their value under the "Designation" column. For each undefined item, the user should be prompted with a form that allows them to see the identifier for the item and select either "Capitalization" or…
-
Max Rank by Month and Year for Volume Metric
Hi, I was hoping to write a case statement that would allow me to highlight the month with the highest Volume. Additionally, I want to take data from that particular month and I want to graph it by Day. On the same graph I want to highlight the Volume for the current month as well. Ideally I would do this in a line chart.…
-
Smart Text format changes in iOS Domo app
Hi Everyone, I recently added the "date last updated" smart text onto all of my dashboards. There are inconsistencies in the way this is displayed. In most cases, it appears as the length of time since the last update: However, anyone using the iOS app sees this: Does anyone know if there's a way to make this consistent?
-
Add filter ability to individual series elements on a chart
Hi, It would be great if we could filter a series item on a chart. Right now, if I want to have 3 items in a chart (A amount, B amount, C amount), I have to create 3 separate beast modes. Note: I'd have to do this because the amount formula is complicated. I'd like to be able to drag 'Amount' to series in a chart several…
-
Inline Editing Problem
I am trying to use the inline editing app to make changes to a row via multiple choice options. Everything seems to work fine until the input dataset updates over night and basically resets the column essentially erasing all inline edit inputs/changes. How can I resolve this?
-
Limiting access when row count is low
I've got a dashboard which has some simple bar/pie charts. The stakeholder wants to be able to slice/filter the data, although they're not allowed to view the data if it includes less than 10 rows of data. This is due to the nature of the data. I did try a case statement - case when count (distinct id) >10 then 1 else 0…
-
I'm pulling in a column from Salesforce that has over 1024 characters - Text column type limit
Is there any way I can overcome the limits of the text column? and are they really 1024 characters? What are the possible solutions to have the entire text available in my DOMO dataset?
-
Datasets not accessed in a while
Does anyone know there is a way to see all the datasets that have this ? I looked around Domostats but could not see anything. I would love to have this as a field in the Datasets Domostats table.
-
Domo Everywhere Embed SSO
Hi, When our users connect to the embedded domo via sso there is a transition where it looks like domo is briefly showing the main black navigation bar (as found in non edit embed domo) and then it tries to hide it. This is ruining the user experience when our users log in via our application as sometimes it isn't a quick…
-
Time Difference in Minutes
CASE WHEN Hospital Ready Time (UTC) IS NOT NULL AND Video Start Time (UTC) IS NOT NULL THEN ABS(UNIX_TIMESTAMP(Hospital Ready Time (UTC)) - UNIX_TIMESTAMP(Video Start Time (UTC))) / 60 ELSE NULL END I am trying to find the difference between 2 timestamps. I am using the above beast mode calculation but it is giving me…
-
BEAST MODE CALCULATION ISSUE
Using the Beast Mode below I am being forced to use the ABS function in order for the Beast mode to give me a calculation. If I remove the ABS Function I get the error "An issue has occurred during processing. We are unable to complete the request at this time". The issue I have is I need to remove the ABS (Absolute Value…
-
How do you get rid of the max, avg and min in a chart
-
data/v1 endpoint - Filter on columns and values with spaces in their names
Is it possible to filter results on the data/v1 endpoint with columns or values that have spaces in their names? I've tried every combination imaginable to get results for a column named Spend Category, but continuously get this 400 error. Filtering results with columns and values that don't have spaces works as expected.…
-
Data Processing using Partition
Why I am having data loss issue when using data partition in Domo ETL?
-
Governance DataSet - Scheduled Reports
It would be helpful to be able to access attributes around scheduled reports via the Domo Governance connector. It would be nice to be able to filter by a user/group to see what reports they are getting instead of going through each scheduled report individually in the Admin center.
-
Summary Number value type
hello Is there a way to get the actual decimal value for a card in the summary number - the actual value here is supposed to be 1,495.93 but its showing 1K. If i used a single value card, I know how to update it. But not sure how to change that for the summary numbers.
-
Support for multiple delimiters in CSV for use in European countries
A significant number of countries do not use a comma as a delimiter for CSV files. The inability to select an alternate delimiter such as a semicolon cause issues in these countries.
-
How do you set the default delimiter when exporting via CSV?
We have a larger number of users that are in European countries. The default delimiter in CSV files in Europe is a semicolon not a comma. We allow the users to export the data from a card as a CSV. How can I set the default delimiter to be a semicolon instead of a comma?
-
Show Subtotal Rows - suddenly not working for my pivot tables
Hello! Previously my pivot table cards have "show subtotal rows" turned on to show the subtotal sum of certain values. I logged in today and realized that all of these pivot tables stopped showing the subtotal row, even though I didn't make any changes. Is this something that I can fix quickly? Thanks!
-
Trying to use Unpivot
I have a dataset. 1 order has 10 stages. each stage has a schedule date, completed date and status. 1 order has 1 row and 30 columns. I am trying to unpivot to 1 order having 10 rows and 6 columns. I used 3 different unpivot tiles for it. I built out the ETL but not sure why its taking forever to run.
-
How to calculate Average
-
Duplicate filtering status to top right of card
Currently the filtering status appears at the bottom right of cards. When you have cards that are quite tall it would be good to have the filtering duplicated to the top right of the card as well so it is obvious to the user that the card has finished filtering.
-
Can't Edit View
I'm a DOMO Admin and there is a DOMO dataset view that I can't edit - I'm getting the message 'you don't have access to edit this view'. The person who created this dataset also gets this message - nobody can edit this view. I created a copy and can edit that view but I need to understand why this message is appearing and…
-
Joining and getting all dates between start and end date
Im doing a join on billing ID's. Each billing ID has a start date and an end date. Im trying to return all dates between start and end date for each billing ID. I tried adding this formula to join. dt BETWEEN Service Start Date and Service End Date It isn't working as expected. Im just getting one date for each billing ID