-
Beast Mode Calculation for Yesterday
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` = SUBDATE(CURDATE()-1, INTERVAL 52 WEEK) THEN (`Revenue`) END)) / SUM(CASE WHEN `Date` = SUBDATE(CURDATE()-1, INTERVAL 52 WEEK)…
-
Convert Week Numbers to Start of the Week Date
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, 5/9/21... 4/4/21
-
Excluding null values when using rank function in beast mode
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?
-
Dynamic Report with Ranking
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 dataset. As a result, I have multiple ranking numbers for the same model, when I use the rank & window feature in ETL. Is…
-
Income Statement
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?
-
Rolling Count Current Week
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 mode calculation for the current week. What would be the best way to calculate rolling count for the current week? Thank…
-
Rolling Count Calculation
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_Week', 'Rolling_4_Weeks', and 'Rolling_8_Weeks'. But I am getting 0 for everything, which is not accurate. Could anyone…
