Tagged with filtering - Visokio Forums http://forums.visokio.com/discussions/tagged/filtering/p2/feed.rss Mon, 30 Oct 17 13:34:15 -0400 Tagged with filtering - Visokio Forums en-CA Layout: Floating Filter Devices (2.8+) http://forums.visokio.com/discussion/1008/layout-floating-filter-devices-2.8- Thu, 22 Sep 2011 11:26:35 -0400 alexhoward 1008@/discussions Idea: Filtering - Show only Named Query subset values? 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)?]]>
Idea: Filtering-Pareto - custom ranges? http://forums.visokio.com/discussion/665/idea-filtering-pareto-custom-rangess Thu, 24 Feb 2011 01:59:43 -0500 nevynb 665@/discussions Data Typing: Text vs Categories? http://forums.visokio.com/discussion/1981/data-typing-text-vs-categoriess Thu, 10 Jan 2013 20:54:08 -0500 shaji_o 1981@/discussions
However there a some instances where "List of categories" doesn't appear as an option under filter type. Is this because there are too many values for a check box? ]]>
Filtering: Finding whole words in text strings using only Record Filter? http://forums.visokio.com/discussion/1974/filtering-finding-whole-words-in-text-strings-using-only-record-filters Wed, 09 Jan 2013 06:14:46 -0500 aknotts 1974@/discussions
Using version 2.7 b452 (03-Dec-2012 14:47:32) r74529

Thanks, Andy
]]>
Idea: Filtering-Date filters in Calendar format? http://forums.visokio.com/discussion/1805/idea-filtering-date-filters-in-calendar-formats Tue, 02 Oct 2012 07:44:20 -0400 OmarKhan 1805@/discussions
I didnt find any such option, but maybe it would be an interesting suggestion to your developers :)
]]>
Idea: Multiple sequential filters to segment data sets? http://forums.visokio.com/discussion/1531/idea-multiple-sequential-filters-to-segment-data-setss Fri, 04 May 2012 15:06:43 -0400 earheart 1531@/discussions Filtering: (no value) - freeze? http://forums.visokio.com/discussion/1789/filtering-no-value-freezes Thu, 27 Sep 2012 06:45:40 -0400 dszl136154 1789@/discussions Idea: Overview of filters/exclusions applied by view? http://forums.visokio.com/discussion/1511/idea-overview-of-filtersexclusions-applied-by-views Mon, 30 Apr 2012 05:51:54 -0400 andy_white 1511@/discussions
Have a way in Content view of listing all exclusions/filters made in that tab?
Have a specific view that lists this (ala Portal view)?

It's often hard to know what you've done without looking at the Sidebar (and even then not easy) this is also very pertinent in printed reports etc. - Andy]]>
Idea: Sidebar/variable devices as a view or moveable? http://forums.visokio.com/discussion/1739/idea-sidebarvariable-devices-as-a-view-or-moveables Thu, 30 Aug 2012 07:36:01 -0400 s_daffern 1739@/discussions
I haven't seen a way of doing this but I thought it would be quite useful if you could add the variable inputs to a view or somewhere else on screen so that you can position them as and how you like. It may well be that you could have an input device within a view that is linked to a variable perhaps.]]>
Idea: Value set segmentation: by percentiles? http://forums.visokio.com/discussion/1649/idea-value-set-segmentation-by-percentiless Fri, 13 Jul 2012 10:52:38 -0400 acohen 1649@/discussions Thank you, Ariel]]> Filtering: Applying Sidebar filters settings to all tabs? http://forums.visokio.com/discussion/1574/filtering-applying-sidebar-filters-settings-to-all-tabss Thu, 31 May 2012 04:28:30 -0400 alexandervolk 1574@/discussions
Unfortunately, the viewer does not offer the little wrench icon which has the "apply to all tabs" option?

Is there another way to solve this? A quick reply would be greatly appreciated.

Many thanks!]]>
Record filter compare against another column http://forums.visokio.com/discussion/1524/record-filter-compare-against-another-column Thu, 03 May 2012 04:34:34 -0400 alec_webliquid 1524@/discussions
Please vote this up if you think it is a good idea!

Cheers]]>
Filter No Value in a view http://forums.visokio.com/discussion/1509/filter-no-value-in-a-view Mon, 30 Apr 2012 03:16:51 -0400 vijay_chidambaram 1509@/discussions
Since the below shown bar graph view has appended files from different sources, the no value bar gets shown. I cannot a do a common filter or create a common query for this because of the different sources. The metric selector has six different metrics and lets say few of the metrics have different sources and hence if I filter out no value for one metric, I will be filtering all the available data for another metric because as I said the the data is all appended. So, please suggest me how to hide or remove "No Value" values from the view. Thanks

image

Kind Regards
Vijay]]>
Idea: Filtering-Pareto-'Top/Bottom N' sorting/display? http://forums.visokio.com/discussion/1214/idea-filtering-pareto-topbottom-n-sortingdisplays Mon, 16 Jan 2012 05:20:01 -0500 indranildatta 1214@/discussions
I have been asked by quite a few of our clients and I think this feature would be a very powerful addition to the views in DataExplorer.

The simplest use case is as follows:

I have a Bar/Line view with measure X and split by one single field [Field1]. With this new feature, I'd be able to say, "Show only top 10 entries" and an automatic filter will be attached to that Bar/LIne view.

Building on the simplest case, we can think of further generalisations like:

1. Configurable number of entries, i.e. 'top/bottom 'N' entries', N to be chosen by user
2. Top/Bottom 'N' entries, rather than only top entries
3. Extension of the same concept over aggregated measures
4. Function support to enable the same feature through formulae

Please let me know if any of this is possible.

Cheers! Indranil]]>
Filter Options for menu in a tab http://forums.visokio.com/discussion/1189/filter-options-for-menu-in-a-tab Thu, 05 Jan 2012 20:41:24 -0500 vijay_chidambaram 1189@/discussions
When I tried to select a particular set of metrics for the graph and apply it to a particular view, it gets either gets applied to all the views in the tab or to that kind of view in all other tabs. In short, I am looking for an option where I could apply the filter settings to that particular view in that particular tab. Hope I have made the question clear. Could you please help to fix the problem that I face.

Thanks

Vijay]]>
Filtering: different data subsets in different views on the same tab? http://forums.visokio.com/discussion/1147/filtering-different-data-subsets-in-different-views-on-the-same-tabs Tue, 06 Dec 2011 12:20:39 -0500 MediaCom 1147@/discussions Exclude results from text search http://forums.visokio.com/discussion/1101/exclude-results-from-text-search Thu, 17 Nov 2011 10:35:28 -0500 Paul 1101@/discussions Version 2.7: Query Device enhancements http://forums.visokio.com/discussion/1018/version-2.7-query-device-enhancements Wed, 28 Sep 2011 08:06:02 -0400 steve 1018@/discussions
You might use these settings to create tabs which appear to be exclusively showing different subsets of the data. Or you might use these settings to create drill-down hierarchies of choices in filters.

Some of these settings are available per-device, depending on the type of device. You can find these by right-clicking the device name. Others are available from the device panel toolbar, under the Tools menu (spanner icon next to "Devices").

  • Enable dynamic devices

    Enables the calculation of the effect of other devices on each device, used to show preview counts and to determine the effect of "Show values excluded by other devices". If disabled, most of the options below will be unavailable.

    For complex data files with many fields, it may take a second or two after changing filters for these calculations to complete. The application will remain responsive during this period, but a tiny spinning clock will be shown in the device toolbar to indicate that preview counts, etc., are being updated.

    Available from the device panel toolbar.

  • Show "(no value)"

    If unticked, the "(no value)" option, if present, will be hidden. Has no effect on the way filtering is applied.

    Available for category list and number/date slider devices. Can also be set globally from the device panel toolbar.

  • Show values excluded by other devices

    If unticked, only choices which have an impact on remaining data will be shown. So if all records with value "X" have already been excluded by another filter, you won't see "X" in this device.

    Example use: you have "Country" and "State" devices. The Country device might have 20 options, and the State device might have 30 options for every country. Use this setting on the State device to limit available choices to those relevant to the selected countries.

    Available for category list and number/date slider devices. Also available for yes/no options (individually) and the named-query device. Can also be set globally from the device panel toolbar.

  • Show frozen devices

    If unticked, all frozen query devices will be hidden. If actively filtering, they will continue to filter "silently".

    Example use: you are creating a tab that simulates the effect of loading only a subset of data into Omniscope. You use a query device to filter down to the simulated data, you freeze it to exclude it from resets, and you hide it using this option.

    Example use: see below. Available from the device panel toolbar.

  • Rebase main barometer for frozen devices

    If ticked, the barometer in the main toolbar will "rebase" to simulate the effect of deleting all records excluded by frozen devices.

    Example use: you are creating a tab that simulates the effect of loading only a subset of data into Omniscope. Use a query device to filter down to the simulated data, freeze it to exclude it from resets, hide it using "Show frozen devices", and use this option to rebase the main barometer.

    Available from the device panel toolbar, and from right-clicking the barometer.

  • Show empty devices

    This new option is unticked by default and demonstrates a new behaviour typically needed when some of the above options are used. If all options in a device are removed due to "Show values excluded by other devices" and/or "Show (no value)", the device itself will disappear from the sidebar.

    Available from the device panel toolbar.

  • Sort values by frequency

    This old option has now been enhanced to dynamically reorder options according to their frequency in the filtered data. When ticked, you will observe checkboxes reorder as you play with other devices. Also now extended to other device types.

    Useful to highlight the more populated values in your current filtering context, which will appear at the top of the device.

    Available for category list devices and the yes/no and named-query devices. Can also be set globally from the device panel toolbar.

  • Restrict to single value

    Allows you to change a list of checkboxes into a list of radio buttons. Radio buttons only permit one choice to be selected at one time. This means that the device cannot be reset, and is always filtering. The user can choose any available single value.

    Useful if you want to prevent the user from ever seeing more than one set of data at once - where, for example, this might sum data in a way that would be incorrect.

    Available for category list devices only.

  • Show total

    This allows you to choose whether to show the total number of records in the main barometer or not. For example, this is shown as "/100" as in: "83 [barometer] 17 / 100".

    Available from right-clicking the barometer.

]]>
Batch Output: Excel document with formatting applied http://forums.visokio.com/discussion/976/batch-output-excel-document-with-formatting-applied Wed, 07 Sep 2011 11:07:42 -0400 adam_varney 976@/discussions
Is it possible to batch output the file and filter it per market to the template excel file and then have it save as a different name so in the end i have a file for each market that has been filtered accordingly and the excel file has the conditional formatting in it?

I hope this makes sense and if any further clarification is required i can provide this. ]]>