-
How to show a specific date with an aggregate (max)
Hey guys, So I'm creating a card that looks at the sales of our employees each day and then lists the day with the max sales. Our Data is structured by transaction, so I had to create a Magic ETL to Group the sales by date and employee in order to find the max by day. The problem I'm having is when I try and display the…
-
Is there a way to combined and calculate 2 cards in 1?
I want to combine a revenue card in positive numbers and a expense card also in negative numbers to a PL card. is that possible? each revenue card and expense card shows multiple users that are already sorted in pivot table. I want to subtract expenses from the revenue per users.
-
How specific can I get with dynamic scale markers?
Hi all, I'm working on a year-over-year card where I want to add a goal line that represents a 10% reduction from the previous year. However, this is a card that I have a slicer for, so I want that line to be dynamic as the data changes. Is that possible? The furthest I was able to get was to create a percentage scale…
-
Domo beastmode and pivot question
Hello, I'm trying to automate a file to run calculation in DOMO on a card. In the attached I added a sample data and a pivot table to show what I'm trying to get to. I was able to get the pivot completed in DOMO, but the additional column Collection Total, I cannot figure out how to create a beast mode for this, I'm trying…
-
Capture error in a Card
We're currently using a Range Selector card to allow users to filter our data based on a MIN and MAX date. The problem is that we sometimes have no data when users initially access our platform and they see the error "Error: The maximum value is less than the minimum value" and that leads this to thing that there's an…
-
Adding a new column of data to a existing card
I have created a card in which I have mentioned which courses have distributed how many certificate but the problem is I only have Course Id in this table and I have course name in some other tables. It is possible to add that column into my card
-
Drill-path showing in dashboard
Hello! I know it is possible to see the drill path in the card details. Can we directly click on the card in a dashboard and see the table from the drill path show up directly in the dashboard (without going first to card details)? Thank you, Helena
-
Independent filtering within a dashboard, using the same column
Hi, I have a dashboard that tracks our current sales performance for the day with various comparisons, which works great. I've had a request to produce a version of this that would allow end users to select two dates, and then comparisons would run between these dates. I'd need to filter different cards, with different…
-
How do I create this dual x-axis type of chart in Domo
How can I create this chart in Domo? How would my data need to be structured?
-
Is there a way to track user reported card issues if you are not the card owner?
I am inheriting a DOMO instance where I am not the card owner of the majority of our cards. I would like visibility (i.e. a Card that tracks reported issues) if a user reports an issue on a card but I can't find any way to create visibility for that other than making myself a co-owner on all of the cards in our instance.…
-
% Change Columns in Pivot Table
Hi Dojo Community! My team is trying to create a card for a customer that allows them to select a range of years and/or months to compare (they will most likely view one month at a time), apply additional filters as needed, and drill into the table. The card should be structured like the screenshot below. There should be a…
-
Drill Path Filter to show Specific Apt's without a Specific Procedure
Hey guys, I'm afraid that the answer to my question is that I need to do it in ETL, but I was hoping that it could be done via a beast mode instead. Basically I have a list of procedures done by our dentists that looks similar to below: Dentist | Procedure | Procedure Date| Appointment Number | Patient Dr B | D0330 |…
-
Beast Mode Help Avg Order Value PoP
I'm trying to calculate the average order value and make a percentage to compare to it last year. Below is the beast mode, I've been trying to use. I have the Domo dimensions calendar hooked up to this flow. (SUM(`Current Gross Sales`) / COUNT(`Current Orders`) - SUM(`Last Year Gross Sales`) / COUNT(`Last Year Orders`)) /…
-
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…