I am trying to get a % Change of Revenue between Yesterday and Same day last year. My beast mode formula was: (SUM(CASE WHEN `Date` = CURDATE() - 1 THEN (`Revenue`) END) - SUM(CASE WHEN `Date` = SUBDA…
I am trying to create a table graphed by week, and the analyzer converts the date columns to week numbers. Is there a way to convert these week numbers to start of the week date? eg. 5/23/21, 5/16/21,…
I used "rank() over (order by asc)" in the beast mode, but I am getting blank rows on the top, followed by the correct rank . Is there a way to exclude the null values when using the rank function?
Hi, I wanted to create a report that shows sales rank of each product by Store. However, because there are more than one transaction for each model, there are multiple rows for the same product in the…
I have a dataset of all accounts but I need to create calculated rows like Income before taxes, net income, etc. What would be the best way to create income statement cards?
I am trying to create a table with rolling count of the current week, last 4 weeks, and last 8 weeks. I was able to create beast mode calculations for last 4 & 8 weeks, but I am lost in creating beast…
Hi, I am trying to get a rolling count of data over a week, 4 weeks, and 8 weeks period. This is the sql query I have in the transforms dataflow. Then in the analyzer, I would select Count of 'Rolling…
