[Anonymous]

I have a list that has multiple offices and sub-offices; is there a way to use qChart to summarize data by the main office. For example: the following table should produce a bar chart with only 3 bars; EN with 70, DT with 22, and XN with 11.

n

Office  Employees

n

EN1           30

n

EN2           40

n

DT1           10

n

DT3           12

n

XN2             9

n

XN66           2

n

Does this make sense?

[Anonymous]

Hi,

n

 

n

I don’t think qChartView can generate your expected chart by using these data. qChartView can not recognize the EN1 and EN2 is the same data type. my suggestion is you can add an additional column(or set this field as a lookup field), and put the difference parent offices into this column, something like below:

n

 

n

Office Employees         Category

n

n

EN1           30                   EN              

n

n

EN2           40                  EN

n

n

DT1           10                   DT

n

n

DT3           12                    DT                              

n

n

XN2             9                   XN

n

n

XN66           2                   XN

n

n

[Author]

Posts