Spotfire Ideas Portal
Currently it is only possible to use the values of the different points in for example a bar chart. This means that when for example the average margin per sale for different departments is plotted, a line chart based on avg([Y]) is not weighted. So for example when Department A has 3 sales with margins of 50, 75 and 100 euro, and Department B has 1 sale with a margin of 25 euro a line on avg([Y]) has a value of (75+25)/2 = 50 instead of (50+75+100+25)/4 = 62.5.
Please add an option to create a custom expression for the lines in a chart.