I have a chart that I'm using an input field in. In the chart, I have a calculated dimension that uses a combination of an Aggr and a Rank function. For some reason, it doesn't rank properly when the values in the input field are changed (they're changed in another table, which should update the values in this one). If I change a minor thing in this table (such as just putting an extra set of parenthesis or having an extra set and then removing it), it works fine until the next scheduled reload. At that point, undoing the change I'd previously made would make it work again.
Any ideas on why this might be happening, and what I can do to make it always work properly?