-
AND filters in dashbaords
When we use a filter to select multiple values in a dashboard it uses an OR statement. For example : If I want to see all orders containing SKU A and SKU B, how can I achieve that with a filter on a Domo dashboard? Typically, it only provides orders containing SKU A or SKU B. Hence, I'm curious if there's any method to…
-
Is there a way we can merge the columns in DOMO table card?
I want to merge these column name in table card. Is there any way we can do this?
-
Beast mode CASE calculation for number ranges that have null values in column.
I have a column that has data type numeric and has numeric values and around 5 blank values. I am trying to categorize the number to ranges 1-5, 5-10 and so on. The column has blank values as well. Well, when I am trying to implement the CASE calculation in beast mode, it throws me a calculation error. How do I correct…
-
BeastMode Manager Not Transferring Beast Modes
im tyring to transfer beatsmodes i made from a card to a new dataset and it say they've succesfully copied over but when i go to check they aren't there. Super frustrated. Im musing the beast mode manager.
-
Revision history versions for Card
Hello Team, I'm writing to propose an enhancement to Domo's version history feature. Currently, it's challenging to track changes made to cards (present in highly sensitive dashboards) over time, especially when multiple users are involved. It would be highly beneficial if we could have a detailed version history that not…
-
YOY in table card beast mode
How can i display YOY Sales Data side by side in table card using beast mode. I am using this beast mode to display LY Case when year(DATE_SUB(CURDATE(), interval 1 year)) = year(`Date`) then `Net Sales` end and date selected in table card is This Month
-
API string question
I am trying to import data with the Weather Source Connector. I have created an account with the Weather Source company and they have provided me a free trial API. In the highlighted portion of my screen shot, I am simply just copying and pasting the string of characters that is my API key, but it is failing. On their…
-
I need to make a bar chart that combines multiple columns based on date
Simply put, I want to display how many users completed each program in Q4 2023, and I want to later be able to select a different date (so later, for example, I can see how many people completed programs in Q1 2024). I want my users to see the most popular progams during a given time period. I think a bar graph will…
-
Moving a Subpage to another dashboard
Is it possible to move a subpage to be under a new Parent Dashboard Page?
-
YoY change beastmode at card level in table chart
Hi, How would I create a beastmode at the card level that would specifically take a year vs. year comparison for each column of data (IL expl dollars, il expl qty, exp tp cost, etc.) Currently selecting transpose on this card. I'd like an additional column that calculates 2019 vs. 2020 change %. Thanks! Paul
-
API for Monday.com
I am trying to look for the best possible way to get Monday.com data into DOMO. I dont see any API, and we want to avoid using email connection.
-
30, 60, 90 Day Variance Calculation
UPDATE: I have this code, but it isn't doint what I need/want CASE WHEN MONTH(`Date`) = 1 THEN SUM(CASE WHEN MONTH(`Date`) = 2 THEN `Revenue` ELSE 0 END)END What I'm trying to do is say, Ok when the Date is January, grab Feb Revenue and Sum that I also tried this but it produced nothing: (CASE WHEN…
-
Different time zone
Hi! I'm trying to configure the time zone in ETL but my query is resulting in different times when the function calculates the difference, for the same column. ETL time zone function: Imported table from SQL Server: Result after time zone changes: The date range of the table is from Feb 24 to Mar 12. From Feb 24 to Mar 8…
-
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…