19 Replies Latest reply: Feb 22, 2013 2:12 AM by Karthikeyan Subramaniam

# Bar chart challenge

Hello,

I tried to create the following graph without success,

if anyone can help me it would be nice,

I have a dimension with the values A, B, C. ..

each value belongs to a group 1,2, ...

I have one simple expression: count (x)

A

B

1  C

D

E

F

G

2  H

I

J

K

....

....

I want to show the average of A, B, C. .. group by 1.2,...

each time as shown in the second graphics

the objective is to merge the two graphs

• ###### Re: Bar chart challenge

Hi,

Hope this is what you want.

Find the attachment.

Regards,

Kaushik Solanki

• ###### Re: Bar chart challenge

Thank you for helping,

in the bar chart i want to display the "count" of the fields too, before each avg,

if you have an idea

Regards,

• ###### Re: Bar chart challenge

Hi,

You can add one more dimention called "field" in the example.

Have a look at the example.

Regards,

Kaushik Solanki

• ###### Re: Bar chart challenge

Hi,

okay, thanks

in your exemple the avg for each group is absent,

have a look at my exemple

Regards,

• ###### Re: Bar chart challenge

Hi,

Can you please provide me the qvw file with data.

Regards,

Kaushik Solanki

• ###### Re: Bar chart challenge

I'll do in a few minutes

• ###### Re: Bar chart challenge

I'm sorry but i can't provide you the qvw

• ###### Re: Bar chart challenge

Hi,

Its ok i understand,

Then please explain me in detail what you want and how you want. with an example.

Regards,

Kaushik Solanki

• ###### Re: Bar chart challenge

ok no problem,

- I have a graph that has dimension pdv_libellé (Buffalo,Courtepaille....

-  my expression is count(distinct prestation_id),
which counts the number of service

- the graph has a sort with the following expression :

Match(pdv_type_restauration_global,'Grill','A la française','Thématique','Hôtelier','FastFood','Pâtes')

which includes the point of sale by type of restoration.

I want to get the number of services per block that is done,

the problem is to introduce a bar that displays the average

here's an example :

excuse my English

Regards,

• ###### Re: Bar chart challenge

Hi,

You mean to say that you want a extra bar which shows the avg.

Regards,

Kaushik Solanki

• ###### Re: Bar chart challenge

yes , an extra bar which shows the avg,

in my example I should have 6 bars

thanks

• ###### Re: Bar chart challenge

Hi,

Its not possible to have count by pdv_libellé dimension and avg by group dimension in same barchart.

You can have different charts for that.

Regards,

Kaushik Solanki

• ###### Re: Bar chart challenge

Thank you,

that's what I did, two different charts

Regards,

• ###### Re: Bar chart challenge

You can use a pivot table and demonstrate the expression with a linear gauge

• ###### Re: Bar chart challenge

I will propose it.

thank you

• ###### Re: Bar chart challenge

I want to show values on data points of the linear chart inside pivot table. is it possible?

• ###### Re: Bar chart challenge

Try this

• ###### Re: Bar chart challenge

Hi,

thank you for helping ,

but what i want is to display the avg bars

Regards,

• ###### Re: Bar chart challenge

I want to show values on data points of the linear chart inside pivot table. is it possible?