-
PDP issues
In domo, I have two different datasets, we have PDP policies on both of the datasets. I have created two views on both of the datasets and then joined the views in a new view. I have not enabled PDP on this new view neither on other views. It should inherit the pdp from base datasets, however users are still facing issue.…
-
Requesting ability to schedule on a quarterly, semi annual, annual basis
Currently I am only able to schedule reports on a monthly basis at the most. I have a couple reports that need to be scheduled on a quarterly basis (or more). Can we make that a feature?
-
Beast mode - no aggregation
Hi Everyone, I created a pivot table that will show the cost of dispatches. Please see below: one of the values that we are using is called Number of Ports ( blue Value that says COUNT of Nu. ) and for some reason the number does not populate any data even though on our tickets it shows a number. And maybe because that's…
-
Sums per subscriber across any selected date range
We have a dataset that lists subscribers and their purchases over time. We'd like to choose any data range and get back an aggregation for each subscriber in that date range (just a table with all subscribers with purchase totals in that range) Not sure the best way to achieve this in DOMO. So in the below example,…
-
Python Tile fillna on integer column keep return 0 unless I change the column to text
I have a column Bill-To (interger) I use Python Tile to run this script to fill the nulls cell with the previous cell value #Import the domomagic package into the script from domomagic import * #read data from inputs into a data frame input1 = read_dataframe('Select Columns') #write your script here input1['Bill-To'] =…
-
Seeking Best Practice Advice: Reporting Financials in Domo
Hi community, What is best practice for reporting financials in Domo? Currently, we have raw financials, account by account, fed in through a simple CSV. There are no summaries in this CSV, so I have to aggregate them with Beastmodes to get to summary numbers. For example, EBITDA is calculated as such (see code below) This…
-
is there a place to find all the possible visualizations?
-
extracting data from Epic EMR system
I'm looking to connect with a customer or gain some insight from any users that leverage Epic (Electronic Medical Record system) as a data source. I am trying to understand the best way to extract our data from Epic to SQL Server with an ETL process or push subsets of the data directly to Domo. Any info will help - thank…
-
Update to Domo University Experience
We’ve released a new Domo University experience! The Domo University landing page has been updated to include: A clear path for new users to get started with their learning journey. The ability to quickly find a relevant set of courses based on a user’s role in Domo. Visibility into what courses a user is actively working…
-
Access Dataset Before Approval/Denial in Approval Center
I would like to pull submissions into a card to review before I approve/deny them in the Approval Center. Currently, the only way you can access the dataset is after the approval/ denial takes place, which defeats the purpose of the Approval Center for me.
-
How do I see all the visualizations available?
How do I see all the visualizations available?
-
Do I have the right code in my Python Script?
Hi, Select Columns 2 has four columns, they are EFFDT, ACAD_PLAN, DESCR, and ACAD_CAREER. I wrote a Python script to filter the EFFDT column so that it only includes rows where the value is 'A'. However, when I try to join this dataset with another, I receive an error stating that the referenced column, which is the…
-
Filter Interactions with other Filters
Dear Domo Support, We can set filters interacting with other filters in a dashboard. However, when we change a filter selection, the selections in the other filters are as is and this can show invalid or no data in the cards. Here's the filter interaction scenario. We have 4 filters. Filter 1 interacts with filters 2, 3,…
-
App Studio: Share Page as PDF
Similiar to traditional dashboards, a prospect has suggested the ability to share App Studio Pages as PDF's.
-
Import App Studio App to Dashboard
I'm currently building App using App Studio for my company, and I realize that people will go to the 'App' tab at the top navigation bar and access these shared apps. As there would be more and more apps replacing old dashboards, it would be inconvenient to look up and categorize these apps. I'm wondering if DOMO could…
-
Using Magic ETL
I have dataset where the values are like this. Column name item and dependent Item Dependent A x, y Here I need new dataset where values should be like this by using the magic ETL. How to do this Item Dependent A x A Y
-
Need Help Changing to LAST 12 Months and sorting in proper order
The Card below shows the total call volume by month, and I have a quick filter to modify the number of years. I created the following beast modes. Standard Date (X Axis) DATE_ADD(addTimestamp, INTERVAL (YEAR(CURRENT_DATE()) - YEAR((addTimestamp))) year) Count of 'Addtimestamp' y Axis Reported Years for the Series (…
-
Getting data from Current Month backwards as Past Due and Future
I am trying this code but still cannot get data from previous month from last year 2024. All I got in "Past Due" is data from current month (January) and in "Future" I get all the data from future month plus from last year CASE WHEN MONTH(`SSD`)<=MONTH(CURRENT_DATE())AND YEAR(`SSD`)<=YEAR(CURRENT_DATE()) THEN 'Past Due'…
-
Running Total Beast Mode with Fixed Functionality
I’m working on a running total Beast Mode that tracks ticket sales by event. My current formula works fine: SUM(SUM(tickets sold)) OVER (PARTITION BY EVENT ORDER BY DATE ASC) However, these events reoccur yearly, and I want to compare ticket sales pacing to previous years while maintaining drill-down and filtering…
-
Currencies
Can we please get more then just 4 currencies to use. I cannot come up with a work around to still have numbers formatted correctly when using currencies like INR or CAD.
-
Why is it creating duplicate rows?
Hi, my first dataset has 21,683 rows, and the second dataset has 323 rows. However, when I joined them together, the resulting dataset has 31,045 rows. I noticed that there are duplicate rows. How can I fix this? Thank you!
-
Campaigns Error Message
I have a campaign that contains an HTML table card in the email body and is triggered to send by a dataset alert. I recently received this error message on a failed campaign delivery which I have never seen before. The same trigger was able to send to another recipient on the distribution list. Can someone help explain the…
-
Campaigns Error Message
I have a campaign that contains an HTML table card in the email body and is triggered to send by a dataset alert. I recently received this error message on a failed campaign delivery which I have never seen before. The same trigger was able to send to another recipient on the distribution list. Can someone help explain the…
-
Form does not load in embedded link
I am using an embedded link to host the app for my form. When going to the link the form does not load, only the placeholder. I have made the app public but can't seem to find a fix. Any input is welcome.
-
JSON "error parsing an expected JSON response from the API"
Using the no code connector - How do we even identify where to start looking with this error? "Domo is ready, but there was an error parsing an expected JSON response from the API. Please check that the API is returning the expected dataFailed to execute import successfully." There are no logs to look at or results. All…
-
Formatting on Dashboard
Has anyone ever seen this? One of my cards extended further to the right pane on the dashboard than all the others and I'm unsure why. Don't know if I accidentally hit something on the keyboard or a shortcut, but I can't get it to go away. Would also like to know how I did it so maybe I can make my dashboard wider without…
-
No error, but no change when using “Change Dataset Properties” API
I’m running into an issue running the “Change Dataset Properties” API, however. Running the code below should update the dataset name from “DataBricks Product Dataset” to “Databricks Testing”. I get a 200 status back and the response object returns the properties object as expected, but no change takes place either in the…
-
Error After Workbench Upload : Tundra Exception Duplicate primary key found - Doesn't fix itself
I am struggling to get this resolved through support. We have had these Datasets uploading perfectly well for the last 16 months via Workbench. Initially we upload all of the data using a basic Select query in Workbench and the data indexes fine. Then we set the wokbench on a schedule, amending the wokbench query to upload…
-
Zoom Connector - Webinar Reporting Challenges
Many people in our organization frequently conduct Zoom Webinars as part of our business model. The most important KPIs for us are # Registered and # Attended. Perhaps I am approaching this wrong or this is an opportunity for enhancement of the connector, but we have the follow challenges: Webinar Participant Report - the…
-
Best Way to Fetch GT Metrix Stats for Multiple URLs?
Hey everyone, I’m trying to build a GT Metrix connector to pull performance stats for about 40 URLs. I figured out how to bring in data for one URL at a time, but setting up 40 individual connectors and merging the results doesn’t seem like the best approach. Is there a way to request reports for multiple URLs at once?…