I am trying to create a stat panel using Google Sheets as source. I made a custom variable that has the same values as my first column, and then set the transformation of the stat panel so that it is equal to the variable. Theoretically, it would change whenever I change the variable, however if I click off of it and click back on, it’ll change into the value of the variable rather than remaining as the variable, which also means whenever I change the variable in the dropdown, the stat panel won’t update with it. The only way for it to work is to go into the transformation, and reset it to the variable.
Is there a way for the transformation to not reset the variable to its value at the time and just remain as the variable so it can change when I want it to?