I currently have a calculated dimension in a bar chart which is an 'if match' statement specifying specific months that I would like to show in the chart. However I would like the chart to have more functionality so that I do not need to hard code the months that I wish to display. I would only ever like to display the months between now and 6 months in the future. I have both date and month fields in my data. Am I best to set this as a calculated dimension or use set analysis in my expression?
Any advice on the best way to select between dates would be much appreciated.