-
Dashboard Page Filter bar - limit the filterable columns
Hi, I'm trying to find out if there is a way to only limit the filter in the filter bar to a pre defined set. USE CASE I have a data set that contains private data. I want to use that SAME dataset on 2 different dashboards. Dashboard 1, you would see all the columns so you can filter Dashboard 2, you would only see a…
-
Look for text within multi-selection value
Hi all, I currently have code like this, which converts some selection values to a shorter display value when Business Division_p = 'Biologics' then 'Bio' The problem is that the attribute is multi-selection, so when there is more than one value selected, there is no match. How can I change this line of code to look for…
-
How do I get unique values from a column?
Hi all. I need help in getting the unique values from a certain column. See example below Say I have this column below with multiple duplicate names in it, I only need to show one for each name. Please help. If it's possible through beastmode, it would be better, because I'm also utilizing slicer/filter for this card, so I…
-
Colour change depending if beating last years amounts
I have a bar graph with a comparison line showing the previous year. I want the bar to show a different colour depending on if were beating the previous year or not. e.g. red if under and green if over.
-
Single item Filter with CONTAINS functionality
Hi all I have a table of 1,000+ people. Each person = one row. One of the columns shows the companies they have worked for in the past (e.g. 'BT, Shell, Facebook'.) You know what's coming…. I would like to be able to give my dashboard a filter that shows each company once and brings back any person/row that CONTAINS that…
-
Beastformula
I have this data with an ID column that are repeated because each unique id have 4 different event type, What I am trying to achieve is if one id with = 4 different category and are all completed in the event status column and within 45days of event date and originalenrollment date then it is completed. I have this code…
-
[domo CLI] login issue in domo app CLI after performing npm start
Description When attempting to develop the custom Domo app locally and run the local server using npm start, an authentication error is returned, prompting the user to log in to Domo using domo login. After successfully logging in, attempting to use npm start again returns the same authentication error. However, it…
-
Rank and Windowing functions in beast mode
Hi! I had my CSM enable rank and window in beast mode, and I have created a few that work great, but when I go to save my card I get an error that says the card cannot be saved and to contact support. I submitted a support ticket - but is anyone else having this issue? And if you have existing cards with this type of beast…
-
Not getting GA4 data to reflect accurately in Domo
Hello, I'm having a hard time trying to pull in data that correctly reflect what's in GA4. I've read through multiple threads to reduce the number of dimensions to just a few, and have broken one big report into several smaller pulls (list below) but I'm still getting numbers are that significantly different. I'm also…
-
Cleaning data off an appending dataset
Hi Dojo, We have several datasets that are appending a decent amount of data each day, and we do not have a need to keep data from as far back as our datasets are holding. Does anyone know of a solution that makes connectors work with a "moving window" to only hold relevant data? ETL solutions work well for our datasets…
-
UPDATE Statement in MySQL Flow is not updating the value in the Table.
Hi Team, I am trying to create a MySQL Data Flow using below SQL Transform which will have a UPDATE statement. Some How it is not updating the Column in the output table which I want to update. Can you please check what am I missing ? ====================================== CREATE Procedure GetAllDates() BEGIN DECLARE l_cnt…
-
Numerical Dimensions/Attributes
Add a column property to allow numbers to be defined as dimensions/attributes rather than forcing them to be measures. Common examples are ID, Order Number, Employee Number, etc. Sort, display, justify them as numbers, but do not aggregate them to a meaningless value. In other tools I have seen this as a simple checkbox.…
-
PDF export: optional first page?
It would be great to have an option to disable creation of generic first page. In case you don't need this page you have to delete it and change all the page numbers in PDF, which means you need the proper license and time to do it.
-
Chose the newest date available
Hi All, I am working to combine two tables. The first step I need to take is to filter the project_number by with the newest report date available. The example below shows two different project numbers The first one has the last report date as Q3 2022 - we need to capture that input The second project_number has q4 of 2022…
-
Getting an average line chart from multiple line charts
Hi everyone! Just wanted to ask if it's possible to get an average line chart for a multiple line chart (based on a specific series). As an example, think of X = Quarter 1, 2, 3. 4 of Year 2023, Y = revenue, and series = Product 1, Product 2, Product 3. However, the tricky part is this series is based on a DOMO variable,…
-
Flag for duplicate record
I have two datasets, same structure/columns, 1 large dataset with all records and another large dataset with suspected duplicate customers removed. I want to join these together and create a flag for the suspected duplicate records. I tried to add a formula tile to each dataset, Duplicate = Yes ( for dataset filtered dupes…
-
Change SQL Server Connector to import datetime data with greater than 1 second granularity
SQL Server's Time and DateTime fields store data to the millisecond (Time datatypes are accurate to 100 nanoseconds). However, the connectors truncate those data types to the nearest second. I put in a ticket when I found this — I really do need to keep the milliseconds when importing — but was told it's working as…
-
Ability to Default 'Send email notifications' to Unchecked
I administer Domo for a user base of 20,000+ users. We have created a dynamically updated group which includes all users of Domo, and this has allowed our users the ability to share Dashboards with everybody at our company. This is a great way to share information quickly with a large swath of people, however, the 'Send…
-
Be a Friend! 'Accept' your Peer's Answers.
Hello Domo Community! You have all been nailing it in the forum lately! Responses have been LIGHTNING⚡️fast and each post is getting at least one comment. By way of reminder, don't forget to click the 'YES' button if a user answers your question. This is a great way to recognize your peers and help them accrue points on…
-
Does Domo support Mode function?
It looks like Domo supports 'Median' function but I tried to use 'Mode' to find the mode of a value in my dataset and it kicked back this error: Calculation Error : This calculation is using a nonexistent function.
-
Lag Function Giving me Values that Don't Exist?
I'm trying to create what should be a simple table that shows job Last Quarter Salary, This Quarter Salary, and Percent Change. However, my Beast Mode is giving me values that aren't even on my table. The Current Salary is displaying fine, but the previous quarter's salary is giving me a fictional number. Here's my formula…
-
Does anyone use the domo identity broker? Is it working for you?
As above really. The one we access isn't working so was wondering if this was impacting other users as well.
-
Support for Emojis in Dashboard Names
As a user, when you are scrolling through the various dashboards in the left-hand navigation bar, it would be super helpful to have a more visual cue to draw your attention to the dashboard/page you are looking for. Emojis would be a great solution for this. Currently, based on my testing, Domo allows you to save Emojis in…
-
unpivoting data
I have data this way: Account | Category | Date 12 | Phone | 01/01/22 12 | TV | 01/01/22 13 | Phone | 01/02/22 12 | TV | 01/01/22 I would like to figure out on each date the counts for each subcategory. First i would want the data pivoted this way: Account | Category | Date 12 | Phone, TV | 01/01/22 13 | Phone | 01/02/22…
-
Convert text to date field using
Hello, I am using Magic ETL and trying to convert a text field to a date field. Earlier on my data flow I had to alter some columns by using the cast function. I was able to continue with the data flow and have the output I want. It was until I was creating a card that I noticed the "Date" is "Text". (I have some formulas…
-
Scatter Card Quadrant Lines in Wrong Place
Not really understanding what's going on here. I have a Scatter chart with 1-10 values on both axis. If I set the Quadrant Lines to appear on 5 for X & Y, the horizontal one for Y appears correctly on 5, but the vertical one for X appears on 8. Any idea why this would be? Thanks
-
Please add a Vertical Scroll Bar to Gantt Charts
This is available on other Chart types, such as tables. Thanks!
-
How can I get vertical scroll bars on charts?
For instance, I have a Gantt chart, with let's say 100 rows, but I want the card size to only show 20 at once, then have the user scroll vertically to see more. Is this possible?
-
How to remove Page Filter from dashboard?
Hi All, I hope you are doing fine. Unfortunately I can't remove a page filter on my dashboard. I can only remove it temporarily. Whenever I leave my dashboard and open it again, filter is again there. I am looking for a way to remove it permanently. My Page Filter Option I have already tried. Will remove it only…
-
Using Juptyer Workspace with domo
Hello, I'm looking for help to create a Juptyterworkspace because i can't find the button the create a workspace. what are the parameters needed? Best regards