I have a document (v9sr4) where the user can review the data for a selected month (always one selected) and then review all months where the charts use set analysis to remove (only) the month selection. The charts consist of straight tables which show the total values and then line charts show how this has accumulated (there are others giving more drill down data but lets keep this simple!).
However, within the 'all months' charts the user can only select an 'item' that is part of the current selection set defined by 'month' whereas they want to be able to select any 'item'.
Take the attached example document and select month = Jul 2011. The chart shows all the items - click on items a or d in it and the 'Accumulation' subsets fine, but items b and c are not available for selection as they conflict with the 'month' selection.
To get around this I sometime create a second, unlinked "item" field (give it a different name.) Use this unlinked field for your selection box. Then use set analysis in your chart to set the "real" item field equal to the value from your unlinked (selected) field.
This can get complicated depending on the complexity of your app. Let me know if I haven't made any sense. -Isaiah
To get around this I sometime create a second, unlinked "item" field (give it a different name.) Use this unlinked field for your selection box. Then use set analysis in your chart to set the "real" item field equal to the value from your unlinked (selected) field.
This can get complicated depending on the complexity of your app. Let me know if I haven't made any sense. -Isaiah
If I understood the problem, Isaiah's solution sounds right. I typically prefer data solutions to unlinked fields, but in this case, it sounds like you're only using the selected month in a specific chart, and everything else (selections included) should ignore the selected month. In that case, that particular selection seems logically to be just a convenience for a particular chart, and not really part of the data model, so creating it as an unlinked field sounds right. Selections in the REAL month field would affect everything normally. Selections in the unlinked month field would only affect the one chart.
