0

Need help - > Bar chart

Hi,

I need some help here :( 

I would like create a bar chart with these data

Serie 1 : Prestation 

Serie 2 : Droits

Serie 3 : Reconduction

X Asis : Mois Date

I wrote in  Data -> Serie 1 :  SELECT(#Marge;, #Catégorie; = "Prestation") and in serie 2 : SELECT(#Marge;, #Catégorie; = "Droits") ...

But i cant have the good sum. 

Maybe Select is not the good formule? 

thanks ! 

 

 

 

 

 

 

3 comments

  • 0
    Avatar
    Pratyusa Ray

    Hi Quentin,

    Thanks for the post.

    Based on what you want SELECT is the proper formula to achieve it.

    I created a sample datasource based on the example above and used the select statement for getting the Marge data for Presation category. Please see my example here.

    Can you check your X axis and check if the dates are grouped.

    Hope this helps! If you have any further questions around this, let us know by logging a ticket with our support team at support@klipfolio.com . 

    Best,

    Pratyusa Ray

     

     

     

  • 0
    Avatar
    Quentin Verhaeghe

    Hello,

    Thanks for you help ! 

    I still have the same problem because I have an amount that is not correct and there are not also all the dates :(

    Does the SELECT formula add up values like SUM?

    Thanks !

     

  • 0
    Avatar
    Pratyusa Ray

    Hi Quentin,

    Sorry to hear that you are still facing issues. 

    Can you please log a ticket with our support team at support@klipfolio.com so that we can take a closer look at your klip and help you further.

    Regards,

    Pratyusa 

Please sign in to leave a comment.