-
Card Level Interaction Filters
This is a pretty straight forward question. When interaction filters are enabled on a card does it only work on cards that are running on the same dataset with the interaction enabled? For example I can 1 card that I want to filter other cards, some cards are on the same dataset, some are not. I thought that similar to…
-
Data Warehouse Summary Values
Can someone tell me what is counted as 'DOMO MAGIC DATA' in the summary metrics shown in the top right of the data warehouse screen? I've read the documentation on the Data Warehouse page and watched the little video but it doesn't specify what that is counting. I originally thought it was dataflows so I created a test…
-
Rolling 3 Mo Avg - Breaks Card
I want to calculate rolling average of the previous 3 months. I was going to do this using windowed lag functions ( (LAG(SUM(`Sales Amount`),1) OVER (ORDER BY `YEARMONTH`)) + (LAG(SUM(`Sales Amount`),2) OVER (ORDER BY `YEARMONTH`)) + (LAG(SUM(`Sales Amount`),3) OVER (ORDER BY `YEARMONTH`)) )/ 3 Each Lag works individually…
-
Running Total Group Bar - keep running total but show only current month, possible?
Hey all I have an end user that is requesting for a running total graph to only show current month but still retain the running total. When I filter for current month, it does exactly that, filters only to current month so the running total from the previous 2 months is lost, as I expected. I'm wondering if its possible to…
-
What is wrong with my Pivot - Uncollapse Columns? Showing Null
Hey I'm trying to pivot a column, but the new columns are all null Here is the original data This is how I've set up the pivot info This is the output I get: Originally not every Customer_ID had ever Level(1/2/3) I thought this was the cause of the nulls but I've fixed it so every Customer_ID has all levels and still the…
-
Calendar Chart - NON-abbreviate Values
Hello all, This should be simple and straight forward but I can't find the setting/property I'm looking for. I currently have a calendar chart showing values in each day. However the values have been abbreviated by millions and I'd like to see the full value rather than the abbreviation. I don't see an option in the…
-
Calculating the Running Maximum
Is there some way to calculate a running maximum either through ETL/SQL? I have employee hiring data and I want to check if an employee newly hired into a position is a backfill or a new growth. This classification is part of others that are used in existing charts showing how many active/hired/job change/terminations…
-
Filters & Drill Throughs - Is there another way?
I find myself in this pickle because of the nature of my data. I have employee data that is batched monthly. So each month has all people ever employed at the company(along with info such as hire date, termination date, position, department etc..). I've already done some manipulation in ETL so that when an employee is…
-
Keep first occurrence of value and set subsequent values to 0
I'm working with invoice data that has multiple line items for each invoice. The issue is that the tax field has the entire invoice tax value on each line item as shown below: | Invoice | Item | Amount | Tax | |---------|------|--------|-----| | 1 | A | 10 | 6 | | 1 | B | 20 | 6 | | 1 | C | 30 | 6 | What I would want |…
-
Gauge - Set Maximum as Target Value
I am working on a Filled Gauge, I want the maximum to be dynamic and reflect just the target value. Any ideas on how to accomplish this?
-
Number of Views by External Clients on Embedded Pages
I have implemented the DomoStats app, but from my exploration it seems as though it is only logging views from internal users. We, however, create dashboards that are embedded for external clients to use and are interested in tracking the number of views by those users so we can evaluate if our dashboards a value add. Does…