http://forums.visokio.com/discussions/tagged/demo_files/feed.rss Mon, 30 Oct 17 15:53:55 -0400 Tagged with demo_files - Visokio Forums en-CA http://forums.visokio.com/discussion/3033/demo-dynamic-calculation-of-investments-with-different-maturity-dates Tue, 17 Nov 2015 07:16:46 -0500 paola 3033@/discussions First step is calculation of number of days between today and the investment maturity date:
DATEDIFF(NOW, [Date], "days")  

By using NOW function, this calculation will keep the report up-to-date, always returning the latest breakdown.
It is also possible to 'fix' the date and use DATEVALUE("dd/MM/yyyy") instead of NOW, e.g. DATEDIFF(DATEVALUE("01/10/2015"), [Date], "days") .
Second step is to create irregular time intervals, that will 'bucket' the records and be used for sum calculation.

IF(
[Difference days]<1,"matured",
[Difference days]<2,"1 day",
[Difference days]<8,"1 week",
[Difference days]=<31,"1 month",
[Difference days]<92,"3 months",
[Difference days]<184,"6 months",
[Difference days]<366,"1 year",
[Difference days]<1096,"3 years",
[Difference days]<1827,"5 years",
[Difference days]<2557,"7 years",
[Difference days]=<3653,"10 years",
[Difference days]>3653,"over 10 years",
null)  

Aggregation and summing of investment amounts for each period is done in the Bar/Line view.]]> http://forums.visokio.com/discussion/2244/demo-some-geospatial-demo-files-to-share Tue, 16 Jul 2013 07:59:43 -0400 daniel 2244@/discussions
You can download them from github at:
https://github.com/ucfnlam/OmniscopeDemos?source=c

Or from my blog which has webstart links when you click on the icons:
http://spatiametrics.wordpress.com/omniscope-data-visualisations/

]]> http://forums.visokio.com/discussion/1697/new-demos-category Fri, 10 Aug 2012 06:51:31 -0400 steve 1697@/discussions
This section is publicly available, so please only post suitable datasets. Visokio reserves the right to delete inappropriate posts.

To post, please Start a New Discussion and attach your file.]]>