-
Re: I am replacing power BI DAX formula into Beast Mode
Hi @Arjuman , Try this below, you might need to add a condition to adjust when dividing by 0 SUM(CASE WHEN YEAR(`ResolvedDate`) = YEAR(CURRENT_DATE ()) THEN `DaysToResolution` ELSE 0 END) / COUNT(DIS…2 -
Re: Dynamic series line bar
Hi @LCash , It shouldn't be difficult to do what you are trying to do. Make sure to select the correct Chart Type and also you might need to create a beastmode to use as a sorting option to make the …2 -
Re: Dynamic series line bar
@LCash Oh, I see what you are saying so , with your dataset being formated as the first table in your post, you will need to 1) bring forecast column into the Y-axis (sum Aggregation) 2) for the 'Ser…2 -
Re: How to see Average calls per Minute over the last 30 days?
@thwartted Ok, that's doable. You will need to do the following Make sure you have a field that only have the Time Minutes for the day. I see you have Date/Time Extract the Time from it in this forma…2 -
Re: Syntax of ANOVAF(), ANOVAP() and TTEST()
Update: I figured it out.. looks like in magic , the function needs to be added within the Group by tile add formula providing at least 2 fields containing the samples to analyze2