How can we help?

New post
1

Need Help with Chart / User Input Controls [Image Attached]

Avatar
Michael Swenson
None
Follow

Hi There!

Image attached  - and further explanation below.

Select:

Utilize the user input control to choose a row of data based on matching information (Matching the selected variable value and a specific column in that row containing the matching value)

As a result:

Plot values from specific columns from that selected row on a chart.

I'm comfortable using user inputs and variables to pull data. Just haven't done this one before and seem to have a blind spot. I thought Array might have been a way to go with column selections but haven't had any luck solving this.

 

Date Votes

4 comments

  • 0
    Avatar
    Janice Janczyn

    Hi Michael,

    You can use a User Input control to set a variable that is used to filter your chart using hidden data. These short videos show examples to follow.

         Filtering using Hidden Data

         Filtering using a User Input Control

    Thanks,
              Janice

     

  • 0
    Avatar
    Michael Swenson

    Thanks Janice- the more specific issue I am having is how to select those columns to plot out on the chart.

  • 0
    Avatar
    Michael Swenson

    UPDATE:

    I was able to select columns using this :

    ARRAY(@Shipped Units,C:C;),
    SLICE(@Shipped Units,D:D;),
    SLICE(@Shipped Units,E:E;))

    But I get the results of (just adding all three rows with their entire contents) That seemed like a step in the right direction. Buuut.,,,

     

    When I filter the series using the input selector, things fall apart.

  • 0
    Avatar
    Janice Janczyn

    Hi Michael,

    Klipfolio is designed to work best with columns of data so if you could re-orient your data such that the dates are in a column instead of a row that would simplify klip building. That said, with your data as is (with a fixed number of model rows), I would approach your scenario as follows. The key is to ensure the data in each subcomponent in the table (x-axis, series, hidden data) aligns.

         x-axis: REPEAT( @1:1, 6 ) 

    This repeats the months 6 times, once for each row of model.

         series: ARRAY( @2:2, @3:3, @4:4, @5:5, @6:6, @7:7 )

    This creates a single serial list of data for all the models.

        hidden data: ARRAY( REPEAT( "123", COUNT( @2:2 ), REPEAT( "124", COUNT( @3:3 ), REPEAT( "125", COUNT( @4:4 ), REPEAT( "126", COUNT( @5:5 ), 
                                            REPEAT( "127", COUNT( @6:6 ), REPEAT( "128", COUNT( @7:7 ) )

    This creates a list of model numbers to be used to filter your hidden data.

     

    If you have further questions, please email support@klipfolio.com with the details. You may need to grant support access so someone can take a closer look.

    Thank you,
                 Janice

Please sign in to leave a comment.