-
Dynamic Pivot
I have a table with a combination of fields and a target value. I want to concat all the fields (Retailer, Field, Target, Strategic Priority) and pivot the table so they are all columns with their respective Target Value underneath. I know how to do this with the Pivot option in which I manually create a new column for…
-
Dynamic option on dashboard that allows users to adjust data
Is there a way to create a variable which when users select, will alter a calculation? For example, I have a cost savings dashboard that shows projected savings based on an assumed 50% reduction. Is there a way to have allow the user to select (or enter) a projected reduction, which will dynamically adjust the rest of the…
-
Identifying if a character in a field is a number or text
I have a row that contains model numbers such as: YM103Kl - (model category would be YM and capacity is 103) YAC24LT (YAC and 24) NC33KLT (NC and 33) I'm trying to figure out how to extract the initial letters (2 or 3 depending on the model) to identify the model category and the subsequent numbers (single to triple…
-
extracting letter out of field
I have a row that contains model numbers such as: YM103Kl - (model category would be YM and capacity is 103, and capacity multiplier is K) YAC24MT (YAC and 24) NC33KMT (NC and 33) I'm trying to figure out how to extract the capacity multiplier. @GrantSmith helped me to identify the model category and capacity with the…
-
Is there a way to have pivot tables collapsed by default?
How do I set up a pivot table, so by default the rows are collapsed?
-
Odd issue with ETL and missing data
I have an ETL I'm working in which data from one of the input datasets is not being pulled through when I run the ETL. Oddly however, I can see the data in preview. In particular, the "Test 1" output dataset will show data when I view it in preview (see screenshot below), but the resulting dataset does not contain any…
-
Projected monthly total based on current progress in current month
Is there a way to project the month-end value based on the current month's progress in a bar chart? So if there are 10 days of data totaling 1M widgets during September (9/1-10), it will project 3M widgets for the current month (1M will be solid and 2M will be striped to signify striped). I see a whole bunch of options in…
-
Comparing YOY trend lines
I'm struggling with building a chart to show YOY trends. I was able to use a combination of the following beastmodes to create the following chart from a dataset containing a small amount of data. But when I attempt to do this with a large dataset, it doesn't work (I'm wondering if it just requires too much processing).…
-
dynamic date associating
I have a dataset that contains IDs and meta data to include modification dates. Each ID has a last modification date. However, each ID may (or may not) be associated with other IDs. I want to identify the latest modification date (direct or associated) for each ID. Below is an illustration of what it looks like, except…
-
filter issues
I'm having some odd issue with one of my filters and how a table somehow gets unsorted by it. I have a table which I want sorted by "preferred URL" and then sum of "monthly page views". Without any filters applied on my dashboard, this table is properly sorted. Then when I apply a filter (CMS), it suddenly turns my sorting…
-
Restricting certain columns of sensitive data in Public accessible dashboard
I'm interested in sharing some dashboards with agencies via the embedding dashboard option. However, I'm a little confused how I can set this up. I see two different options: I can make a dashboard private and only allos users to authenticate from a Domo account (which obviously wouldn't work in this case) or API…. would…
-
how to build a line and stacked bar chart
I want to build a Line + Stacked bar chart, but am struggling with this. I've got the bars (clicks) and the line (CTR) created. But I want to break up the bars into a stacked bar based on a field (site). I would normally put the site field in the series option - but I have to place the clicks there in order for it to…
-
dynamic rank/ordering for Beastmode
Is there a way to create a dynamic column via Beastmode that will rank the rows (1, 2, 3, etc...) based on the filtering and sorting for a table card? So however you filter and sort your table, there will be a rank column that adjusts so you can see the ranked order?
-
Domo class for analysis
I've got a new team member who I intend for her to utilize Domo more for the analysis capabilities. Is there a good online module(s) anyone would recommend for her to take (that is preferablly free)? I'm envisioning her utilizing ETLs, Views, and beastmodes to analyze the data.
-
Multi Line chart
This should be a simple task… yet this is shockingly confusing (as usual with Domo). How do I create a simple multi-line chart, using the data below? Just month for the x-axis and two lines depicting sessions and total users. Month Sessions Total users 6/1/2022 224509 151443 7/1/2022 250178 174588 8/1/2022 235310 159992…
-
IN function
Is the SQL IN function not supported by Domo? I've noticed when I attempt to use this, the Beastmode (or ETL function) is saved without error, but it doesn't seem to pull in the results. i.e. case when 'event_name' in ('page_view','session_start','scroll') then 'Yes' else 'No' end
-
ETL not running
I have an ETL that's been running for over a year. I made some updates to it and now it will not run, despite the preview showing everything marked as green. The error message says "Saved but incomplete. Cannot be run until all actions are configured correctly." Can anyone advise on what might be going on here? I've…
-
Filling in data in ETL for missing dates
I have a bunch of data which shows cumulative reviews on each product (on indirect ecommerce channels). However, if there were no reviews for a particular product on a specific date, my dataset will not show the cumulative review for that product.... so for example, I may have the following data for Product A - in which…
-
How to remove dates without any information in bar chart
I have a dataset that provides number of followers once a week on Tuesdays. Is there a way to chart this so I just see the days with data? Currently, it'll show the dates in between (see screenshot below). When I graph by week, it'll incorrectly identify the date (so it'll show the value for June 1 as May 28). I understand…
-
How to filter for Tags (many-one relationship - multiple tags per field)
I have a dataset containing tags in which a row might have multiple tags applied. For example: Keyword -- Tag(s) Car -- blue truck -- green, red bike -- yellow, red, purple How can I set up a filter for a dashboard/card which will allow me to filter down to just trucks and bikes when I filter by "red". Or just trucks when…
-
Issue saving a card
Why does this error occur? Normally it isn't that big of a deal, but I just spent the last 10 mins creating color rules and now I am going to lose all of them and have to start all over…
-
Word Count
Is there a way to create a field or value that identifies the number of words in a field? Preferably ETL, but Beastmode if necessary.
-
Add field to Conductor API connector
For the Conductor connector (Tracked Searches report), can you please pull in an additional field that is associated with each tracked Search: "Prime". This indicates if the keyword is a primary/prioritized keyword the business wants to focus on.
-
Is there a way to pull data from the body of an email
I have emails that are automatically sent to my inbox with data contained in the email (see screenshot below). Is there a way to scrub the body of the email and extract data from it and pull into Domo? For example, I'd like to pull the value corresponding to Portal User ID (Cookie) .
-
How to fix hover percentage on 100% stacked chart
I have a 100% stacked chart… and the percentages are correctly displayed on the bars by default. However, when I hover over a value in the legend, it will show what appears to the be value of the Y Axis (expressed as a percent). So for example, Email should be around 2-3% (as displayed in the first and second screenshots),…
-
Is there a way to organize the order of sub-dashboards by default for users?
I know how to adjust the order of your dashboards and sub-dashboards as you see them… Is there a way to adjust the order for other users who view your dashboard series with sub-dashboards? I'm fine with them adjusting later to their own preferences, but would like to have a prearranged order by default when they first view…
-
Unabbreviating a number in a single value card
I can't believe I'm asking this question… but is there a way to unabbreviate a number in a Single Value card? I want it to say 1,253 - not "1K".
-
using Regex with email connector
Can anyone help me with Regex for an email connector. I have an email with two separate xlsx files. I've noticed the email connector will automatically default to the first one and I'm having difficulty getting a connector to pull the other. I tried setting up a separate connector to pull a file if the Attachment name…
-
Multi value chart with % and number
I'd like to create a card that looks like this. Shows the percentage (of records with a certain value) along with those relative numbers over the total number of records. Is there a way to do this?
-
Filtering table by selecting from chart - or showing hover text
I have a dataset with data along the lines of: UserID - Order Date - Order Number - Customer Name - User Purchase # etc. I have a chart to show first time purchases by users (where user Purchase # = '1'). and then a table below to provide more information on the customer. Is there a way to filter the table by the users…
