Need help for set analysis

[agni_gold]

Hi I am attaching the sample data

Please check I have 4 tables

Zone

Site

Pump Group

Pump

Zone is Master if i select the zone id the corresponding sites are selected in my data model and corresponding to these site Ids Pump Group and Pumps are selected.

But the problem is here when pump group and pump are selected the i have to show in my dashboard , firstly Pump group but it is possible some pumps are lie in selected pump group so i have not to show the pumps those are lie in pump group .

But those pumps which doesn't have any pump group , i have to show in dashboard.

[gidon500]

hi

can you clarify your aouput

what you want to show on excel sheet

gidon

[agni_gold]

i just want to show the sum of the ID values in text box in dashboard

[Anonymous]

Hi Agnivesh,

Data doesn't match between the Site_ID columns in  Site and Pump_Group tabs in excel sheet.

Please clarify which tab values are right.

Regards

Neetha

[agni_gold]

this data is sample data prepared by me

please check with question

thank u

[jpenuliar]

Hi,

Have a look if the image attached helpful.

[Anonymous]

Hi Agnivesh,

add  below line in script:

if((len(trim(PUMP_GROUP_ID)))<> '0',1,0)as PumpGroup

Like this:

LOAD PUMP_ID,

     SITE_ID,

     PUMP_NAME,

     PUMP_GROUP_ID,

     if((len(trim(PUMP_GROUP_ID)))<> '0',1,0)as PumpGroup

FROM

(ooxml, embedded labels, table is Pump)

and in text box:

=count({<PumpGroup = {'1'} >}PUMP_NAME)

Regards

Neetha