Below is my hidden script:
Section Access;
LOAD DISTINCT
Upper(ACCESS),
Upper(NTNAME) as NTNAME
FROM QMC;
Section Application;
Star is *;
SectionAccesstab:
LOAD Upper(NTNAME) as NTNAME,
Upper(ZONE) as %ZONE
From QMC;
The question: I have 10 charts and for 1 out of 10 charts, sales persons sud see data on all zones, for remaining charts and tabs across the dashboard, data sud be reduced zonewise. can we do it excel-free.
my approach: I am planning to control data reduction at expn level: For that one chart which sud allow data on all zone, I am not going to use, %zone in the expression of the chart. For all remaining charts, I am going to use %zone in the expn so that data is reduced according to definition. For eg. count(if(field1='13' and %zone=zone1,ID)) where zone1 is the actual fieldname in the app. this expn allows me to give respective sales person their zone-data. But the problem is for some users, when I assign " * " to give access to all data, chart is blank on front end when I use %zone=zone1 in the expn. however, the expn with %zone use is working correctly if a user is assigned a certain zone, just not for admins n users with a *.
what is your soln? cud there be a more robust approach?
