-
Calculating a value for current week and rolling that value for subsequent weeks
Hi, I have the following 2 datasets: Dataset A Item Location Date X Y A USA Sep 10(Current Week) 10 10 A USA Sep 17 15 20 A USA Sep 24 10 5 A Canada Sep 10(Current Week) 0 4 A Canada Sep 17 6 0 A Canada Sep 24 13 15 B USA Sep 10(Current Week) 10 50 B USA Sep 17 5 15 B USA Sep 24 15 20 Dataset B: Item Location Z A USA 15 A…
-
Can Youtube Connector Show Individual view records?
I am using the Youtube clound connector in DOMO and Im wondering if it's possible to get a dataset with a record of each individual view that occurs on our channel. Right now I can get the publish date and total views for each video via the "Video & Channel Names" report but its not exactly what Im looking for. I want to…
-
Domo API and Dataset auditing
Any way to use Domo API to audit datasets to track security and any transformations created on the datasets.
-
NOT IN function of MySQL not working in Magic Transform MySQL of DOMO.
Hi, In one of my coloumn im getting all numeric values and few of them are string values(bad data). When im trying to use NOT IN function of MySQL not working in Magic Transform MySQL of DOMO. Please suggest me the solution. Thanks.
-
Replace with last non-null or non-zero in data flow
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…
-
Can scheduled reports be set up to only be sent if there are results, not "0 results"?
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."…
-
MYSQL code for Date Ranges and populating new column with fiscal week problems.
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,…
-
POP Beast Mode
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…
-
Accessing lists using github connector
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…
-
Setting a Default Data Set Within a Page Filter
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…
-
Why can't I select a graph by period? Or a compare period either?
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
-
Formula to group fields based on a specific string of text in that field
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…
-
week on week % change beast mode
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…
-
DOMO API and Finding Datasets without PDP
Using the Domo API, Is there a way to determine which datasets do not have PDP applied to it?
-
How to add an Annotation to a stacked area chart?
Hi All, For whatever reason every time I add an annotation on the stacked area chart, the annotation does not display. The option is given to create an annotation and to save it, but when I hit save nothing happens. The chart is month over month so there are date values in the x-axis. Am I missing something? Any insight…
-
Customize publication
I've been asked to remove the header portion of publications including the DOMO logo, company logo, and slide advancment options. Also, I would like to display 4 cards on 1 publication page. Is this possible?
-
Histogram percentages
Hi, I'm using a histogram plot to showcase a category and it's spending across time It splits the category and shows spending in proper buckets automatically with well-defined buckets. This is great! However, I now want to see just the percentages of that category and not just the number, so I can understand which bin has…
-
There are more results than can be shown. Try adding or changing a filter.
Does anyone know why I 'd keep getting "There are more results than can be shown. Try adding or changing a filter" when building Sumo Cards? What's the best way to avoid this error? -Steve
-
Visualize Hierarchical data
Is there a way to visualize Visualize Hierarchical data in Domo? For example, in my dataset I have an HR tree data for a company and I want to visualize who reports to who (from the CEO down to the botton of the tree). Is there a way to do that in DOMO?
-
Domo Dimensions not loading files
Hello, I'm trying to get a calender.csv file from the Domo Dimensions connector, but the files don't seem to load. Is this a bug or am I doing something wrong?
-
Search that Leads to a Sale - BeastMode or ETL
I have 2 data sets. One is showing all of the search terms entered on our eCommerce site, along with the logged-in user's account info. I want to see if any of these search terms match with products sold in my second data set, which is all of the sales entered in our ERP. The intent is to see if an online search may have…
-
How to create a gauge chart to compare yoy or wow or mom ?
Hi community, i have a column of data that contain dates of several year and another column that contains its corresponding numbers. so i would like to use the gauges to represent yoy growth ? how do i do that ? how do i deal with the current value and previous value ?
-
Using Domo.Navigate function in place of HTML Links
Wondering if anyone else has had any luck using the domo.navigate() function in Domo and what you did if successful? I was using HTML links but then found out those were not supported once I published my custom card design to Domo. I have included the domo.js library into my script and am trying to find a way to create…
-
Interactive Page Filters
Are interactive page filters available in the current version as described here: http://knowledge.domo.com?cid=pageanalyzer ? Applying Interaction Filters When you apply Interaction Filters in a page, you can mouse over a specific chart element in a card, and that same element will be highlighted in all other cards in the…
-
Use rows in x axis
I have a data set that I created through a very complicated ETL. Below is a snap shot of what it looks like. Year Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec End Of YearActive 2010 2 5 1 9 12 15 5 9 4 33 12 15 120 2011 2012 2013 2014 I need to build a multi line chart where the x axis has the months, the y axis has…
-
Grouping multiple values in a column into a single column
Hi, I have the following dataset: WhseLoc Proj Inventory Previous Inventory Country California 18 20 USA Atlanta 21 22 USA Columbus 19 20 USA Toronto 0 25 Canada Ottawa 0 20 Canada Vancouver 15 30 Canada I want to get an output dataset as follows: Country Is_out_of_stock USA No Canada Yes The conditions are: Proj Inventory…
-
tips for managing a growing instance
Hi guys, Some of you have mentioned having thousands of users in your instance. Our instance is growing, and with that have come some growing pains in terms of managing training and adoption. Would love any tips/suggetions you may have. Ideas: Coursebuilder Office hours Others?
-
Variable Rows Card
I am trying to create a card (table) with 10 different columns highlighting different revenue metrics. In this table I am trying to create 4 rows that aggregate data differently based off of the same column metrics. 4 rows: - Yesterday - Week to Date - Month to Date - Year to Date How would I create a table to facilitate…
-
Beast Mode for Calculating Yesterday, WTD, MTD, YTD
Hey all, I am trying to create a PostgreSQL dataflow that will create a cumulative row column for my dataset to show "Yesterday," "Week-to-Date," "Month-to-Date," and "Year-to-Date." For example, please see what I would like to accomplish below: How would I go about creating a Cumulative Sum (WTD, MTD, YTD) row that will…
-
Alerts API?
Is there an API for receiving the alerts in Domo? When anomalies are detected, I would like to consume them in our homegrown software. Thanks, Steve