Bar chart challenge

[djallelsadki]

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

Thanks for your help

Djallel SADKI

[kaushiknsolanki]

Hi,

    Hope this is what you want.

    Find the attachment.

Regards,

Kaushik Solanki

[djallelsadki]

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,

Djallel SADKI

[kaushiknsolanki]

Hi,

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

     Have a look at the example.

Regards,

Kaushik Solanki

[djallelsadki]

Hi,

okay, thanks

in your exemple the avg for each group is absent,

have a look at my exemple

Regards,

Djallel SADKI

[kaushiknsolanki]

Hi,

    Can you please provide me the qvw file with data.

Regards,

Kaushik Solanki

[djallelsadki]

I'll do in a few minutes

[djallelsadki]

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

[kaushiknsolanki]

Hi,

    Its ok i understand,

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

Regards,

Kaushik Solanki

[djallelsadki]

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,

Djallel SADKI