Avg vertical line for aggregated bar chart

[Austin Fox]

Spotfire X

In a bar chart with y-axis = UniqueCount([y-valuecolumn]) and x-axis = AutoBinNumeric([x-valuecolumn],n) how do you get an average vertical line that uses the aggregation Using 'Lines &Curves' adding a straight vertical line 'AVG([X])' does not account for the aggregation (UniqueCount) and instead operated on the whole dataset i.e. RowCount().

[Fabian Duerr]

I tried... Don't see a chance to get this work for AutoBin

 

If you had fixed bins then you could work with a calculated column and plot this column. Or, more advanced, if you create a document property for n you could use this property for your x-axis and calculated column.

[Austin Fox]

For others reference. I ended up creating a pivot table from my main data table. This allows there to be no aggregation in the bar chart making the values correct.