LLucinski Member

Hi @Cartergan -- Thought your suggested beast mode was the solution, but it did not work. Today's data is not yet available and the chart is showing, "no data in filtered range". Any thoughts? Thanks. I used: case when `DATE` = CURRENT_DATE() then CURRENT_DATE() ELSE SUBDATE(CURRENT_DATE(), interval 1 day) end…

Thank you!

Mark - Thank you so much! I couldn't see the forest throught the trees and this was so easy. Thanks again, Laurie

No, I was not able to get it to work. I just couldn't get beyond the issue that the both of the metrics I needed to perform the operation were in the same column. I went back to the requester to ask that the metric be added to the source file. I do appreciate your help though! Thanks.

Thanks for the suggestion! I will give this a try and let you know how it turns out. Laurie

I found the datasets -- thanks, very helpful, but can't find the public dashboard? How does one access this? Thanks, Laurie

Thanks very much -- I will give your suggestion a try!

I'm now just able to see Insights associated with my cards. Provides some useful basic stats. Too bad it's not editable. Access is through an ever so subtle icon in the upper left: Happy hunting, Laurie

Valiant - thanks for your reply. I think I'll change it back to a monthly view! But I will put in a suggestion to reinstate the quarterly function. Thanks.

FYI -- I am getting the same error message and was searching for a solution. I will go ahead and contact support.

Thanks for checking it out and I agree with your suggestion and will try that route!

Was a solution for this ever identified? I have the same issue, but with a variance line bar chart, where the variance is a bar. I've added color rules for when the variance is positive and negative, but the "series", variance is still showing in the legend. See the magenta box below. Thanks!