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`)) /…
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?
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…
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…
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…
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…
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…
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…
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.
It looks like you're new here. Sign in or register to get started.