Hi,
?Can any control in QV read data from a pivot_table chart?
I have a table loaded in from a database table. A pivot table is created for each of about 30 of the columns in that table; it's a calculation of risk assessment. Basically, it has dimensions of attribute and Date, and an expression of
if((RangeAvg (before (count(customer_id), 1, 5)) + 1.645 * RangeStdev (before (count(customer_id), 1, 5)) / 2.2360679775) < sum(count_alldays), 'TRUE', 'no')
which compares an acceptable risk limit to the count of that attribute for a particular Date. The pivot table gives me a true/false matrix for attributes and days.
The problem is, the enduser wants me to tack an extra column onto the original data table's tablebox, which will calculate how many of the 30+ attributes have TRUE values (exceed limit for that Date)
The nice Range functions only work for pivot tables, so you can't use them in table-boxes, non-pivot-charts or even as a scripted load.
But I DO have these pivot tables working, I just need to access their results. Somehow.
?How can I do that?
