Hi, I am working with a set of klips that I did not originally create. A variable called $monthselect has been set up for a user input control where you select which month of data to display in a chart. Each month I add 7 rows to the data source (1 row for each of our locations). So currently for 2017, I have 77 rows - 11 months, 7 locations. It is a very simple data source with a column for month (Jan to Nov), a column for the location (let's say Location 1 to 7), a column for the denominator, and a column for the numerator. The chart has a month selector and each month you will see the 7 percent bars for the 7 locations. However, when the data source refreshed to include November, I still can only select through October. I can't figure out how the previous person set up the variable to understand why it is not recognizing the November data. Thank you for your help!!!
Information about a variable