Steve-DOMOnoob

Hi @MichelleH, I was aiming to use the R-squared value to rank the increase in trend over a set period. i.e. if one variable had an R-squared value of 0.9 and another 0.2 then they would be ranked 1st and 2nd respectively. There possibly might be a better way to do this that i'm not aware of.

Thanks @GrantSmith this worked well. I originally tried this but for some reason it didn't.

Thanks @jaeW_at_Onyx. As you have suggested i have used the below beast mode. sum(CASE WHEN (CASE when`Temp`>=24 then 'warm' else 'cool' end)='WARM' then 1 else 0 END) / sum(CASE WHEN (CASE when`Temp`>=24 then 'warm' else 'cool' end)='COLD' then 1 ELSE 0 END) this work perfectly to calculate the percentage. however when i…

Thanks @GrantSmith

@MichelleH disregard my previous reply, it now ok with some formatting tweaks. ?

Thanks @MichelleH this works great. Do you know if there a way to have the text all on one line instead of the date underneath the text.