15

Pivot functionality for datasources with dynamic series

We desperately want the ability to have a dynamic number of series (that can grow or shrink) supported by Tables and charts like Line/Bar. Currently you have to create a set number of series and hard-code their labels. Tables do allow dynamic naming of series, with the option to use Row 1 as labels, but you still have to create a set number of columns.

 

Allow us to define a "Series Range", telling the chart to generate a series for each distinct value in the range.

 


Use case 1:

Area Graph: X:Date, Y:Revenue, Series Range: Payment Method

We want to graph our revenue, by date, for each payment method available.

Over time, we add new payment methods and delete old ones. However to reflect this in klipfolio, we'd have to manually add/delete each series as it is created or deleted. 
 
If a series range were possible, klipfolio would effectively do this automatically by only displaying data for series present in the datasource.

 

Use case 2:

Area Graph: X:Date, Y:Revenue, Series Range: Item, Variable: Product Locale

We want to have the same klip use a variable to determine which locale's data to display. But each locale could have a differing number of series and in different languages.
Having to define a set number of series doesn't work for this case, nor does hard-coding the labels.

Again, a series range would solve this.

 

33 comments

  • 0
    Avatar
    Scott Lawrence

    Hi Dominic,

    Thank you for the detailed use case!!  To spin it back to you a different way (and validate my understanding).....

    If you had a data source with (at least):

    • Date
    • Payment Method
    • Revenue

    Identify the field Payment Method as the Series driver.  (I am imagining it as Grouping on Payment method.)  You would want a series for the data associated with each grouped value for Payment Method.  

    In Use Case 2, I believe it would be similar. 

    • Date
    • Revenue
    • Item
    • Locale

    The Variable on Locale would filter the results before going to the visualization.  Identify the field Item as the Series driver.  You would want a series for the data associated with each grouped value for Item.  

    Am I understanding your use cases accurately?

    This has been raised for prioritization in our roadmap and I've added your name to it as a reference point.

    Thanks again!

    Scott.

  • 0
    Avatar
    Dominic Yerex

    Hi Scott,

    Yes exactly!

    Really appreciate the quick response. 

     

     

  • 0
    Avatar
    Koen Jans

    Any updates on this?

    Thanks,

    Koen

  • 0
    Avatar
    Scott Lawrence

    Hi Koen,

    Thank you for adding your voice here and your support for this feature request.

    This is on our radar.  It has not currently been scheduled.  We will update this thread when it has been scheduled.

    Cheers,

    Scott.

  • 0
    Avatar
    Adapteev Team

    Hi,

    What's the range on that radar, more specifically? :)

    Paul

  • 0
    Avatar
    Dan Aakerhjelm Jensen

    I need this as well. Any news on the radar?

  • 0
    Avatar
    Jelle Overmars

    Hi Scott, do you have an ETA for this feature request? Would be really nice to be able to use this. Br Jelle

  • 0
    Avatar
    Scott Lawrence

    Hi Jelle, Dan, and Adapteev Team,

    Thank you all for adding your voice and support to this feature request.

    I do not have a specific timeframe for this at the moment.  That said, it has been a topic of multiple discussions recently.  

    Cheers,

    Scott.

  • 0
    Avatar
    Frantisek Kalab

    Let me add my voice here as well, It would be in general good if Klipfolio focused a little bit more on automating certain trivial tastks...like naming a series in a line graph based on a column or allowing to swich data-sources easily within klips. The absence of these features could be the only factor which might eventually lead me to leave the platform to be honest, I hope it is going to be worked on soon :).

    Best,

    Frantisek.

  • 0
    Avatar
    Stephen Yates

    Hi Frantisek, we appreciate your feedback. This feature is included in our plans for improvements for the Klip editor and is being factored into the designs we are working on now. It has not yet been scheduled for development, so I cannot provide a release date at this time.

    Thank you

  • 0
    Avatar
    Marcus Henningsen

    +1

  • 0
    Avatar
    Stephen Yates

    Hi Marcus, thank you for adding your support for this feature. 

  • 0
    Avatar
    Johannes Schwarz

    Very much needed!

  • 0
    Avatar
    Pratap Dinahar

    Hello Klipfolio - just wanted to follow up on this functionality and see where it's at. +1 for that feature. 

  • 0
    Avatar
    Sudheer Satyanarayana

    An ETA would be appreciated. This feature will help a lot of manual maintenance.

  • 0
    Avatar
    Scott Lawrence

    Thank you for your support for this feature request.

    This is still on our radar as a desired feature, however has not been scheduled for a specific release.  Your support and use case are added to the feature request to feed into prioritization efforts.

    Cheers,

    Scott.

  • 0
    Avatar
    Mike Psaris-Weis

    Scott,

    Do you factor the number of comments into a feature request's priority level? This feature has only 3 votes, but including myself I see 11 people voicing their interest, which would put this feature in the top 5 most popular feature requests. 

  • 1
    Avatar
    Scott Lawrence

    Hi Mike,

    Thank you for your note.  We do take into account comments and votes to look at the demand for a new feature request to impact feature prioritization.  This is one of the many avenues for requests and feedback coming into our lists for prioritization.

    I've added you name to the request to add your voice to the support for this request.

    Cheers,

    Scott.

  • 2
    Avatar
    Dominic Yerex

    I actually requested this feature on the old feature request platform too, so this issue has been "seen" for more than 2 years.

    This is incredibly basic charting functionality. My reports completely break when new series pop up (new payment methods, new products) because every series has to be hard-coded in Klipfolio.

    This product fills a great niche, but the lack of basic charting functionality is becoming untenable for us. We don't need more connectors, we need better charting.

     

     

  • 0
    Avatar
    One Digital Admin

    Hi, Any news about this feature?

    Tks

    Talita

  • 0
    Avatar
    Scott Lawrence

    Hi Talita,

    This is not scheduled at the moment.  I will add your name to the feature request.

    Cheers,

    Scott.

  • 2
    Avatar
    Michael Niño

    +1

  • 0
    Avatar
    Cameron Monks

    Any update on this one?

  • 0
    Avatar
    Louis-Joseph L'Écuyer

    This would definitely help a lot for all the tables and charts!  Hopefully this feature will come soon.

     

    Thanks

  • 1
    Avatar
    Edwin Lung

    Wow, it took 2 years and still no update on this. What an incredible support.

     

     

  • 0
    Avatar
    Mnubo Admin

    I would need this feature as well. We often need to change the order of groupbys in the result. It would be nice to be able to pivot to see the results from a different perspective (ie. change the groupby order). ...similar to Excel pivot function.

     

  • 0
    Avatar
    Sara Hollis

    Also flagging a +++++1 for this feature. Currently not having this is blocking a lot of functionality for our program monitoring. Would appreciate any updates on the feature, or any other hacks out there that exist!

  • 0
    Avatar
    Sara Hollis

    Also flagging a +++++1 for this feature. Currently not having this is blocking a lot of functionality for our program monitoring. Would appreciate any updates on the feature, or any other hacks out there that exist!

  • 0
    Avatar
    Dennis Paul

    +1

  • 0
    Avatar
    Bee Eye

    +1

     

Please sign in to leave a comment.