-
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…
-
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…
-
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…
-
can you share a filter view if you don't co-own the page?
I have a user (with editing access) attempting to share a filter view she created and the share with everyone check box is greyed out. Is this because I didn't make her a co-owner of the page?
-
excluding a card from being filtered by date
is there a way to exclude a card from being filtered by the date range selected? I've got two charts on the dashboard. One will be showing sales data... and I want to filter that by date. But then I have another chart with user information (which provides the customer's registration date, last login, last purchase, etc.).…
-
Is there a way to annotate tables?
The user wants to be able to annotate values in a table (such as below). Is there a way to do this? Basically, she wants to provide some note on particular cells.
-
Compare last 12 complete months to prior 12 months
I want to show data for the last 12 complete months and compare them to the prior 12 months. Is there a way to do this? I created a beastmode (PERIOD_DIFF(date_format(Date,'%Y%m'),date_format(now(),'%Y%m'))) to allow me to filter out the current month (march). However, the chart will still show March of last year on the…
-
Formatting a table
I have a table which I would like to have sub-rows providing sub-total numbers for each month. It currently looks like this. How do I get it to look like this? Where the total rows are emboldened, the color coding applies to their respective columns, the “Count x/y” is replaced with Total in the Retailer field, and the…