-
Find Datasets with No Cards & that are Not Used as Inputs (dataflows, dataset views, fusion, etc)
I'm working on a card to identify unused datasets. Datasets that meet the following criteria: No cards powered Not used as input in any other dataflow (ETL, Fusion, Dataset Views, etc/all types) I did find "Datasets" & "Dataflow Details" (Domo Governance Datasets Connector) that have most of what I want but does not…
-
Custom User Profile Fields and be able to use them as Trusted Attributes for PDP
I think it would be extremely useful to have the ability to add custom user profile fields. For example I have people that cover geography that's not just based on the "location", some cover districts. Also have users who back up certain sales people. If I could add custom fields to match values against our data I could…
-
Filter to Last 12 Months (dynamic)
I've got two data sets I am trying to combine in Magic ETL to calculate inventory turns. In the sales data I have 2 1/2 years of history that updates weekly. In the ETL in preparing the sales data I need to filter to just the last 12 months (from last date in the set). Since this last date updates each week I'd like to…
-
Variable Manager (Similar to Beast Mode Manager)
Starting to use some variables in our instance, and I want to make sure I have a good way to review/manage them as they are created/changed. I checked in the Beast Mode Manager thinking that would be the most logical place to find them, but unless I'm missing it I don't see a way to filter to them (tried searching by name…
-
Identify PDP Policies with no members (individuals or groups)
We've all seen this happen… you have a PDP policy set and a user leaves the company… there are no members left in the PDP policy. Would be nice to have a way to identify these cases in the PDP Domo Stats dataset. Today you'd have to go to each PDP policy and scroll through looking for the orphaned items. If I'm missing…
-
Variables - where can I manage/view all in my instance?
Starting to use some variables in our instance, and I want to make sure I have a good way to review/manage them as they are created/changed. I checked in the Beast Mode Manager thinking that would be the most logical place to find them, but unless I'm missing it I don't see a way to filter to them (tried searching by name…
-
CBSA Mapping (Census Core-Based Statistical Area)
I've got some data I am attempting display in a map card base on CBSA, but the current map card types in Domo don't seem to support that geo identifier. FIPS and ZIP are good to go. Does anyone know of a way to map by CBSA in Domo? Or, external sources that would help associate CBSA to FIPS or ZIP codes?
-
Build a Data Time field from columns containing date, hour, minute, second
I've got a data source that has separate columns for date and time that I need to combine into a single data time field. The length of the time field differs based on the hour (sometimes 1 digit hour, sometimes 2 digit hour). I have split apart the time field based on LENGTH() into separate columns for hour, minute, and…
-
Calculate % of Repeat Customersvia Beast Mode
Trying to help co-worker with a beast mode... and first not sure if this is possible at the card level (maybe better handled with a dataset view). Here's the business question: How many of our eCommerce customers are repeat customers? Displayed at a % of total eCommerce customer count. Example: 25 of 100 customers are…
-
Need Advice on Approach: Producing "... to date" comparisons when data granularity is mixed
Ok... this is a mind bender for me, and maybe that's because I'm too close to it... (forest for the trees). Hoping the Dojo can come to the rescue and point me in the right direction. Here's the business question: How can I see how our sales are performing to plan and vs prior year? (YTD, MTD - and including vs the same…
-
Find most recent transaction - Dataset View
I have a dataset with item receipt dates by branch. I need to find the most recent receiving event for each item by branch. The dataset has about 7M rows, and my thought was to do a dataset view, rank the receipts by branch & item descending on the receipt date. I can't seem to get the calculated column to work. Any help…
-
Dataset "Add Filter" Option for Datasets with PDP
Would like to be able to filter to my datasets with PDP, ideally with two options... those with PDP policies on the dataset and those where PDP is enabled on an input. Today I am using tags to identify them, but it would be nice if I could select with a filter option.
-
How to cancel/stop/suspend ALL workbench jobs temporarily
I've submitted to Domo Support this morning, but thought I'd check with the Dojo to see if anyone has a solution. I have about 60 workbench jobs that appear to be stuck this morning and are showing as "running". They seem to be stacked up in queue and are not getting anywhere. This traffic jam is growing as scheduled jobs…
-
Summary Number - Conditional Format Colors with Directional Arrow
I've read a few posts here in the Dojo, and also read this Knowledge Base article: Sample Beast Mode Calculations: Card Element Transforms but cannot get this to work. It seems that the examples I am finding are far more complex than I need - maybe I'm missing something simple. The logic I am trying to apply for a Summary…
-
Views Explorer - Invalid query, check your DataSet schema
I have created a simple dataset view that I would like to use in another dataset view... when I attempt to open it in views explorer I am getting the error message: "Invalid query, check your DataSet schema" Suggestions on how to trouble shoot? The steps I followed to created the dataset view: Filter to exclude one value…
-
Creating a Card Deep Link Beast Mode - Multiple Filters
Have been searching the Dojo and KB this morning for info on this and I'm not finding the solution. Also, not seeing documentation on Card Deep Links (do see for pages) - is this still supported? I have a card that shows inventory information and users are asking for a way to "see" who is buying the inventory most often. I…
-
Interaction Filters - Favorites Page (Filter options no longer visible)
Does anyone know how a user can enable interaction filters on their favorites page? The "Filter Options" wrench option seems to have been removed. I know it was there after the July feature release when I made this video: https://youtu.be/-uvIgxDw33c
-
Dataset Views: Best Practice to Remove Duplicates?
I'm still wrestling with this topic... finding the best approach. Any suggestions?
-
BeastMode: Identify Odd or Even Year
This is something I solved on my own, wanting to share here in case someone else can use this approach. Also would love to hear if you have another way to provide the same solution. What was the business problem? I have a card that displays a KPI as a % over time. I wanted to color code the years so they alternate between…
-
Beast Mode: Extract a string from a column based on a custom character is starting from right
I have some data we are pulling in that has a column full of text. The very last part of that string is a part number (variable length) that is always preceded by a dash. I'm wanting to split the column from the right at that dash. How would you do this with Beast Mode? Examples: (the part number is shown in bold)…
-
Deep Link Weirdness
I have a card deep link that has some weird behavior I am hoping someone here can help me understand how to address. I build the deep link and it works great for me (I am the admin). When my users attempt to follow the link the card opens, but the filter in the deep link does not apply. They are seeing all rows... I have…
-
Page Analyzer Link filter not working - Deep Linking
Following the notes on Sample Beast Mode Calculations: Miscellaneous Transforms, the section on Creating Page Analyzer Links (or Deep Linking with Filters). I am having trouble getting this to work - my first thought is there is some minor syntax issue I am blind to right now. Hoping another set of eyes can help. The Field…
-
Recommendation: Connecting to Vertex
Looking for some help - I am not an IT guy... not great with this kind of thing, so I'm looking for a recommended approach. We're looking to pull a custom report generated in Vertex to Domo (called a Data Extract definition in Vertex). My assumption is that this is probably best accomplished via their Web Services/FTP but…
-
Beast Mode: Table Card Total Row Issues
I have a beast mode I'm trying to use that calculates individual performance goals. Using a table card, and including total and subtotal rows. The first version of the beast mode was: (when sales dollars grow $2500 or more a 1% bonus is paid) case when (SUM(case when YEAR(`Date`)=2019 then `Sales Dollars` else 0…
-
Tracking Domo User Profile Picture Updates
Wondering if anyone has a best practice for providing a log of Domo user profile picture changes/updates. Would want to track events like these: When profile picture is added (first time add) When profile picture is changed (set as the user profile picture) Looking for a log with time stamps of the events note above occur.
-
Stuck: Dropbox File Advanced Connector
I am trying to get a file from Dropbox using the Dropbox File Advanced Connector and am so far not having any luck. Here is a short video to demonstrate what I’m doing:
-
Running Total with Magic ETL (not MySQL)
I've made this short video to explain what I'm trying to do:
-
Beast Mode: Sliding Window Function with Partition?
@jaeW_at_Onyx this is probably right up your alley with recent Dojo solutions and videos you have put together. Please see my video linked below, and attached sample data. https://youtu.be/Y21fV4t5kGk I have been able to do this with an ETL so for those that want to know how that is included in the video. I would prefer to…
-
BeastMode Help: Days Remaining in Quarter
I've got a beastmode I am trying to create that will calculate the days remaining in a quarter. * If the quarter is already over I want to show a value of 0 (not a negative number). * If the quarter hasn't started I want to show 91 (that's the number of days in a quarter) Any help would be appreciated. Also if this is…