Year filter on YOY comparison
Hi All, I have card that I need filtered by chosen years. I have a 5 year data (2017-2021) and need be able for users to compare 2 chosen years using a filter. I tried the min/max function but does not seem to return the right result. I used the below BM: To show recent year: case when `Year`= MAX(`Year`) then sum(`Gross…
Excel reporting with macros upload at appendix
Hi Is it possible to upload an excel report with macros to the appendix. I am looking to use this as a reference only. Users can download the report and do their own analysis. I am not sure if Domo has a upload/download capabilities for sharing files. Thank you
reporting table last 60 days
Hi I am trying to create a table that shows our orders for the past 60 days. The date will be based on order date. I am new to domo and not sure how to create the beast mode. Thank you in advance.
Sum of Distinct Count Variance
Hi I need help on below beast mode not working. I am trying to get the sum of all the variance using distinct count of customers. I am trying to get my total points of distribution gained. Thank you in advance. SUM(COUNT(DISTINCT CASE WHEN `Year`= 2020 AND `Month #` <=`Month # for Today` THEN `Customer Name` END )) -…
Historical data for new year with beast mode
Hi We are coming to a new year, our fiscal year starts Nov, and wondering on how I can see historical data on my dashboard. Most of my beast modes are YTD like these 2 below. On the first month of 2021, my data will all change to just one month. How can I get a full year data for 2020 for historical review. Is possible to…
beast mode for latest 12 months
Hi I need help creating a beast mode to show monthly gross rev for the latest 12 months. I have example on how I get my YTD gross rev below. I not sure if it can be dome in beast mode or any other way. Your help will be appreciated. Thank you in advance. SUM(CASE WHEN `Year`= `Year for Today` AND `Month #` <=`Month # for…
An issue has occurred during processing. We are unable to complete the request at this time.
Hi I am new to Domo and have no SQL knowledge. I am trying to get our YTD cases quantity with some condition taken from other working beast mode. If someone can please help me figure the beast mode below why it's erroring. Thank you ion advance. SUM(CASE WHEN `Year`=2020 AND `Month #` <=`Month # for Today` THEN (SUM(CASE…