Hi All,
I am working on an enhancement of a dashboard which earlier was not working as per expectations and have taken a task to redesign for performance improvement.
The challenge I am facing in displaying a Scorecard which sources data from 700 rows and 30 columns. Here we need to filter out one column of the 28 columns and place it in single column, clubbing with the other two in order to represent in dashboard.
Source sheet looks as, where Selected KPI needs to be filled by selection of KPI.
Vend_CD Vend_NM Target KPI KPI1 KPI2 KPI3 …KPI28
V1 A One of the KPI K1V1 K2V1 K3V1 …K28V1
V2 B Target Cell K1V2 K2V2 K2V3 …K28V2
V3 C Target Cell K1V3 K2V3 K3V3 …K28V3
V700 XYZWWW Target Cell K1V700 K2V700 K3V700 …K28V700
I tried with combo box filter with dynamic behaviour passing the selected KPI on data source with column filter selection, it works perfect when I tested with small range of data, but fails to update when the row number increases to 700. I also tried with source data, but did not achieved the expected results. I gave a try with Match and Index excel functions too, failed. To add here I am trying to display 700 vendors and values of the selected KPI in Score card component.
The component does not gets updated upon selection, it loads once for first KPI which is default selection, but once KPI is selected it does not gets updated. It loads if the query of the source data is triggered, only if the prior to it KPI selection is made to reflecte the selected KPI data in target cells. This is also very uncertain.
I request the community here to think about this case and let me know your suggestion or recommendations or some ideas for it. I look forward for any trick or practice I can try with.
Thanks,
Deepak
deepak21.s 
(BOB member since 2010-09-06)
(BOB member since 2003-05-26)