-
This is coming out to be a date format beast mode. How can i change this to integer?
(((DATE - Lag(DATE,1) over (partition by ID,FAMILY order by INVOICE))))
-
Is there anything wrong with this calculation?
((case when Date = '2023-03-01' then sum (test1) end ) - (case when Date='2022-03-01' then sum(test2)end)) / (case when Date='2022-03-01' then sum(test2)end) Trying to calculate the %chg between two points in the dataset
-
Quarterly Chart
I am trying to create a line chart and graph it by Quarters but the only thing is that instead of summing the values or taking their average, i want to only take values for the last month of the quarter. e.g For 2022 q1 it would be march 2022 , q2, june etc
-
Setting up an alert
Hi Team, I want to set up an alert for my data whenever a new month comes in. Can you please advise how can i set that up considering i have a date field.
-
YoY Chart
I want to create a YoY line chart with Time on the x axis, YoY change on the Y axis and Year in the series. So it would have 3 lines for the years E.G 2021,2022,2023 How can i do this?
-
How can i use alias with concat function in beast mode?
-
Date Transform
I Have a year and a month column in my dataset which are in the format of integers. I want to create a beast mode calculation to concat them and have them as a date field. How can i do that?
-
Beast mode calculation
I want to create a beast mode calculation which should be something like this Value for current month this year - value for current month last year / Value for current month last year How can i do this?
-
I am using this beast mode but it wont let me save the card
count(ID) over(partition by Clinic,Product)
-
Case statement
Case when Toggle = 'Key Brand' then ( case when Brand = 'BL' THEN 'BL' when Brand = 'SC' then 'SC' when Brand = 'RC' then 'RC' when Brand = 'RO' then 'RO' when Brand = 'PU' then 'PU' else 'OTHER BRANDS' end) END I am trying to use this case statement to make it react to toggle but i want to find a way around other brands.…
-
Why is this not working
case when Sales/Volume = 'Sales' then case when YEAR(`Datestamp`) = YEAR(CURDATE()) -2 then CONCAT(ROUND(SUM(Sales_USD)/1000000, 0), 'M') END
-
I am trying to use a case statement with a Time field for a table but when
I am trying to use a case statement with a Time field for a table but when i do it the values come out to be empty
