-
Cumulative Sales between December and January not calculating correctly.
Hello, I'm trying to create a table with daily net sales by date and also cumulative sales up to the current date (1/3 ATM) between two years: For the "Date" column, I used a beast mode to create date index formatted as %m/%d value: CASE WHEN YEAR(`created_at`) = '2024' AND DAYOFYEAR(`created_at`) <= DAYOFYEAR(CURDATE())…
-
Not getting GA4 data to reflect accurately in Domo
Hello, I'm having a hard time trying to pull in data that correctly reflect what's in GA4. I've read through multiple threads to reduce the number of dimensions to just a few, and have broken one big report into several smaller pulls (list below) but I'm still getting numbers are that significantly different. I'm also…
-
Has anyone tried to create a Google Analytics path exploration chart in Domo?
Hi, I understand the Sankey chart can be used to depict flows. I'm curious if it's possible to replicate the path exploration report that's available in Google Analytics Exploration in Domo? I tried the one in Domo but am only able to map one from/to flow. It doesn't look like the Domo Sankey chart can drill down into more…
-
Is there a way to mass update sharing settings for mutliple dataset?
Hi, I need to remove user & group access from 100+ datasets in Domo. Is there a way to do this en masse without clicking on the detail view for each dataset and managing sharing settings individually? Any tips would be much appreciated! On a separate note, I'm not sure why certain users & groups suddenly gain access to a…
-
Is there a way to use a matching value filter with a single select filter?
Hello! Currently, the filter control options avaiable for Quick Filter are: Match value Single select Multi-select Is there a way to use these filter controls together? For example, I may have two columns with the following values: Name Pets Ann Cat, Dog, Bird, Reptile Ben Dog, Bird Kate Bird, Reptile Tom Cat Will Cat,…
-
Graphing multiple metrics in one chart by rank
Hi, I'm trying to create a chart that shows how different GA4 metrics show a different result for which site traffic source performs best. For example, per the screenshot below: Email has the highest avg events per session Direct has the highest share of total sessions. Or, Display has the highest avg engagement rate. That…
-
How to compare last 28 days with prior 28 days?
Hello, I'm trying to compare the number of sessions in the last 28 days with the number of sessions in the 28 days prior to that. How do I accomplish this with a period-over-period multi-value chart? This seems fairly straightforward in google data studio But it seems like I'd have to create BM in Domo based on some of the…
-
How to make sure dashboards are organized the same way for users in a group (or across groups)
Hi there, I just realized that when my co-workers log into Domo, their navigation panel looks different than mine. For example, I have mine organized by A-Z (A) with Table of Content on top, but I created another account for testing, and the panel is out of order (B). Is there anyway to make sure they align? Thanks! (A) my…
-
Combine columns except when null (i.e., skip null)
Hi there, Is there a way to combine values in multiple columns except when the value is null? For example: This is a small example, I need to combine 8 different columns with a separator without ending up with: cat, , , , , orange, . I'm essentially looking for a DOMO equivalent of TEXTJOIN() in Excel. The values don't…
-
Split varying full names into First Name, Middle Name, and Last Name
Hi there, Back with another question. I have a Full Name column in varying format: Alex McCandless Alexander David Thoreau Bobby Del Rio Cameron Diaz Camilo Carter Dave O'Donald Jack E. Topez ... and I need to parse this into three columns: First Name - the first word of the string, seems easily accomplished with the split…
