I'm trying to recreate Dash Davidson's (Dash Davidson) tooltip from his Dashboarding On The Edge Of Impossible session in Austin. My formula appears to match his perfectly, and his Player field appears to be a text string, just like my Student Full Name field, but I'm getting an error that says that I can't use Student Full Name - but instead need to use a Float variable. Why is this happening? What is the difference between what I've written and what he wrote?
My data are protected public school student data, so I can't share the workbook. I hope this screenshot will be enough to determine what the problem is. This is a function that I'm dying to figure out! It would really take this particular dashboard to the next level! Thanks.
As I'm examining this - it seems that the problem is that Dash's calculation is a Default Table Calculation and mine isn't. But how do you make a table calculation in the regular Calculated Field edit box? That seems to be the issue, but I still don't know how to resolve it. Thanks.