-
Sum Count(Distinct) Sales vs Budget
Hello All! I'm trying to do Total Sales divided by Total Monthly Budget in beast mode. The correct output should be $150/$500 but DOMO sum all lines under Budget column that gives out $150/$1300. I tried Sum(count(distinct 'Store'), 'Monthly Budget') but no luck. Any solution?
-
How to build card
-
How do I change the data from being horizontal to vertical using a calculated field?
My data is currently horizontal so each column has a different month with the totals below (example below). I would like the data to be vertical so that it is easier to display the data visually within domo. I have placed an example below. I am not sure how to make a calculated field to display the date and totals…
-
Changing colors on bar chart
I have a background color set on a page, and I'm using transparent backgrounds on the cards. When a user hovers their mouse over a particular day on this bar chart, the text is not readable. I don't see any options on the chart to change the color when you hover over it or the default font color, or any options on the page…
-
Can i Sum the value in a set of data based on the max date selected in the date filter
Hi I have a set of data which is a snap shot of records each month. I want to Sum one column only where the date is equal to the latest date selected using the date filter in the chart. I tried the formula below but it is giving me no output. SUM(CASE WHEN `ACV Fiscal Month`= MAX(`ACV Fiscal Month`) then `ARR…
-
Domo Mobile
This is my first attempt at editing one of our pages for mobile, and I'm struggling to make it readable. The cards on this page are HTML tables. On the mobile view the headers are transparent, making them very difficult to read. No color rules applied. How do I fix this? One other question, the popup when I went to edit…
-
Period over Period - Specific Date Field instead of Current Date
We want to use the Period over Period charts since they make comparisons between different periods very quickly. As you know there are some requisites to build a PoP chart and one of them is the "Date Range". We noticed that this field takes into account the current date so, for instance, "This Year" today it will give the…
-
Analyzer - Filters get rearranged alphabetized after saving.
Hello, I noticed recently that after I save a card and go back in the analyzer all the filters used to filter my data to build the card are getting rearranged alphabetized. I rearrange them and hit save..BOOM! rearranged again. This is not how it always has been and is becoming very annoying. Is there a new option that I…
-
Can someone give me DDX Bricks examples which use traditional SQL (using JOIN) to query?
I want to use traditional SQL to query to fetch data from database in ddx bricks. My sql query contains INNER JOIN. Can it be possible? If yes, please refer to some existing example ddx cards or give me some example where using join and access result parameters from array-of-objects format are explained. Thanks in advance.
-
Limit Date Selector Card for User Interaction
I have a dataset that has multiple report dates with each value summing up total for that day (each row has its own value to sum for the day). I have a date selector card as a calendar format but need to limit the user to only choosing one day at a time since choosing more than one will make the data inflated and not…
-
Organic Growth Calculation
I'm trying to calculate the organic growth. I know in order to do so, I'll need to determine the following: Yr Ending Assets: CASE WHEN [REPORTING_CAL_DATE]=#2016-12-30# OR [REPORTING_CAL_DATE]=#2017-12-29# OR [REPORTING_CAL_DATE]=#2018-12-31# OR [REPORTING_CAL_DATE]=#2019-12-31# OR [REPORTING_CAL_DATE]=#2020-12-31# OR…
-
Scatter Chart Bubble Color
Is it possible to set the bubble color based on something other than the series? Like every bubble below 0 would be red and everything above zero green?
-
DP22 - Using Beast Mode to Build Data Storytelling
This post is the supplement to my presentation “Using Beast Mode to Build Data Storytelling” at my Domopalooza 2022 session. Over the course of that session I talked about several use cases and went over beast modes how to handle those use cases. I also discussed and talked about defining custom period over period…
-
DP22 - Using Beast Mode to Build Data Storytelling - Links and Images
This post is part of a series of beast modes I presented on during my “Using Beast Mode to Build Data Storytelling” Domopalooza 2022 session. If you find this post helpful please make sure to give it a like or an awesome below. Use Case We wanted to enhance the visualization experience and allow users to see which specific…
-
Unique Count based on Revenue Amount
Hi All, I am working on a beast mode to count the number of contacts that have generated greater than $100k in revenue. I've tried the beast mode below, but it's only pulling null values. I kind of expected this to not work, but had to give it a try. (CASE when `Revenue Amount (Global)` > 100000 then COUNT(DISTINCT…
-
When formatting one series, all numbers end up changing into percentages.
I am trying to build a card that includes percentages as well as totals. Rather than having viewers have to do the mental math off converting .6 to 60%, etc. I just wanted to have the data already multiplied by 100. But, when I change the settings for that one column, Analyzer changes all values to percentages whether I…
-
Count amount of dates in a row
I have two fields in a table, ‘DateOfStay’ and ‘Market’. ‘Market’ is representative of an airport and its nearby hotels. I’m trying to calculate how many individuals are staying at a market on a specific day (DateOfStay). Any insight on how I can approach/achieve this? E.x. On 2022-03-01, 3 people were staying at a hotel…
-
how to create a bar line chart
I just want to create a simple Bar Line chart.... how do I get the lines? This should be simple, yet I can't figure this out....
-
Need help creating an AND OR filter using Beast Mode
I need my data to filter based upon a couple of criteria. If the database column titled source_name equals 'shopify_draft_order', I need the data to show. Also, if the database column titled referring_site is blank and another column titled landing_site contains the word 'invoice', I need that data to show as well. Not…
-
How does the dashboard level filter work?
Can someone explain how the filter in the upper right part of the dashboard works? Does it filter charts by all dates that exist within their datasets? For example, if I have a dataset that has multiple date fields (registration date, order date, shipping date, returned date, etc.) and I select a date range of 1/1-1/7...…
-
Heatmap Percentage of X-Axis Beast Mode
Hi all, We're new to using Domo and trying to work through how to setup the beast mode calculation we'd like to see for this. We have a dataset of feedback from individuals about things they enjoy about out company by location, but this is skewed towards our larger offices that will always have a greater n-value. We'd like…
-
Adding a cumulative total line in a multi line chart in Domo
Hi everyone, Does anyone know how to add a cumulative total line chart in a multi-line chart? I have 3 different lines that I want to show on the same line graph and I want to sum up the 3 lines and put that line on the same graph so a total of 4 line on a single graph. For example, Blue = 1, Yellow = 2, Red = 3, and I…
-
Dashboard Filters
Hi Guys, When I filter the date range by week I am getting the week of 05/27/2022 to appear on my card, but I am not getting the June of 2022 or the year of 2022 when I try different ranges. CASE when MIN(`Period_End_Date`)=MAX(`Period_End_Date`) then DATE_FORMAT(`Period_End_Date`,'Week of %b %d, %Y','month of %b %d, %Y')…
-
Beast Mode Date issue
I'm trying to build a beast mode field that does the following... When the date_created is great than 131 and the last payment date is between 55 and 86 days, then we are in month 3
-
Drill down to a separate dataset - matched by column?
I am trying to create a card that drills down to another dataset, but matches values based on a specific column in order to show rows for the selected category. For example, the card categorizes employees based on country (dataset A). When I click on US employees, I want the card to drill only show me US employees BUT…
-
Default Date Filter on an Embedded Dashboard
(NOT USING DATA RANGE) I am wanting to filter data by Week ( 1, 2, 3, 4, 5, 6, etc..), but I am having trouble finding a solution that will allow me to 1. have a default filter that will open up the dashboard to the current week and then 2. being able to filter by other weeks. Here's what I have tried: Using the Beast mode…
-
How to see which account has the greatest increase in activity
I have a card that looks at how many hours our operators spends on each customers account. The X axis has the account name/number and the y axis shows how many total hours we have spent over the time period (which for the card is year to date). The columns that we are using from the data set include: account name/number,…
-
OR statements in card filtering
Hi folks - We have a dataset where users can have datapointA and datapointB. We want to build a card where an end user can have a filter that asks for any user has datapointA = 'green' OR 'databpointB = 'circle'. When we put those two datasets in a dataflow/card and add the datapoints as Quick Filters, it automatically…
-
Help with dynamic text for information block instead of KPIs
Can anyone help explain how to set up dynamic copy? Objective : I want to create copy that looks like the example (or some variation) where copy in the parenthesis [] is dynamically pulled values from the record selected in the filter) Example: [Campaign name] is [description] and start date is on [start date] and has a…
-
Dynamic date range (last two quarters data)
HI All, I am looking to create a dynamic date filter on my card. The objective is to get last two financial year quarters data. I am aware that there is an option in DOMO to get last two quarters data but this gives me incorrect results i.e if we are in May then this gives me nov - april data but what I need is oct 1st -…