1 Reply Latest reply on Nov 7, 2012 1:29 PM by Mark Holtz

    Parameter to not show line at certain value

    Anna Chan

      Hi

       

      Is it possible to have a parameter that if a certain value is greater than the parameter, there will show no value (ie no line) and the line would would start when the at the respective value the parameter is currently set at? I have attached a sample workbook.

       

      Thanks,

      Anna

        • 1. Re: Parameter to not show line at certain value
          Mark Holtz

          Hi Anna,

           

          I think you just need to create a calculated field to replace your measure(s). To be sure I understand you correctly, do you just want the line to disappear for values over the parameter value?

           

          You have a parameter set up as Days to Release. So you want any records where the Days to Release value is greater than the parameter selection to be removed?

          e.g., If 14 is selected, then none of the Days to Release values higher than 14 should show any data...

           

          To do that, I created Calculation 1 and replaced the "Actual" measure on your line graph. You can make Calculation5 follow suit with the same mechanism. I've attached your workbook.

           

          If that's not what you're asking, I'll try to help if you can clarify.