http://forums.visokio.com/discussions/tagged/subset_functions/p2/feed.rss Mon, 30 Oct 17 14:10:58 -0400 Tagged with subset_functions - Visokio Forums en-CA http://forums.visokio.com/discussion/1772/formulae-time-period-comparisons-wow-or-moms Wed, 19 Sep 2012 12:49:17 -0400 kgurus 1772@/discussions
I have two requirements and both are pretty much linked or part of the same solution:

1. I need to show a table view of metrics and their respective values corresponding to current and previous week. Also, I want to calculate the % different (WoW, MoM etc..) based on the user selections. How do I calculate previous week and show it in the data field?

2. If the user selects only quarter and does not select month or week then the current week and month should be taken as maximum of week and month in that particular quarter. Also, based on this, previous week should be calculated in the background and result should appear.

I have attached a file to explain the desired result. Any help would be greatly appreciated!

Thank you!]]> http://forums.visokio.com/discussion/1760/subset-formulae-average-of-data-subsetss Tue, 11 Sep 2012 09:32:26 -0400 Attiyyah 1760@/discussions http://forums.visokio.com/discussion/1732/content-view-subset-functionss Mon, 27 Aug 2012 10:51:36 -0400 Cynthia_Recchi 1732@/discussions
I have a file, with the following fields: Brand, Media, Period (MMM-yy) and Investment. What I am trying to do is to generate an formula (in a Content block) so It does the following: total amount of investment in Open TV in brand of the selected period ABOVE total amount of investment in Open TV of the selected period.

I want it to change according to what I select in the right sidebar. I am trying to create the formula in the Content View, but it keeps on colouring my parameters in red, as if they are wrong.

How do you suggest I should do this?

Thanks in advance for your help.]]> http://forums.visokio.com/discussion/1715/subset-function-unique-combinations-of-two-fieldss Fri, 17 Aug 2012 07:37:57 -0400 Alexander 1715@/discussions
I get the following message:

Cannot use field value references. This formula is evaluated in the context of multiple records, without any specific individual record. You must identify the summary function, such as: SUBSET_SUM([locplaats]) or SUBSET_MEAN([locplaats]). If using SUBSET([locplaats]), you must specify at least 2 arguments, such as SUBSET([locplaats], "Required value").

I think this is a bug, or I am doing something completely wrong. Please advise... Thanks! (Running 2.7 b413)
Regards, Alexander]]> http://forums.visokio.com/discussion/1673/formulae-calculating-dynamic-averages Thu, 26 Jul 2012 02:24:20 -0400 rajeshbalu29 1673@/discussions I have a function as below in a column of the table view which has 3 different columns as
1:Dept
2:Activity type
3:FTE
4:Level1
5:Level2

I need to take an average of FTE splited by activity type which I have derived by

SUBSET_SUM([Fte],SUBSET([Activity Type],"ADM"))/NUMVALUE(DATETOTEXT(TODAY,"MM)

But this values will be static for activity type for ADM there are multiple activity types for which i have done a nested IF condition but I need to get some thing where the average can be dynamically by filtering other fields in my Bar view.

For example
ADM total average is 29.50
If i filter it for Dept as "X dept" the, average should change to 15.54
If I filter it for Level1 as "Y level" then average should change to 12.24

Please let me know if there is any way I can achieve this view.

Please let me know if you need any further information

Thanks and regards - Rajesh B]]> 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. ]]>