I tried to understand your expressions, but see my example.
Greetings from Munich
TestGauge.qvw 160.0 K
Thank you for taking the time to try to address my problem. Unfortunately, your example still experiences the same issue I am having in my object--when trying to compare anything but the current and previous, you must select both of the years you want to compare. If you only select one year, the gauge does not work.
I was hoping to find something that would compare the max year (based on the current selection) to the previous year. So say if you select 2011, then in the gauge it would compare 2011 to 2010.
Any further suggestions?
While my original question was solved, I am experiencing another small issue--When trying to use this same formula, but only looking at Fridays, it is giving me the same problem--both years need to be selected in order for it to work.
I tried to fix it like this, but the syntax isn't right:
Any ideas on how to fix this? Thank you in advance!