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.
| Implemented in | 14.6 |
Spotfire 14.6 LTS introduces Reference Elements, a new capability enriching visualizations with data-driven lines, bands/areas, boxes and markers for additional context, benchmarks, and insights. Learn more about what’s new in Spotfire 14.6 LTS…