I am building a dashboard page, and am building a "link" connection between two charts using the javascript client side method.
For example, a pie chart contains top 10 customers and lists sales as dollars and % - a secondary bar chart contains detailed product sales for the customer that has been selected...it would seem at present my option is to pass the x-axis lable (i.e. customer name) to the second chart, as opposed to a customerid (so that the query is properly parameterized). Is there any way to load a "KEY" property in addition to the "NAME" and "VALUE" properties, so that these linked charts are more robust?
I can only imagine that there are quite a few implementations which suffer from this limitation, as in this example customer name may not be unique and using a string parm is just a lousy implementation. Can anyone assist?