Target Values to be changed dynamically upon selection parameters in PPS Dashboard Designer
-
24/جمادى الثانية/1433 05:12 ص
Can anyone please guide me how to change the Target values dynamically based on the selection parameters used in the Time filters?
I have designed a KPI scorecard in which i have given some target values but those are numbers and may correspond to a specific time period like if i have specified 50 as the target value then it may be a target value for a month but what if the user selected multiple months from the filter? then this value should be multiplied by 2. I have no idea where to write the formula so that the data displayed in the scorecard is accurate as per selection parameters.
Please help!
Regards,
Yasmeen Arshad
جميع الردود
-
25/جمادى الثانية/1433 02:07 م
Hello Yasmeen
Change som measures dynamically is OLAP "feature" where you have calculated measures with some aggregation and if you change data mappings from fixed value to to another data source (OLAP) you should dynamically display based on aggregation from OLAP. i m afraid that directly in dashboard designer you are not able to create this type o calculation with target define as fixed value.
Tomas
-
26/جمادى الثانية/1433 04:20 ص
Thanks for your reply Tomas.
You mean like other conventional dashboards we cannot change the target values dynamically? Other applications support this feature. am i right?
whats the use of formulating dashboards using dashboard designer then?
- تم التحرير بواسطة Yasmeen Arshad 26/جمادى الثانية/1433 04:28 ص