Offer a new calculated field function that allows one to calculate the height of a stacked bar. Here is a use case for how it could be used:
- Create a chart as shown in outliers.png. I want to filter out values that our > 1.5 times the average for the week. I can create a Calculated field as follows:
IF(SUM([Freight])) > 1.5 * WINDOW_AVG(SUM([Freight])) THEN NULL ELSE SUM([Freight])
But b/c I have a stacked bar chart, the calculated field partitions my data by the color field Card Type. Instead of SUM(Freight), I want to perform my calculation on the value of stacked bar height. VA currently doesn't offer a way to programmatically retrieve the value of the stacked bar height.
|
89 KB
Issue #15190 |
New |
Completion |
No due date |
No fixed build |
No time estimate |