Hoping someone can help. I'm using a where match statement in my script to limit the programmes loaded into my dashboard and it works - to a point. Whilst it does indeed limit the data to those programmes explicitly mentioned in the where match statement, it doesn't limit the 'Programme' field values displayed in the multi-box featured on the dashboard (I don't know how or where its pulling this data from). Whilst the user can select the other programmes, no data is displayed. Is there anyway to use a where match statement to limit both the data loaded in, but also the vales displayed in objects on a dashboard?
Script below:
LOAD [Student ID],
Student,
[New/Ret],
Programme,
Level,
Mode,
Stg,
Domicile,
Postcode,
[Date of Birth],
Age,
Gender,
Disability,
Ethnicity
FROM
(ooxml, embedded labels, table is [Source Data]) Where Match(Programme,'BA (Hons) Business Studies','BA (Hons) Computer Arts');
Can anyone help?
- Appreciated.
Matt
