2 Replies Latest reply on Feb 6, 2017 12:42 PM by MJ Gellada

    Using Parameter in Chart as an Axis

    MJ Gellada
    MJ Gellada Feb 6, 2017 10:40 AM

      Hi,

       

      Can you use a parameter in a chart as an axis to show how data changes as the parameter changes? I'm trying to count number of IDs when a parameter threshold changes. As the parameter changes from 1 to 30, how many IDs fall within the calculation and plot it in a chart. I've attached a packaged workbook with my current calculations.

       

      The screenshot below should illustrate what I'm trying to accomplish. The red arrow should essentially follow up to the blue dot. Currently, I can only display the value at which the parameter is set as opposed to all values going up to the parameter value.

      • 71 Views
      • Tags:
        • 1. Re: Using Parameter in Chart as an Axis
          Jamieson Christian
          Jamieson Christian Feb 6, 2017 11:42 AM (in response to MJ Gellada)

          MJ,

           

          I'm not sure if this is quite what you are looking for, but my interpretation of your requirement is that you want to see a line chart that shows every point for the current parameter setting and every lower setting (which does not form a straight line as shown in your mockup, so I'm not sure if I interpreted that correctly).

           

          After putting together the solution, I wasn't even sure if the parameter was needed, so I didn't include it in the first sheet. There's a second sheet that shows how the parameter could be incorporated to filter the results.

           

          Here's what I did:

           

          1. Create a Bin called [Days bin], with size 1, from the [Days] value.

           

          2. Put [Days bin] on the Columns shelf.

           

          3. Put CNT(Id) on the Rows shelf. (I used CNT and not CNTD because I didn't see evidence that CNTD was needed for this data.) Configure it as a Running Total over "Table (across)".

           

          4. Voila.

           

           

          For the parameter version, I created another calculated field:

           

          And then replace CNT(Id) with the calculated field. (I also adjusted the formatting so that nulls are "Hide (break line)" to avoid warnings in the corner of the display.)

           

           

          Workbook attached (version 10.1.4).

          • 2. Re: Using Parameter in Chart as an Axis
            MJ Gellada
            MJ Gellada Feb 6, 2017 12:42 PM (in response to Jamieson Christian)

            Thanks Jamieson! This is exactly what I'm looking for. The line in my screenshot was more of a mock illustration if the distribution was even across the days.