× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
SachinPrakash reported 2017-04-25T22:18:57Z  · nhilam last modified 2018-03-19T18:08:32Z

Offer a way to programmatically calculate the height of a stack bar


customer request PM
Dev
QA
Nhi Lam
nhilam
Priority Low
Complexity Unknown
Component Visual Analytics
Version Future

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. 

 

1 attachment

Issue #15190

New
 
 
Completion
No due date
No fixed build
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017