http://forums.visokio.com/discussions/tagged/intersection/feed.rss Mon, 30 Oct 17 17:30:57 -0400 Tagged with intersection - Visokio Forums en-CA http://forums.visokio.com/discussion/2078/idea-filtering-show-only-named-query-subset-valuess Tue, 02 Apr 2013 07:09:23 -0400 Alexander 2078@/discussions
Also the auto-complete filtering suggests values that are not valid for that tab as these values are not part of the selected subsets and queries applied on the views of the tab.

I would like to set up the dashboards such that the Sidebar filter devices are based only on the intersection of all named queries applied to views on the tab. Is there a setting that I missed or is this not possible (yet)?]]> http://forums.visokio.com/discussion/1849/formula-performance-and-usability-improvements-2.8- Mon, 22 Oct 2012 08:34:49 -0400 steve 1849@/discussions INTERSECTION performance

From tonight's build of 2.8, the INTERSECTION, UNION and INVERSE functions now perform as well as the older SUBSET functions and can be used instead in all cases.

So, for example, rather than use the somewhat convoluted:

SUBSET3(field1, field2, field3, value1, value2, value3,
operator1, operator2, operator3)

you can now use the much simpler format:

INTERSECTION(
SUBSET(field1, value1, operator1),
SUBSET(field2, value2, operator2),
SUBSET(field3, value3, operator3)
)

as well as using more complex logic such as:

UNION(
INVERSE(SUBSET(...)),
INTERSECTION(
SUBSET(...), SUBSET(...), ROWINDEXSUBSET(...)
)
)


Formula editing

Additionally, the formula editor now has improved UI performance and is easier to read, with contextual highlighting of relevant parts of a formula immediately surrounding the cursor position, allowing you to visualise the formula structure better.

Simplify and Reformat

Two new buttons have been added to the formula editor:

"Simplify" converts complex SUBSET2 to SUBSET5 variants into INTERSECTION-based formulae. In future it may also change use of other legacy functions into their recommended alternatives.

"Reformat" reformats all whitespace in your formula for readability.

Neither of these commands will affect the formula result, but "Simplify" may yield better performance in future.
]]>