Tagged with Pareto - Visokio Forums http://forums.visokio.com/discussions/tagged/Pareto/feed.rss Mon, 30 Oct 17 15:59:48 -0400 Tagged with Pareto - Visokio Forums en-CA Filtering: Dynamic rankings in a filtered view? http://forums.visokio.com/discussion/2821/filtering-dynamic-rankings-in-a-filtered-views Wed, 21 Jan 2015 03:15:25 -0500 nash 2821@/discussions At the same time I need to calculate what is the share of the every of these three brands of all the brands which are selected.
And the last requirement is to show the difference for every brand to the year before.

So far I work it out for all brand which are in the data with formulas in the fields.
However I would need more dynamic.

Is there a way to get it are you working on it?]]>
Filtering: Re-ranking filtered data sets? http://forums.visokio.com/discussion/2707/filtering-re-ranking-filtered-data-setss Fri, 05 Sep 2014 06:16:58 -0400 abhishekdas1989 2707@/discussions
I have a medium sized data set ~2500 records. My filter is a checkbox filter (I can select any number of records, filter field is non-repeating text). The idea here is to make this filtered data a subset as I want to perform some operations on this filtered data.

The end goal is to assign a rank to each record of this randomly selected subset of data. So, if an additioal record is selected, the ranks may change based on the field value of the new record.]]>
Formulae: Filtering top 10% of subset http://forums.visokio.com/discussion/2706/formulae-filtering-top-10-of-subset Thu, 04 Sep 2014 04:14:52 -0400 abhishekdas1989 2706@/discussions
I intend to perform some basic calculations (mean) on a subset of the records in a table. I used Subset_Mean(field name, RowIndexSubset). However, it returns a null value. The RowIndexSubset is calculated properly (verified it using Subset_UniqueCount).

The main idea is to get the top 10% of the total records and then calculate the mean of the values in a specific field. This total records will change based on a filter selection (this filtering is working fine).]]>
Idea: Filtering- Pareto-'Top/Bottom N' filtering? http://forums.visokio.com/discussion/2582/idea-filtering-pareto-topbottom-n-filterings Sun, 08 Jun 2014 18:13:45 -0400 stuartjmccoll 2582@/discussions
I'd appreciate if the record filter was changed so there is a setting to grab the top ten (or N) items for each category. At present this isn't possible and you have to do four steps to replicate this.

As an example, I'm working with Google Analytics data for multiple websites (using the API connector which is very handy) and I'd like to see the top 10 landing pages for each site. Not the most exciting request, but I imagine this has applications elsewhere. Thanks]]>
Bar/Line View: Pareto/cumulative axes? http://forums.visokio.com/discussion/2164/barline-view-paretocumulative-axess Thu, 23 May 2013 06:17:01 -0400 enrico68 2164@/discussions
In the attached example:
x-axis shows agencies codes and y-axis shows the total amount managed by each agency.

Instead of showing each single agency code I'd like to see agencies as a progressive % on the total number agencies currently selected by filters (so, for example, it's possible to say that 20% of agencies have 80% of contracts).

How is it possible to obtain this?

Thanks]]>
Idea: Filtering-Pareto charts? http://forums.visokio.com/discussion/180/idea-filtering-pareto-chartss Mon, 23 Nov 2009 12:26:48 -0500 awillson 180@/discussions 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 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]]> Pivot View: Show 'Top 10' by field http://forums.visokio.com/discussion/596/pivot-view-show-top-10-by-field Mon, 17 Jan 2011 10:34:11 -0500 Focus_Media 596@/discussions
In a Pivot View (or in all views), how i can show only top 10 rows by selected measure? Example:

I have 10000 records, there are 100 differents brands, and i want to show in a same tab, one view with top 10 brands by sales, and other view with top 10 brands by units sold (it maybe differents than by sales)

Thxs in advance]]>
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]]>
Table View: Displaying only top 'N' values http://forums.visokio.com/discussion/2677/table-view-displaying-only-top-n-values Mon, 11 Aug 2014 02:55:05 -0400 tagarw 2677@/discussions I have one Table View in an Omniscope tab in which I am selecting certain rows from source DB say 100. Then I am creating certain filters on the Table View data which reduces the data to 50. And then a Sort.

After sort I want to display only top 5 records in final view of table. I am not able to find anything to do that. Can someone please help on limiting the records to 5.

Please let me know if you need more information.

Thanks. ]]>