0

Need help - > Bar chart

Quentin Verhaeghe

October 06, 2021 14:15

None

Follow

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 ! 

 

 

 

 

 

 

• Facebook
• Twitter
• LinkedIn

3 comments

• 0
  
  Pratyusa Ray October 06, 2021 17:11

  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
  
  Quentin Verhaeghe October 06, 2021 17:50

  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
  
  Pratyusa Ray October 07, 2021 13:22

  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