Adding Median line to Bar Chart

[Kiran Kethineni]

Hi,

I am trying to add Median line to my bar chart and wondering if there is an in built feature to add it.

Thanks

Kiran

[David Beagan]

There does not seem to be a built-in feature to add a median line to a chart.

A chart can have a reference line based on a value. You would need some WebFOCUS code to calculate the median value and store it in an amper variable. Then you could use the amper varaiable to specify the reference line's value on the chart.

[Patrick Huebgen]

@Kiran Kethineni​  Not built in feature but easy - just create a new computed field in Designer, Info Assist or Code like this and add it to the chart as line

PARTITION_AGGR( YOUR_MEASURE_HERE , TABLE , B , E , MEDIAN)

 

More details here

https://docs.tibco.com/pub/wf-wf/9.2.2/doc/pdf/IBI_wf-wf_9.2.2_functions.pdf?id=14

[David Beagan]

Yes, that's a better approach than what I was suggesting.

[Kiran Kethineni]

Thanks Patrick.

[Patrick Huebgen]

@Kiran Kethineni​  You're welcome