I have a CAGR calculation that uses parameters of Number of months to base the rate calculation, and Number of future months to plot the forecasted revenue. How do I use these paraments to filter the page and/or visual to only show the X number of past months and X number of future months in the chart?
I do have a date table, but the parameter table does not link to it. The filter of the visual does not accept a measure (measure is used to capture the value entered in the parameter). Any ideas?