Tagged with Content_view - Visokio Forums

Ranking top x items - aggregated values

bernardpi — Mon, 18 Apr 2016 11:43:53 -0400

Hi there. I have a content view where I have written Javascript to run through a list of items and aggregate on a field in order to be able to rank the items. In context, I'm running through a list of employee transactions (not-unique) and ranking them by total amount spent. This involves performing a subset sum on all employee transactions and then performing a sort and reverse to get my sorted list which I then use for downstream calculations.

This is all done using for loops which aren't quick and results in the content view taking about 7000ms on a fast machine to load and on slow machines, Omniscope times out and the execution doesn't complete so the content view is blank.

I am not sure how to use the RANK function to do this (if indeed it can) as the docs are a little confusing and there aren't many decent examples. I would like to keep the calculation in the content view if possible.

Thanks for your help in advance,

Content View: Local links to stylesheets?

aknotts — Thu, 13 Aug 2015 05:56:49 -0400

Hello,

I am having a problem pointing a Content view to a local stylesheet.

If I insert a Web view using the same HTML saved locally, the local link to the CSS stylesheet works.

However, using the Content view, the stylesheet only works if I upload it to a web server and link to that. This is not much use, as we would like clients to be able to use the Viewer offline.

In terms of stylesheets/styling, what is different as to how the Content view works, compared to the Web view?

Many thanks,

Harry

Content View: Access to CSS stylesheets from https Server v2.9?

aknotts — Mon, 17 Aug 2015 13:24:46 -0400

We are running Server Edition 2.9; and we have implemented https: for our Omniscope Web Server because it is full of IOK files with client data.

In a new IOK report file/dashboard, we want to implement external CSS stylesheets for the Content view.

Given that the Content view cannot mix access to http: and https: resources, how can we incorporate remote CSS stylesheets (which are numerous) within the domain/reach of any browser connecting to the Omniscope Web Server's hosting folder?

In other words: can an Omniscope Web Server https: hosting folder contain a CSS stylesheets folder and if so, what would the URL address be?

Content view: native browser not displaying D3 visualisation in mobile browser versions?

CRead — Tue, 14 Apr 2015 08:28:22 -0400

See attached file. 2.9b1613x64

Ideally I'd like to use the built in browser, but I can't get my D3-based JavaScript charts to show in the browser versions for mobile devices. As a result, I'm using the external browser to render the Content Views.

With the native browser I can get output to show in the classic interface by clicking on the view's toolbar and choosing 'view in native browser' from the tools menu. However, pressing F12 to create the browser version for mobile devices results in the lower right view working, but the upper right view not working.

I've cut both views down to bare bones implementations, and I'm not seeing any errors. Is there something obvious I'm missing here?

Content View: using native browser (IE on Windows) to play mp4 video

antonio — Fri, 12 Oct 2012 08:08:05 -0400

As stated on the MSDN page, Internet Explorer may need more directives to display properly some HTML5 content.

We suggest to include:
- the document type definition at the beginning of the page:

- the meta tag directive into the head tag:

For example, to use the HTML "video" tag, copy and paste the following code into your content view, being sure to enable the Native Browser option.







 

  http://www.w3schools.com/html/movie.mp4" type="video/mp4">Your browser does not support the video tag.

Idea: Saving HTML5 source code in IOK files?

Alk — Mon, 07 Mar 2011 05:38:31 -0500

Hello, currently if a user wants to run a HTML5/JS in the Web View, the user has to use a local link, eg, link to an HTML file on the computer.

It will be good if rather than a link to a local HTML file, we can embed the source code of the HTML file into the iok. Reason being, I am rolling out the iok to multiple users and I have to drop the HTML file onto each computer the IOK will run on. If I want to update the HTML file, then I need to roll out the file onto all computers again - rather long-winded and not user friendly.

If the HTML code was saved in the IOK, then I just need to update the IOK which we have a roll-out of on a frequent basis.

Content view: Inserting videos - swf and mp4 files

Miklos — Tue, 02 Aug 2011 09:04:07 -0400

Is it possible to insert not only pictures but videos (in mpeg), swf and mp3 files in Tile or in any view? If so, how?
Thanks, Miklos

Formulae: Weighted Average in Content View & stacked Bar Charts?

DominicChan — Fri, 07 Nov 2014 05:06:09 -0500

Hi, in the Content View when using "function" to display calculated figures, besides using formula, is there a way to display a Weighted Average? The Mean function there doesn't seem to offer a "weight" setting.

Also, when doing a weighted average in the Bar View, after stacking the bars, the figure displayed at the top of the bars are the sum of the stacking buckets. How can I make the figures on top of the bars to display an overall weighted average?

Thanks
Dom

Layout: Line breaks in Header?

DBuzacott — Fri, 24 Oct 2014 00:41:17 -0400

Is there a way to have a header (e.g. at the top of a Bar/Line view) split over multiple lines? At the moment, this stays as a single line even when its width is greater than the width of the view itself.

A screenshot showing a header wider than the view is attached (the header is left-aligned for readability).
FYI, I am using v2.9-beta b1435 which is the latest version of the software.

Thanks,
Daniel

Filtering: Dynamic record counts on filtered data?

dpawley — Fri, 29 Aug 2014 07:34:19 -0400

Hi

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

Content View: Using Variables for resolving tab links?

tagarw — Wed, 13 Aug 2014 01:59:06 -0400

Suppose in a report I have 5 tabs. In Tab 1 I have one Variable with 10 possible values. If I select any one of these 10 values, then I want the file should switch automatically to say, Tab 4. Can we create such links between two tabs of same report? Please confirm.

Thanks

Content View: Creating a custom view using a JS library

steve — Mon, 11 Aug 2014 08:58:55 -0400

If you have a JS library you want to use to create a custom view, here's a simple example you can copy.

Try online
Download IOK

We use the example from http://www.datatables.net/examples/data_sources/js_array.html and use server-side JS preprocessing to inject dynamic data into the data array declarations in the client-side JS. Open in Omniscope Desktop and edit the Content View source to see how this works.

Content View: Insert Multiple Subset Record Count into 1 Table?

MattBoxall — Thu, 12 Jun 2014 04:56:00 -0400

Hi Team!

I have multiple source excels plugged into Omni, I've filtered them to get the desired numbers and then saved them as 3 queries.

"Number of Plans"
"Number of New Plans"
"Number of Closed Plans"

I'm currently making a table in Content View where a cell has a function inserted that will do RECORDCOUNT(SUBSET) and return the filtered number from my query selected, which works when the query is selected via data subset selection. i.e. Subset: "Number of Plans".

I was wondering how to get all 3 query numbers into one content view via a table/3 cells as I can only insert a formula recordcount(subset) and I don't know how to reference other queries.

currently I have got 1 content view per query and it looks a bit separated.
Much thanks,
Matt

New: Chromium browser engine bundled (2.9+)

antonio — Tue, 15 Apr 2014 09:20:07 -0400

From version 2.9 b1149+ Omniscope will bundle the Chromium browser engine, a stable, modern and standards-compliant open-source browser engine which is behind the Google Chrome browser.

This major change will bring important benefits:

Users will not need a browser installed on their machine to use Web view, Content view, and Omniscope Mobile interface.
Application stability will improve as Omniscope will no longer suffer from issues caused by the old version of the installed browser (e.g. IE6).
Omniscope user experience will be boosted and improved in terms of look-and-feel, regardless the machine specifications.

Please feel free to test it and send us your feedback.

Content View: Scripting - Get the screen size?

Bart — Thu, 20 Mar 2014 07:41:15 -0400

Hi,

Is there a way to get a screen size inside Content view with native browser settings enabled? I need to use those numbers to get the right size of my pictures.

Content View: Scripting - Array of colours?

Bart — Thu, 13 Mar 2014 08:50:22 -0400

Hi,

Is there a way to get all colours assigned to the field into array inside content view?

Bart

Content View: Embedded images using "native browser"?

Bart — Mon, 03 Mar 2014 11:30:47 -0500

Hello,

The support for embedded images in the Content View "native browser" hasn't been implemented.

Can we add support for them in there please? I did workaround for now as I have posted my pictures on the web and I am

using direct link,but this solutions is not ideal as it is not going to work offline.

Bart

Layout: Dynamic Header title using date range?

herrenbruck — Mon, 03 Mar 2014 19:41:31 -0500

I understand there is a way to use dynamic headers, {{ SUBSET_SINGLETON([My Category Field]) }}, which I have used. My questions is, is there a way to use this on a filtered field of date ranges? I've uploaded an example. If I change the Fill Month/Year to Jan 2014-Jan 2014, then my header will display how I would expect it (this is how it should open). If I reset the criteria to include all data, it says no value (which I expected). Is there a way for it display "Fills Between Apr 2013 to Jan 2014" (or whatever dates I filter it too)?

Content View: Table Border behaviour?

OO83 — Mon, 17 Feb 2014 04:38:10 -0500

Hi,
I tried to insert a 3x3 table into a content view but I am not seeing the outline of the table. Any assistance will be appreciated.
I have attached a picture of what I am seeing.

Links: Images, videos, webpages in Web/Table/Content/Tile views?

Focus_Media — Mon, 18 Nov 2013 12:22:30 -0500

We have different rows each with a local link to a file, that would be a .jpg, wmf, etc.

We want show content of each file inside Omniscope (we try a Web view), but only .jpg are shown inside.
Other extensions (music & video) are opened in external application (Windows Media Player).

Is it possible show linked files (e.g. music & video files) inside Omniscope, in a Web view or other way?

Tia

Outputs: Content View disappears when exporting to PowerPoint?

Bart — Wed, 30 Oct 2013 12:53:25 -0400

I have a problem when exporting to PowerPoint in version 2.8. My views disappear from the PowerPoint. Please see in the file attached.

Scripting: Storing Data in 2-Dimensional Array?

acdewinter — Wed, 18 Sep 2013 11:00:18 -0400

Hi,

Edit: I've managed to figure out how to construct the dataTable to read data in from a for loop for 2 different array's of data and then plot it out on the scatter plot. The next step will be to link the Omniscope data into the arrays and see if it still works. Being able to do this will greatly increase the flexibility of what can be done on the front-end of the data explorer.

I've posted below the updated code that just demonstrates reading in a simple amount of data via a for-loop.:

function drawChart() {
var EventArray = [1000,1500];
var EventValueArray = [2000,2500];
var data = new google.visualization.DataTable();
data.addColumn('number','Test1');
data.addColumn('number','Test2');
for (var i=0;i<2;i++) {
data.addRows([[EventValueArray[i],EventArray[i]]]);
}
var options = {
title: 'Age vs. Weight comparison',
hAxis: {title: 'Age', minValue: 0, maxValue: 6000},
vAxis: {title: 'Weight', minValue: 0, maxValue: 6000},
legend: 'none'
};

var chart = new google.visualization.ScatterChart(document.getElementById('chart_div'));
chart.draw(data, options);
}

------------------

I will be playing around a bit more and then posting an update if I figure out where in the code to link up the Omniscope scripting calculations into the chart DataTable.

Content View: Linking to other tabs?

Milton — Thu, 11 Jul 2013 12:02:16 -0400

Require developing a hyperlink to a view of content, in order to click on that and that routes to the other tabs.

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

Idea: Layout - Automatically insert/update tab numbers?

Phillipa — Thu, 06 Jun 2013 03:58:31 -0400

Hi,

I am trying to put a tab number at the bottom of each tab of a large presentation.

I am sure there is a way to do it but can't seem to find it.......

Can someone help me?

Thanks
Phillipa

Content View: Scripting - Alert and confirm windows?

Bart — Tue, 23 Apr 2013 05:55:18 -0400

Hello guys,

I can get prompt window in Content View, why I can't get any alert or confirm windows?

Content View: Calculating weighted averages in an HTML display table

Phillipa — Wed, 06 Mar 2013 09:25:05 -0500

Hi - I am trying to build a simple HTML table in a Content View with various stats.

The problem is that I need to weight my mean values to arrive at the correct figure. Is there a simple solution?

Thanks, Phillipa

Content View: Dynamic HTML table scripting?

enrico68 — Mon, 18 Feb 2013 05:40:42 -0500

Hi - I'm writing script code for an HTML table in a Content View. I'd like to have the number of columns of the table be variable depending on the result of the following:

ncolloc=

SUBSET_UNIQUECOUNT('ABICapoGruppo',
SUBSET2('Dataregolamento','Dataregolamento',datafiltromin,datafiltromax,'>=','<='))

Which is the correct syntax to include the ncolloc variable in the following COLSPAN definition??

< td > colspan=????ncolloc??? rowspan=1> Raccolta Netta Collocatori < /td >

(I intentionally put spaces after < and > to have full definition line visible)

Thanks

Web View: Embed self-hosted video files?

Dibbhead — Thu, 06 May 2010 08:19:43 -0400

Hi there- I am creating a client presentation demonstrating advertising of competitors and I have my filter as the competitor title. I have embeded images into the file to demonstrate press and magazine ads. I have created a web link to demonstrate online video ads which are hosted on an open webpage.

However, my stumbling block is adding some video files of TV ads which I have had to download. Is there a way I can embed these video files or could you even suggest somewhere I could web host them and link back to Omniscope in the same way I have for the online video ads mentioned earlier?

Swift reply would be greatly appreciated as I need to finish the presentation tomorrow (7th May)

Thanks, Martin Dibbs

Idea: Content View - Expanded Command Link Options?

Alfonso — Fri, 25 Jan 2013 03:57:40 -0500

It would be useful to include in the list of functionalities available on Command Link (Content View) the following functionalities:

- Publish all. (To export data from the model).
- Automatic Calculi On/Off.

It helps to the final users to manage better the workflow.

Thanks in advance, Alfonso