How to get a net total in bar charts with negative values?
Article ID: KB0082568
Updated On:
| Products | Versions |
|---|---|
| Spotfire Analyst | 7.5.x and higher |
Description
When a stacked bar chart has both positive and negative values Spotfire shows each total separately when labels are displayed. This article shows one way to get a net total.
Issue/Introduction
When a stacked bar chart has both positive and negative values Spotfire shows each total separately. This article shows one way to get a net total.
Environment
Product: TIBCO Spotfire (Desktop client / Analyst / Professional)
Version: All supported versions
OS: All supported Operating Systems
Resolution
Users can take advantage of Trellis options in Spotfire to get a net total. Use an expression similar to:
<[Division] & " - " & Integer(Sum([Value]) OVER ([Division]))>
as your Trellis custom expression, where [Division] is the column that groups your data into desired Trellis panels and [Value] is the column that comprises the bar.
<[Division] & " - " & Integer(Sum([Value]) OVER ([Division]))>
as your Trellis custom expression, where [Division] is the column that groups your data into desired Trellis panels and [Value] is the column that comprises the bar.
Additional Information
https://tibco.aha.io/ideas/ideas/SPF-I-5159
Attachments
Feedback
Yes
No
Powered by
