visualization - Visualizing probability distribution Spotfire -

for every row have probability distribution on language topics. looks this:

comment | topic 1 | topic 2 | topic 3  bla bla | 0.8     | 0.1     | 0.1      bli bli | 0.2     | 0.7     | 0.1      blo blo | 0.1     | 0.2     | 0.7      

i want show average probabilities on current filter in bar plot, can zoom specific comments or combinations of comments, topic per bar. how can use different variables different bars in spotfire?

edit: here loose paint example 3 topics:

so there two, or more approaches can this. simplest to, on bar chart shows everything:

right click > create details visualization > select visualization want.

now, clicking on single or combination of bars in "main" bar chart render data in details visualization, based off data. can manage marking limit visualizations right click > properties > data tab , set marking , limit data using markings.

another, less clean approach, limit data custom expression. in properties > data tab, @ bottom see "limit data using expression" here can filter out data custom expression want. it's true power comes in when use property controls, variables. here example.

1. insert > new text area
2. right click on text area > edit text area
3. on text area tool bar > insert property control > (pick type)

then set property control want. there many options , details on different ways, properties, etc lengthy question.

now, property control works variable, can reference it. here example. in "limit data using custom expression" mentioned above, use in custom expression if([somecolumn] = "${yourpropertycontrolname}",true,fale)

---

edit

thanks comment. based on data above, you'll need add details visualization stated above, complete these steps

1. right click > properties > value axis > add 1 each column
2. avg([topic 1]), avg([topic 2]), etc
3. category axis > set (column names)

otherwise, need transform data via insert ? transformations > , need pivot / unpivot data accordingly.