In some advanced Data Visualization products, once you've created your views, you can filter out what is shown by selecting one of the channels and assigning filtering on that Channel. So suppose, I Chart A and B vs. C. I can then tell the chart to only show me data points where A is between 5 and 10. OR, even better, some allow you to show only A data points where D is between two values. OR, even better, if E is a category like "fruit" I can ask it to show me only the values of A that correspond with fruit channel E being "orange".
Excel accomplishes this by using the Autofilter on your data. Of course, it becomes global for all the charts that refer to that data at that moment in time, but at least it can be done quite simply.
The only two acceptable ways known to do this in Diadem are both tedious to set up and laborous to repeat.
1) Write what is probably a complex script to import the data in the first place. Every time parameters for the filtering change, the data must be re-imported. UGH!
2) Write a script to copy the data from main group to a sub group and the script performs the filter. Again, every time parameters for the filtering change, re-run the script. Nevermind the enormous coding time to create a flexible enough script.
I realize the end-user is probably different, but Tableau does an excellent job with visualization, and does this feature seamlessly.
