Demos

Omniscope demo: loading xml URL feed from live CCTV and mapping the images

paola — Tue, 11 Oct 2016 13:13:29 -0400

Transport for London is kindly publishing images from their CCTV cameras around town and providing an XML file feed, that can be obtained from
https://s3-eu-west-1.amazonaws.com/jamcams.tfl.gov.uk/jamcams-camera-list.xml
(you may need to register on their website first)

Data preparation:
In the DataManager space you can use the Data file source block to point it to the URL location (link above), then load directly to Omniscope for further visualisation.
Data refresh options as displayed in the image will enable automatic data refresh, responding to the changes in the data source xml.

Right-click on the field [File] header in the Table view > Options > Show image >Add more
to configure the image set, as per image below, and display thumbnails in the Table view.

Data visualisation:
Add Map view - the feed already has [Lat] and [Lng] fields, that will be recognised as input by default to position the markers.

Add a Tile view, configured to look at "selected data" and display images that correspond to markers selected on the map.
Tile contents>select the image set (already configured)

Demo: Dynamic calculation of investments with different maturity dates

paola — Tue, 17 Nov 2015 07:16:46 -0500

Simple demo attached, illustrating the use of DATEDIFF formula in the scenario where investments/deposits have different maturity date.
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.

Data animation: Climbing Everest-geospatial+time+human physiology

mamillerpa — Tue, 28 Oct 2014 08:55:33 -0400

Here's a demonstration of people climbing Mt. Everest, using made-up GPS and pulse oximetry data.

If you don't already have the Omniscope Desktop application installed on your computer, try this "custom jar" version that should work on computers with Java installed: https://www.dropbox.com/s/i298y4p64erp4q0/everest.jar?dl=0

If the custom jar doesn't work for you, you can get a free, 30 day, fully functional installer at http://www.visokio.com/download

Mark.Miller at Instem.com

Demo: Build live RSS updating News app in Omniscope

paola — Fri, 21 Feb 2014 13:59:04 -0500

Use RSS feed from a news provider, here Reuters, to place the news on the map, do text-mining, search via word cloud or filter to look at the news on a specific subject. Record cycling enabled too. See the attached file.

Demo: Some geospatial demo files to share

daniel — Tue, 16 Jul 2013 07:59:43 -0400

Just a few demos I've created and finally gotten around to organising and putting them up on github, they're all to do with spatial data.

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/

Demo: Content View - Creating Dynamic Tables

Bart — Fri, 05 Jul 2013 09:26:56 -0400

File demonstrating use of dynamic HTML/JS tables in Content View

Demo: Importing Image File Metadata & Map View

paola — Fri, 26 Apr 2013 10:45:43 -0400

Useful demo showing how to use the File Metadata Source:
> images from a mobile phone are saved in a folder
> folder is added to DataManager workspace as File Metadata source
> Omniscope reads the metadata tags on import, including longitude/latitude tags recorded by the camera
(Important: make sure that geo-location function is enabled for your mobile phone camera).
> Map view and Tile view will display photos with their location fixed on the map
> Every time new geo-coded images are dropped in the folder, Omniscope will prompt a refresh from source and add the newcomers...

Demo: Content View - Using JavaScript arrays (2.8+)

CRead — Fri, 10 Aug 2012 07:15:58 -0400

The attached file adapts some code for Javascript use.
The result is the internal rate of return (IRR).
The data is a set of consecutive annual payments.
This is the same as the IRR function in Excel, so you can test against that for verification.

Further explanation:
http://office.microsoft.com/en-us/excel-help/irr-HP005209146.aspx
http://en.wikipedia.org/wiki/Internal_rate_of_return

Source code prior to adaptation:
http://code.google.com/p/npoi/source/browse/trunk/main/SS/Formula/Functions/Irr.cs?r=227

Demo: Business Days Between Two Dates

CRead — Thu, 23 Aug 2012 07:13:10 -0400

**Edited to post an improved method, as I found in some cases the JavaScript gave odd results.**

This formula gives the same result as the NETWORKDAYS() function in Excel for all the dates I tested:

DECLARE(
ve,DECLARE(de,DATETOTEXT([End Date],'E'),IF(de='Mon',0,de='Tue',1,de='Wed',2,de='Thu',3,de='Fri',4,de='Sat',5,6)),
vs,DECLARE(ds,DATETOTEXT([Start Date],'E'),IF(ds='Mon',0,ds='Tue',1,ds='Wed',2,ds='Thu',3,ds='Fri',4,ds='Sat',5,6)),
5*INTFLOOR(DATEDIFF([Start Date],[End Date])/7) + VALUE(MID('1234555512344445123333451222234511112345001234550', 7*vs + ve + 1, 1))
)

Source of inspiration:
http://stackoverflow.com/questions/1828948/mysql-function-to-find-the-number-of-working-days-between-two-dates

====== Old version, recommended against! ========
Passing dates as dates into a script can cause odd behaviour in JavaScript. This demonstrates passing them as text, then converting in JavaScript to circumvent those issues.

The result is a calculation of the number of business days between two dates.
The script itself is a copy of:
http://partialclass.blogspot.co.uk/2011/07/calculating-working-days-between-two.html

New 'Demos' category

steve — Fri, 10 Aug 2012 06:51:31 -0400

Welcome to the Demos category/section of the Forum. You are welcome to post re-distributable demo files illustrating interesting datasets and advanced techniques.

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.

Demo: Preserve local edits when refreshing from source?

pbalfe — Fri, 05 Jul 2013 09:07:22 -0400

Apologies if this has been asked - I had a search through the Forums and could not find it.

At a high level - I have an input from a DB with some filters set up for calls for a service desk. I use the Field Organiser to add in 4 additional fileds - These will be Y/N tags for quality of certain fields in the DB. Loads into Omniscope no problem.
I then go into Omniscope and see all the data and the new fields. What I do then is get someone to look at a Table View and add a Y/N into the new columns. So far so good. I can report on them as usual.

But when I next do a refresh from the source data - naturally the information I added in Omniscope is not there and so everything is overwritten. What I want to do is find a way to 'protect' the data I add in Omniscope from not being over written... but cannot find out a setting of filter on how to do this? Any advice?