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)
]]>
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.]]>
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]]>
]]>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/
]]>
> 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...
]]>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]]>
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]]>
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.]]>
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?]]>