-
Period over Period in a table
I'm attempting to do a Period over Period in a table, but want to keep the date range to previous week/month/quarter to keep it auto-updating and grouping the data in a particular way. My idea was to create a new column in ETL that is the same as the column I'm trying to do a Period over Period calculation, but from the…
-
Card Alerts
I'm working on setting up some alerts, however i can only choose the card summary number to set the alert up on. I've watched the tutorials online and they show that you can set alerts up on multiple card variables. Does anyone know how i can set the alerts up on multiple variables for one card?
-
group by and sorting by date
I have daily data (years of it) that will be grouped by category (columns summed by group), but also need it to happen within different date ranges. Last week, MTD, QTD, YTD etc. The only way I can think to do this is maybe in the ETL creating a new column with case statements for each category/date possibility, but this…
-
Quickbooks reports display
We are pulling a standard Quickbooks Online report (P&L) with the Quickbooks connector. But the report data is just individual rows. How do we display the report like a normal P&L would display in Quickbooks?
-
Can this card be built without pre aggregating the data
HI, As the title says can this be built without having to pre aggregate the data via a view or ETL. I have hourly data for 14 days. 7th Jan 2019 to 20th Jan 2019. data set is much larger but as an example. So the data is datetime and a count figure. e.g. 07/01/2019 01:00 6 07/01/2019 02:00 9 07/01/2019 03:00 10 07/01/2019…
-
Comparative Gauge using Scale Abbreviation for Value Change
Hi there! I am trying to have a comparative gauge show a value change, but the whole number and not abbreviated into thousands (K) or millions (M). I can't seem to find a way to get it to stop abbreviating on this particular card type. Any suggestions?
-
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…