-
why is greater than filter not working for date.....????
I am building an ETL and have noticed when I attempt to filter data by dates greater than (or greater than or equal to), Domo will filter everything out. I notice however when I select less than (or less than or equal to), it properly filters out.... What is going on here??? Is this a glitch?
-
coalescing data in a table
I'm attempting to build a table, which pulls from a order history dataset and includes the following key columns: Account Number, Order Src (CSR, EDI, or DCX). When I create beastmodes (e.g. CSR $ = case when `Order Src` like 'CSR' then sum (`order_line_total_price`) end) to break down the orders for each account by their…
-
table for countries with codes and continent
Is there a data dimension or other dataset out there that provides a listing of: country - country code (2 letters) - country code (3 letters) - continent
-
Do Beast Modes show up on Views?
Will Beast Mode calculations show up on Views created for Datasets? I'm working with a view of a dataset, but don't see any of the Beast Modes that were shared with that Dataset....
-
how to create a bar line chart
I just want to create a simple Bar Line chart.... how do I get the lines? This should be simple, yet I can't figure this out....
-
How does the dashboard level filter work?
Can someone explain how the filter in the upper right part of the dashboard works? Does it filter charts by all dates that exist within their datasets? For example, if I have a dataset that has multiple date fields (registration date, order date, shipping date, returned date, etc.) and I select a date range of 1/1-1/7...…
-
DOMO acting SLOW!!!!!!!!!!!!!!!!!!
Is DOMO acting slow for anyone else? This morning, it has been crawling.... and I can barely get any of my dashboards to even load. And worse, I have a big training session later today to introduce over 50 people in my organization to DOMO. THIS IS NOT GOOD!
-
Is the Drop Down selector a new filter option?
I never noticed this until recently... is this drop down selector a new feature?
-
Issues with Text boxes
I've noticed some serious issues with updated text boxes. I will make a bunch of updates... click out of the text box, so it appears saved. And then when I refresh or return to the page later, it undone my edits. This SO UNBELIEVABLY FRUSTRATING!!!!!!!!!!! What is the issue here with this?? Is there somethign I need to do…
-
Beastmodes capture sales for each of last several months
I'd like to create a table where I show the progression of sales ordered each month per product.... I thought if I could create a beastmode to sum up all the sales for the last month, or 2 months ago, or 3 months ago, etc. I could then just place these in a table. So I created the following beastmode to capture the last…
-
Is there a way to fix sub-page order for everyone
Is there a way to set the order for sub-pages for others you share it with? Or at least set the default order when they first access it? So for example, I'd like to have the following order in the screenshot... but I notice others see it differently (because I had them in a different order originally).
-
Complex count distinct
I have a dataset with session IDs and pages... I want to know how many distinct session IDs include a specific page ('ABC'). The trick is one session ID could have multiple rows with page ABC... Session ID -- Page 123 -- ABC 123 -- ABC 123 -- DEF 456 -- DEF 456 -- ABC 789 -- GHI Hypothetically, how do I create a beastmode…
-
Filling in blanks, based on next value
I have a dataset in which a User ID will be identified during a session.... and then later change User IDs... and in between, there are rows of data in which the User ID is not identified - but I want to fill in those gaps with the next User ID that is identified during that session... Row -- Session ID -- User ID --…
-
Making dashboards load faster
I have a dashboard with ~150 cards and it takes upwards of 2 minutes to fully load... Are there any suggestions for making this speed up? I tried building views of all the datasets with restricted data for each card (significantly reducing the rows and columns) which doesn't appear to have had any impact... :-(
-
Pass filters across pages
I have several pages (one page per each step of a customer journey). Is there a way to pass filtered values from one page to another? So if someone is on the first page and select a value on a filter.... and then they go to the next page... that filtered value will be applied. Is there a way to do this?
-
Pulling out UTM parameters for new columns
I'm working with Google Analytics 4 data and am noticing some gaps with the campaign metrics. So, what I'd like to do is reference the page URL to look up UTM parameters and identify. In case you aren't familiar with UTM parameters, the way it works is you'll add a '?' and add these to your URL. Later in GA, you can tell…
-
Is there a way to show averages for last day of month
I have data (cumulative totals and averages) for a dataset by day for various products... I'd like to create a bar chart that shows the collective sum of the cumulative totals and collective average of the averages for the last day of each month... Can anyone advise on how to do this?
-
Line chart in relation to zero values
I just noticed a line chart I have has the lines connected directly to the next available date with data... which is misleading because it makes it seem as if there is data on the dates in between. In the screenshot below, the value for 1/31 is 4 and 2/13 is 2.... however 2/1-2/12 is 0, but if you're looking at the line…
-
Adding a MOM or YOY value in top of card
Is there a way to incorporate MOM or YOY comparisons within cards? Similar to the visual below (which is in Power BI)?
-
Is there a way to delete a column in a dataset?
I notice when I pull data with a connector... and then adjust the settings to reduce the number of columns, the older columns will still appear in the dataset (even if I replace instead of append). Is there a way to delete outdated columns without having to create an entirely new dataset?
-
Period over Period (MOM/YOY) option in Multi-Value card for 2 months prior
I am building a dashboard that only shows completed months' worth of data. A few of the datasets I have though provide lagging data.... so for their specific cards, I just want to show data up until the prior month. I have created multi-value cards to show the MOM and YOY trends... they work when I have a completed dataset…
-
Create a card/text field that simply says the last month on a dashboard
I have a dashboard set up to review the last month. Is there a way to simply get a header or text box in the dashboard that identifies the last month? (each month, it will automatically change - so today, it should say February 2021 and on April 1, it will say March 2021).
-
How to break up a page
Is there an easy way to break up a page when the content gets too long (which prevents me from exporting into powerpoint/pdf)?
-
Issues with cutoff characters at top of series for scatter chart
I've built a scatter chart and am having an odd issue with some weird noise at the top of my legend... This appears to be the result from putting a Tooltip value for data labels. And it makes the chart look very amateurish. Can anyone advise on this? See screenshots below. The first shows the issue I'm having... And this…
-
Changing color of line in line chart
Can someone please tell me how to adjust the color of a line on a line and bar chart? And also how to adjust the axis values (so the Y axis match their respective color - line or bar)?
-
Providing Domo exercise for training to newbies
I have many in my organization requesting training for Domo. I've advised them to consider the Domo university modules... but I was thinking it'd be nice to have perhaps a 1-2 hour session where I walk people through various actions on sample data to practice key functions. I'm thinking walk them through some of the basics…
-
Issues with Moz connector
Is anyone else having issues with the Moz connector? When I attempt to connect, it appears to run and start importing... but then errors out with the following message: "Domo is ready, but the credentials you entered are invalid. Verify your account credentials and try again." I've verified I have the correct credentials,…
-
Compressing bar charts (5 across) onto page
I have a request to essentially create an executive dashboard that will display a bunch of charts, primarily bar charts (going back 13 months), 5 across... Below is a screenshot of something that was created in Power BI. Is there a way to do this in Domo....?
-
Combining datasets by looking for strings in one column
I have a couple datasets... 1) Product IDs with information 2) Google Analytics data with URLs that contain the product IDs on product pages I'd like to join the first dataset to the GA data to include product information that aligns with the product page. Is there a way to join these datasets in which I have the second…
-
How populate a new column with data based on data in other rows
I have a dataset consisting of Google Analytics data. One of the columns identifies their Userid (for our ecommerce portal) if they authenticated. Another column identifies their GA session ID (during the visit to our site before and after they authenticate). I am interested in capturing all the activity for a user before…
