-
How to change smart text in the card title to show current date/ last updated date?
Hi All, In one of my dashboards I have various cards that update daily, ideally I would like the last updated date to update in the title when refreshed so it would read "PM AuM & Flows (Mth) by Service Type (£000's) as at 23rd February 2024". I've tried using smart text in the title to use the last updated date but this…
-
Default date in Domo is Sunday, I need it to be Monday
Is there a way to change this? The reason it matters is if I am building a pivot table, and my date field is in "Columns", and I select Graph By = Week, it uses Domo's default week start date, which is a Sunday. So my columns will have week start dates that are Sundays. Problem is our company calendar runs off week start…
-
Pivot table conditional formatting for text and column totals to the left
Hi, I have a card where I need to show a % total of an opening number and would like the text to be green if 100% or greater and red if less than 100% - in the chart properties I can set colour rules but this only seems to apply to the fill colour, is there any way to have the fill colour remain the same but have the text…
-
S3 Connector Files in Subdirectories
We're working on a pipeline that moves custom JSON log data from Cloudwatch to an S3 bucket using Kinesis Data Streams and Firehose (as explained here). This process will copy new log exports into a nested directory structure that represents the year/month/day/hour, for example: /2024/02/20/01/file1.json…
-
Creating a marker and deduping in ETL
Hey guys, Hope you all are doing well. I have an issue with data transformation in the ETL. It is best described on the screenshot below. I have multiple entries for duplicate IDs (one row for each product) and want to mark all entries for a given ID that contain Product 'c' as 1. That's the formula I used below to…
-
Add "Views Created" to Dataset Overview Tab
It's currently difficult to identify whether a dataset is used to power any Dataset Views without viewing its Lineage, which is not always convenient with a complex pipeline. This can cause problems when users unknowingly disrupt downstream views because it isn't obvious that there are views of the dataset they're…
-
Custom colors for waterfall chart type
Currently, the waterfall chart type is one of the only bar chart types that does not allow for custom bar colors via the Color Rules tab. I know we have some limited options for color customization with waterfall charts but these options impose some limitations in their current implementation. For example, when…
-
Domo App and Group
I have an app created in the domo. I also have a Group created by my Org. I want to share the app to the group, but i am unable to search the group name. Is it possible to share the app to a group ?
-
Date Conversion
I need a formula for taking just the month name from this format - Thu, 29 Feb 2024 11:59 PM. I need it in a date formatted column though. I can take the Month Name using MONTHNAME('my date column') but i cant get the column to be date. Its always text. Any advice? Thanks
-
Bar + line/symbol graphs should have an easier option for average by group
I think one of the main use cases for adding a line or symbol to a bar graph, especially a grouped bar graph, is to plot the average on top. I know how to do this by using an ETL to calculate the averages and append them as rows to the data, but this creates a less dynamic and flexible dataset for cross-filtering with…
-
Sort Not working as Desired
I need this Table to Sort by the Sub Total in the Total Column. But the CustName is being forced into the SORTING Option because I have selected SubTotal Rows. But I need SUBTotals selected because Each Customer has Phases. How can I Sort by SUBTotal Totals and NOT CustName?
-
Have you ever built a survey in Domo?
Has anyone ever built a working, functional, useful survey in Domo? If so - how did it go? If not - why not? Thanks!
-
Percentage with Series in Bar Chart
I am trying with no success to calculate the Utilization% of our employees using a bar chart through time. I have a bar chart with the counts of days per period of time and with the requested series that are the utilization types. Formula: SUM(StaffedDays)/ SUM(AvailableDays). This is the counts bar chart that is working…
-
Dashboard improvements
"I know you have been told this before, but it would be really great if the pdp and filter icons were positioned away from the visual content. This was the gripe of one of our senior finance managers today, and I promised I would raise this again. She also brought up the fact that on dashboards, the dead space between…
-
Update Colors of a Bullet Chart
I am currently utilizing a bullet chart to visualize the number of worked hours comparitive to estimated hours for multiple groups working on a project. Is there a way to update the worked hours bar to help quickly identify the groups that are over or approaching the estimated hours? I have attempted to set the color rules…
-
Can someone tell me where I am going wrong please?
CASE WHEN 'metric'= 'CURR MONTH' THEN CONCAT(MONTH(NOW()),'-',YEAR(NOW()) WHEN 'metric'='PREV MONTH' THEN CONCAT(MONTH(NOW())-1,'-',YEAR(NOW())) WHEN 'metric'= 'THIS MONTH PREV YEAR' THEN CONCAT(MONTH(NOW()),'-',YEAR(NOW())-1) ELSE '' END
-
Edit Bar Charts more dynamically
Hi, I was hoping we could begin using Color rules a bit more dynamically. I was hoping we could assign color rules to different fields in the Card. For instance, elements that are not being used in the Bar chart but elements outside as well that are impacting the Bar chart directly For instance, if I have 3 variables in…
-
Custom Roles - Additional Permissions
We have a customer who has built out custom roles for some of their external subscribers: they would like to be able to give them access to the data tab, but not allow them to upload any files or data. This functionality is being requested as an enhancement. See summary of enhancement request below: Doesn’t want clients to…
-
Mega Table - Average column
Creating a mega table card and my first field is a Date type, an the remaining KPIs are all measures. I have the card transposed so it appears as the screenshot shows (columns are dates, rows are various KPIs). My question is: is there a way to add a column at the far right that is an average of all the weeks displayed. So…
-
Form Viewer v3 - view all submissions
Is there a way to view all previously submitted forms in form viewer? As an admin I'd expect to see every submission from every user, but when I submit from a test user account I'm unable to see those from my admin account.
-
App Studio and Workflows - Dynamic Domo User Parameters
In App Studio, many of the workflows I want to tie to a button click require static parameters to be passed into them. However in many cases, I'd like to pass the domo user id/email/trusted attributes of the person clicking the button into the workflow parameters dynamically. I suggest a dynamic parameters feature by…
-
Required Role Level for Reverting Dataset History
Hello, Domo Community! I'm in the process of delegating dataset management tasks and need clarity on permission levels. Specifically, I want to understand the minimum role level required for a user to access the history of a dataset and use the "revert to this point" feature. I've developed some reports and plan to allow…
-
Show only the Data Table as card
I'm using a line bar chart and have the data table enabled. But is it possible to only use the data table in a card? When using the table chart type it displays it differently. Is there a way to make the chart look the same as the data table?
-
Ability to export entire dashboard in App Studio
One of our use cases for App Studio is developing beautified dashboards for our clients. Our clients like to filter and then export dashboards, however App Studio does not currently allow this. (I realize it's in Beta :) )
-
Help using maps with Leaflet OpenStreetMaps
I'm using the Leaflet OpenstreetMaps app in Domo to try and create a map with latitude/longitude data. I've got the data loaded and it's showing markers, but there's no background map - just markers on a grey background without borders or anything. How do I add borders?
-
pulling all ticket info using jira connector
Potentially dumb question but I can't find it in the forums here. I'm trying to pull all ticket info from Jira using the Jira connector. I've created a connection using my own credentials but it only pulls info for my tickets. To pull info from all tickets will I need to log in as a Jira admin?
-
UKG connector
I have a BI report that connects to a UKG connector. It picks up headcount at the end of the month. For some reason it skipped end of Dec 2023 headcount but is picking up Jan 2024. So now my dataset is missing Dec 2023 data. Is there a reason why such a thing could happen? Thanks, Gunjan
-
Extracting multiple phone numbers from a text field
I am trying to find a way to extract phone numbers from a text column. Each phone number is in a simple XXXXXXXXXX format, but each line can contain up to four phone numbers (ex. 4381258956 NA, 9378123287 NIS). I am able to use regexp_replace to extract one phone number, but I am wondering if there is a clean way to pull…
-
HTML Links Dropdown Brick
I am using the HTML Links Dropdown brick and I notice that if I try to right click and open in a new tab it says its blocked. Anyone else notice this? I am using the default code that comes with the brick.
-
Top clients requesting devices
Good day, I want to create a beast mode statement that gives me a list of all the clients who have requested more than two devices each month. The final outcome would look like this: Request Date Individual_ID # of Requests 2024-Jan 12345 2 56789 3 11234 4 56789 2 2024-Feb 12345 5 56789 4 11234 5 56789 2 So far this is…