I currently I am having a hard time customizing the color in an expression. We want to be able to use different colors to make it go along with our theme colors.
In addition, I currently have to filter for a single date to show the rest of the data related to that date (where current selection is '6/11/2015'), but given the above information, I was wondering if there is an effective way to display Current Score (the latest date) and Previous (the second to last date). There could be more dates and the two dates are not necessarily in two different years.
I am open to any other ideas to effectively display this information. Please find attached data and qvf files as support materials to this question.