-
OKTA CONNECTOR reg.
Why only 7 days of data is stored in "SYSTEM LOGS" of Okta connector? Can't we make it 30 days?
-
Need help with CASE statement in beast mode.
I'm getting this error on a pivot table card. The grand totals are correct but I need to see them by data source (Row) Here's the beast mode I'm using: CASE WHEN `Product` != 'SEM' THEN SUM(IFNULL(`Impressions`, 0) / 1000 * IFNULL(`Monday.CPM`, 0)) ELSE SUM(IFNULL(`Cost`, 0) + IFNULL(`Cost` * `SEM Fee`, 0)) END I've also…
-
How can I create a Beast Mode field which is a variable figure?
Is it possible to create a Beast Mode field which is a variable figure changing month by month without using SQL data transformation? because I am not very good at SQL manipulation, still in learning but need time. the field is ' top 5 provinces total parcel quantity % ' , which is the SUM (of top 5 provinces for the…
-
Percentage change in bar chart?
We have various charts comparing the current month to the same month in the prior year and it would be nice to have a percentage over the chart indicating what the difference is between the two periods. I have searched several forums and played around in ETL and beast mode, but something that seems straightforward does not…
-
Email connector
Hi, we are getting data in excel format from a service provider by email. I was trying to use the email connector, but only the data on the first page is uploaded in domo while we need the second to the 4th page. Is there another way to automate this task in Domo? Thanks
-
Dataset/Dataflow update trigger expirations
It would be very helpful, especially as customers move to consumption, to have advanced dataset update controls to have triggers expire. As an example, I have survey data that I want to update frequently during the survey window, but then stop once the survey has ended and no new data will be added. Right now my option is…
-
Edge of filters getting clipped in Domo
This is a very minor inconvenience I face when trying to build a dashboard. The right borders of any filters I add to dashboards as cards seem to get clipped. Anyone else face this issue and know how to avoid it? The right edge next to the dropdown arrow in the filter is what I'm referring to
-
Dynamic "Last Business Day" filter
Hello Domo product team, Submitting the following: would be great to see the option of dynamically filtering cards by last business day. For reference, this feature should be included in the top right corner inside Analyzer. Thank you for your consideration!
-
multiple Groups shown in just one column
Hello DOMO - Good Day! I am using the Data governance dataset that has the users and groups. what we wanted to show is the pages/dashboard and then all the groups that can view it. currently, I can show the different pages and the different groups in different columns. just wanted to know if we can show all the different…
-
Variable names in String
Hi, The current variable selector accepts the values either in Default (Numeric) - Gives a comma separator automatically. Percentage Currency - Adds $ as prefix. Do we have any work around to avoid comma? Do we have any work around to use other currency symbols as prefix with currency format?
-
Calling all Windowed Beast Mode and FIXED Function experts!
I think I'm close on this but am struggling to get my expected result. Here is my end goal—a chart showing data by date, with a line for the "Best Ever" value. Things making it tricky: I need the date range to be dynamic, i.e. user can select different dates I need the "best ever" value to be pulled from across the entire…
-
Formula for Combining Rows and Adding Columns
Hello, I am trying to accomplish a New DataSet using the Magic ETL where I combine multiple rows that have the same data in one column, but then create new columns for the data that isnt the same in other columns. To better explain, I have provided an example here. (Please see screenshot below) I have tried using "Group…
-
Add helpful context to workflow components
Since there isn't detailed documentation on how to use workflow components, packages, templates, etc there should at least be little popup bubbles that explain what information to provide to make a package work
-
Why are published datasets presenting to subscribers as federated?
I have an excel dataset in the parent instance that I've published to a subscriber instance that shows up in the subscriber's instance as federated data which prevents the subscriber from doing anything but creating cards from that dataset. There is one PDP policy set up on the excel dataset in the parent instance so that…
-
OKTA CONNECTOR
I am using Okta connector. The EVENTS is not being fetched. All other are being fetched and working good. Only EVENTS is not being fetched and runs into an error. Why is it so? Any idea/suggestions?
-
Automatically share the content of the parent dashboard to users and groups added to sub-dashboard
Now when you share a sub-dashboard, Domo shares the parent dashboard with the same users and groups as the shared sub-dashboard, but the content on the parent dashboard is not shared. It would be useful to automatically share the content of the parent dashboard as well.
-
How to create variables in beast mode?
How to create variables in beast mode? even do not find the training video. thank you very much
-
Possibility to tag alerts
It might be useful to have the possibility of tagging alerts, as is possible for Datasets and Dataflows
-
Calculation of previous dated values
I am trying to calculate trailing period (previous period) calc. I have year(variable selector), month(dropdown selector chart using column from table) If i select Year = 2024 and Month = Feb, I should get the data for 2024-JAN. Tried this formula but failing to get the correct figure. RecordDate(date format col) is…
-
can I change the pivot table chart like this? help please
Here is my design in DOMO. below is what I want. the difference is at value area, I want the figures of month (Jan, Feb, Mar…) on the left, then % of month (Jan, Feb, Mar…) on the right. that is to say, I do not want the 1st column at value area in Number, the 2nd column at value area in %, I do not want this because it is…
-
May Community Forum Highlights
Hello Domo Community! It's June! ☀️ Which means it's time to post the May Community Forums highlights. Follow the discussion, ideas, and user links to contribute to May's hot content 🔥 Leaderboard Top 3 We love seeing the monthly competition. @david_cunningham knocked @GrantSmith and @ColemenWilson out of the top spot for…
-
Multi value comparison
Hi, I am configuring a multi value comparison card. I have Sales column which is being configured in Gauge Value. In Comparison Value, I want to input the value of Sales Column itself but of previous year. I want this comparison to be dynamic because on my dashboard I have dropdown filter (Year, Month, Quarter). So if I…
-
Drilldown tables on cards displaying info from multiple dates
I have a card that uses variables to display info from different date ranges - some columns show metrics for a custom date range (defined by the variables) and other columns show metrics for the current month. When I add drilldown tables the date filters seem to get confused - it keeps picking the current day, even though…
-
GROUP_CONCAT function in Dataset View vs MySQL Dataflow
I have created a MySQL Dataflow where I was able to successfully use the GROUP_CONCAT function. It is preferred that I use a Dataset View in this circumstance since the underlying data is coming from AppDB and therefore updates every 15 minutes if there is new data. I have copied and pasted the exact query that is…
-
Dynamic data comparison
Hi, I want to perform QTD, YTD without using Domo inbuilt features dynamically. Like, I will have a dropdown for Year using dropdown chart using the Year column from dataset. And variable selector for QTD, YTD. User may select any of the variable selector and any one year from the dropdown. Example: Variable Selector : QTD…
-
Is there a way I can log in as a user?
Many of the softwares I manage allow admins to log in as users to test them, troubleshoot, see what they see, etc. Is there an option in Domo to do this? Specifically, I have a page with multiple PDP'd datasets. When I select the policy at the top, it doesn't filter all the datasets, only the one that informs the first…
-
Identifying what data came from which connector on a card.
Hello all, and thank you for any help. I have my magic ETL flow built out so a report is pulling information from two different connectors. There does not seem to be a batch ID or file path as options for me to select, which I thought would be the method to identify which system they pull from. Does anyone know how to…
-
Median Value in Total Column
Hey all I'm creating a heatmap visual that compares our engineers' ticket cycle time against projects and uses the median value. When I add a total column to the graphic, the column sums the values above instead of calculating the median across all projects. Can the visual be adjusted to calculate an overall "Median"? ref:…
-
Problem with Workflow
This is my first work flow project and I ran in to some problem while I try to create an alert on cards, and when I try yo attach the action, it shows me an error message
-
Filtering Against "Potential" Field Values
I'm trying to create a dashboard filter view for a set of field values where some values are not in the current data set but could be in time. Right now, it seems I can only filter based on available data and not able to set up a filter for potential field values. Is there any simple way to establish these potential values…