http://forums.visokio.com/discussions/tagged/dynamic_filtering/feed.rss Mon, 30 Oct 17 16:50:52 -0400 Tagged with dynamic_filtering - Visokio Forums en-CA 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?]]> http://forums.visokio.com/discussion/2700/filtering-dynamic-record-counts-on-filtered-datas Fri, 29 Aug 2014 07:34:19 -0400 dpawley 2700@/discussions
I have a large dataset of 400k records over 12 months, by supplier, by product, by outlets. What I would like to get to is "Product A is in 50% of the outlets, over 12 months. However in August it was in 80%" from the dataset.

I can separate out the data in a chart that ranks the products by volume top to bottom over the past 12 months. I have used Unique_Count to get the number of outlets that are stocking Product A which is great but I want to divide this number by the total number of outlets in the dataset and have it change if I was to select one month, or 2 months (i.e. filter).

Thanks

Danny]]> http://forums.visokio.com/discussion/2699/idea-dynamic-query-definitions-with-if-functionss Thu, 28 Aug 2014 06:14:51 -0400 daniel 2699@/discussions
Using a tab name to set a variable (this came off the idea of a different post about tab names http://forums.visokio.com/discussion/2680/idea-tab-links-accept-variables-for-resolving-tab-linkss)

IF(
Tab= "Tab_1", SetVar [VariableName] = "VariableOption1",
Tab= "Tab_2", SetVar [VariableName] = "VariableOption2"
)

OR using a variable to set filter conditions:

IF(
VariableName= "VariableOption1", set field filter [PostcodeSectorField] ="HA",
VariableName= "VariableOption2", set field filter [PostcodeSectorField] ="WC",
)

Also to use existing premade queries:

IF (
Tab= "Tab_1", Use Query state = "QueryName1",
Tab= "Tab_2", Use Query state = "QueryName2"
)



]]> http://forums.visokio.com/discussion/1176/graph-view-showing-only-top-n-categoriess Tue, 20 Dec 2011 05:45:27 -0500 TomW 1176@/discussions
Many thanks]]> http://forums.visokio.com/discussion/600/graph-view-dynamic-rankingfiltering-of-time-seriess Tue, 18 Jan 2011 18:34:20 -0500 jforero 600@/discussions
In other words, if i have a list of 25 series, I wanted to be available to choice only the first 10 series, for example, using the stat average? Is it currently this possible?]]>