Loading...

RE: From many to one (EN1, EN2, EN3 to EN)

RE: From many to one (EN1, EN2, EN3 to EN)

#7145
Anonymous
Anonymous
Participant

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