Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
hi
can you clarify your aouput
what you want to show on excel sheet
gidon
i just want to show the sum of the ID values in text box in dashboard
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
this data is sample data prepared by me
please check with question
thank u
Hi,
Have a look if the image attached helpful.
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