-
Possible to use a value that ignores filters?
I'm looking for a way to use a value in a beast mode formula that ignores my current filters. I've been wrapping my head around this problem and can't think of another way to solve it. Here is an example with my issue: Let's say my company has 5000 employees. There is a survey database with multiple rows of data for each…
-
Customize Color Theme / Reverse Order
I recently built a heatmap table where I want the lowest numbers up top. These start around -25 and end at -10 currently, but the numbers will change each time the chart is updated. I also only want to show 10 rows of data, so the table has been limited to the 10 top results. I want the heatmap to display negative numbers…
-
Lag Function Giving me Values that Don't Exist?
I'm trying to create what should be a simple table that shows job Last Quarter Salary, This Quarter Salary, and Percent Change. However, my Beast Mode is giving me values that aren't even on my table. The Current Salary is displaying fine, but the previous quarter's salary is giving me a fictional number. Here's my formula…
-
Why is a field not allowing me to exclude it?
I recently built a new field for my dataset in Excel that added certain employees into specific groups. Most employees are not in these groups, so when I joined that field to the rest of my dataset most of the fields are blank. This should be fine. However, when I add this field as a filter into any dashboards or charts,…
-
Using a Beast Mode within a Beast Mode? (For Rolling Attrition)
Is this possible? I'm trying to build a rolling attrition report and I have 2 separate attrition beast calculations (one for a single month's attrition and one for more than 1 month of attrition). This works fine for showing point-in-time attrition (a year, a quarter, a month, etc.), but I've now been tasked with building…
-
How to Create Monthly Averages for Headcount?
Hi All, I'm in the process of building an attrition model in Domo in the form: Total Terms / Average headcount Terms is easy, that's just a count of everyone with a term status for that time period. Headcount is where I'm getting stuck. My headcount numbers are currently aggregated based on headcount at the end of each…
-
How to Share Pages without Sharing Data Set?
I've been working on a few Dashboards in Domo that have sensitive data in the underlying data set. The cards I've built have aggregated this data so it isn't identifiable and I've turned the filter options off and locked the page. Therefore, anyone I could share the page with would not be able to filter to the sensitive…
-
Can you Insert multiple X-Axis?
I'm attempting to build a new chart where there are multiple columns with a single value for an individual. I know this isn't an optimal data set, and I've reworked it for another dashboard, but I would like to keep it in this format if possible. I believe other data visualization tools allow you to add multiple x/y-axis…
-
Linkedin Accounts, Campaign Groups, and Campaigns on 1 Table?
I'm trying to build a dashboard for Linkedin data, and the data connector isn't very intuitive. I've been using the 'Ad Analytics' report because that seems to be the only one that shows spend and clicks. So far, I've built 3 separate tables for Accounts, Campaign Groups, and Campaigns. The only field that seems to display…
-
Using Beast Mode to filter on multiple values?
Since using Domo, I've come across multiple scenarios where I need to filter fields based on multiple columns, and I haven't found an easy way to do this in card building. So far, I've resorted to hard filtering everything out using the ETL, but that isn't very flexible. Here's an example of what I'm trying to filter:…
-
Google Analytics Exclude Filter
I'm working with a very large data set where most of the data is not tied to a GA Campaign. In order to reduce the amount of data I'm working with, I'd like to filter out all rows that do not have the value "(not set)". My current formula: " { "dimensionFilterClauses": [ { "filters": [ { "dimensionName": "ga:campaign",…