Old or outdated content that could still be found helpful.
Anybody know how to use SQL to replace a null or zero value in a table with the last non-null or non-zero value? The table is layered by date--ex: 07-1-2014 5 10-1-2014 4 01-1-2015 0 04-1-2015 0 07-1-2015 4 10-1-2015 4 My goal is to replace those 0s with whatever non-zero value preceeded it, so the result should look like…
We would like schedule reports to only be sent if there are results to be sent. One of our reports is a release notification filtered for the past 24 hours from our product team. We have updates once every 3-4 days; however, we are notified everyday regardless any updates. We'd like to eliminate the "There are 0 results."…
I have two data sets. The first data set is full of leads/opportunities (FY18 MQLs) and I want to automate populating a column with the fiscal week it was created. For example: 'Created Date' = '10/02/2017' Would be between 10/01/2017 and 10/05/2017 (Q1W1).. Our reporting weeks are from Friday to the following Thursday,…
Hoping someone can help me figure out why my POP Beast Mode calculation returns 0% in my charts. I want to compare current quarter to last quarter. I may also modify the calculation to compare last quarter to 2 quarters ago. I am only using two fields from my dataset, similiar to this table and my dates are always the 1st…
Using the github connector to access issues in a github repo. Using issue labels as an example, the resulting dataset has fields for `labels_url` and `labels`. `labels_url` contains strings like "https://api.github.com/repos/openstax/work-management-reports/issues/38/labels{/name}", which appear to be a github api call…
So I tend to use page filters (am just now upgrading to interactive filters - yay) but also have found that less knowledgeable users have issues setting a default dataset. I have about 2-3 datasets that show within there, so the question becomes - is there a way to always default to the same dataset? 90% of the time the…
I don't understand why sometimes I can't choose a graph by period? I can choose a date range but nothing more. I've also had issues with comparing to other periods, even though I have all green checkmarks in what you must have to do comparisions
Our customers are broken down by specific locations. I want to create a card to track sales for the customer that includes all of the customer locations and customer numbers. Is there a beast mode calculation I can create to pull any customer if it includes specific text (i.e. CASE WHEN NAME_CUST includes 'Customer*' ELSE…
date examples are based on writing today - 6th September. my aim is to create a beastmode, which can ultimately be applied to any metric, which shows the week-on-week % change. this value would be able to be displayed in a table by date(week) or as a KPI card which would be filtered to show data for last week. the goal is…
Using the Domo API, Is there a way to determine which datasets do not have PDP applied to it?
It looks like you're new here. Sign in or register to get started.
Have a Domo product enhancement idea? Submit or upvote on ideas in the Ideas Exchange.
Ask questions about Connectors, Workbench, Cloud Amplifier and get best practices from Domo peers
Ask questions about Magic ETL, SQL DataFlows, DataFusion, Dataset Views and get best practices from Domo peers
Ask questions about Beast Mode, Cards, Charting, Dashboards, Stories, Variables and get best practices from Domo peers
Ask questions about App Framework, Workflows, Domo Bricks, Domo Developer, API and get best practices from Domo peers
Ask questions about Jupyter Workspaces, R & Python Tiles, AutoML and get best practices from Domo peers
Ask questions about Domo Everywhere, Scheduled Reports, Mobile and get best practices from Domo peers
Ask questions about Governance Administration, Approvals, Teams, Alerts, and Buzz and get best practices from Domo peers
Watch how our Customers are using Domo to solve their complex problems.
Domo support and product teams are here to live-answer questions about the most recent product releases. Please post questions in this Forum board for all users to benefit (rather than submitting a support ticket).
Questions or discussions related to Domo University, trainings and certifications