0

Hidden data based on different datasources

I have 3 data sources that contain the client name. I a line chart with 3 series that each one is based on one data source. I want the filter on hidden data to work on all of them. 

2 comments

  • Avatar
    Parker Selman Official comment

    Hi Parissa, 

    Thanks for contacting Klipfolio support! 

    In order to have a hidden data filter that works across data sources, all the subcomponents of your line chart (ie each series, the X axis, and each hidden data element) will need to include all data sources in an ARRAY() function. For example, your x axis would be set up as:

    ARRAY(Data Source 1 dates, DS 2 dates, DS 3 dates) 

    and your series as 

    ARRAY(DS 1 data, DS 2 data, DS 3 data) 

    And so on. Once these ARRAYS are set up, you can use hidden data elements to filter on the entire data set across the three sources. 

    One thing that is important to note is that you will need to set up additional formula elements in your series to filter out the data from the other two sources that you don't want displayed on that particular series. Without seeing your data, it's difficult to know for sure how to implement this, but you could eliminate invalid values with an IF condition that returns a blank if a false value is returned. Setting this up should allow you to only return valid data for the data source  you choose. 

    Hope this helps! If you have any questions around this, please submit a ticket with our support team and we'd be happy to help! 

  • 0
    Avatar
    Parissa Parvizi

    Thanks for your reply. For making the 3 series work I already used the Lookup formula. Now I used array(@B,@B,@B) as x-axis but filter on client data still doesn't work. I also tried LOokup in the client data but it doesn't work :( 

Please sign in to leave a comment.