General

Ability to Colour Tokenised data

daniel — Thu, 24 Nov 2011 12:18:40 -0500

]]>

Location Totals

davedunckley — Thu, 24 Nov 2011 06:11:48 -0500

I have a questions. I would like to use the Content View to create a totals page that can intract with the devices.

But I would also like to to be split per region.

So that I could show totals for each region, and then from the sliders select clients. So I will be able to see how much money that client has made per region.

Any ideas how I can do this?

Thanks

Dave
]]>

1st quantity label invisibility

nester — Wed, 16 Nov 2011 09:07:10 -0500

the 1st quantity label is sometimes not visible. Can you help me how to fix it?]]>

Online viewer error

Ftor — Fri, 18 Nov 2011 10:27:11 -0500

We have send the .iok to our cliente, and they couldn´t launch the omniscope online viewer, the error message said "Unable to launch the application", they told us that IT team installed Java 6.0 but is till appearing the same message.

Could you help us
Kind regards]]>

Scheduler: Suppress/ignore error messages?

edtclarke — Thu, 17 Nov 2011 08:41:15 -0500

C:\Program Files (x86)\Visokio Omniscope\OmniscopeEnterprise.exe -executeAction "C:\SSIS\Omniscope\0.Input\WWSA_Cat12.xml"

For a folder full of xml source data files. The problem I have is that if one of the xml files causes Omniscope to error the job will not continue until I manually 'Ok' the error message.

Is there a way to suppress or ignore any error messages - I have a validation process checking at the end of the job whether all the files have been built. Thanks -Ed]]>

Outputs: Export to pre-formatted Excel?

Jasper — Fri, 11 Mar 2011 05:00:37 -0500

]]>

Subtracting the Date/Time fields

rajeshbalu29 — Wed, 16 Nov 2011 05:49:28 -0500

=if(Create_date - Start_date < 24hrs,"Yes",NULL)
Can anyone help me on getting the formula for this one please. Thanks in advance ]]>

Excel export in viewer

Maty — Tue, 15 Nov 2011 09:24:14 -0500

Is there a way to export data to Excel with the viewer? ]]>

Batch Append Refresh from free Viewer

Maty — Tue, 15 Nov 2011 09:40:13 -0500

Subset functions - average bus hours

rajeshbalu29 — Thu, 10 Nov 2011 05:18:05 -0500

=RECORDCOUNT(SUBSET2([Month],[Type],[Month]))
but I am unable to find a function for totalling the bus hours for the whole month. Can anyone help me on finding a formula for getting the sum of bus hours per month?]]>

Hide "(no value)" in device Sidebar?

Alk — Tue, 26 Apr 2011 05:44:10 -0400

How do I go about hiding the "(no value)" text only in the device Sidebar? I am currently using Omniscope 2.6 b609 (alpha).]]>

Changing values: Add formulae fields or use Search/Replace?

elitem — Mon, 19 Sep 2011 12:15:46 -0400

For example, I have a table of people's details i.e. names, address etc. Some of them have an email address in the email field, and for some the email field is null. I want to create a new field which will be called "Has Email?" and will be updated with either "yes" or "no" depending on whether or not the email field for that record has something in it or is null.

Can you help? Thanks Elite]]>

Changing values: Search/Replace blank with the left field before

nitiwan — Sat, 22 Oct 2011 03:00:01 -0400

What formula I should put in the box "Replace with"? Thank you]]>

YTD Calculation

rajeshbalu29 — Tue, 01 Nov 2011 05:49:27 -0400

Can any one help me on the same.
Eg: =IF(Field (Start_date) >= "1/1/2011"),"Yes",NULL)]]>

Scripting with JavaScript

steve — Tue, 26 Jul 2011 04:00:08 -0400

- from JavaScript in a formula, the ability to access arbitrary cells and metadata in the data, and the ability to execute nested formulas

- in DataManager, a JavaScript operation block, which provides access to the input datasets and their cells & metadata, and create an arbitrary output dataset. ]]>

Tab Text Colours

kmatrix999 — Thu, 20 Oct 2011 11:11:00 -0400

I'm using latest version of 2.7.

I want to show some individual tab text headings in different colours. I go to Style- Application Style- Edit White- Tab Colour Text and then select Red from the colour palette. Having an "Apply to ALL Tabs" button below implies that the change should only affect a single tab, but my red selection has already been applied to ALL tabs.

How do I ensure that the text colour change only applies to a single tab?]]>

Table Column edit function on tool bar

kenhbradshaw — Mon, 31 Oct 2011 15:52:30 -0400

Version 2.7: Query Device enhancements

steve — Wed, 28 Sep 2011 08:06:02 -0400

You might use these settings to create tabs which appear to be exclusively showing different subsets of the data. Or you might use these settings to create drill-down hierarchies of choices in filters.

Some of these settings are available per-device, depending on the type of device. You can find these by right-clicking the device name. Others are available from the device panel toolbar, under the Tools menu (spanner icon next to "Devices").

Enable dynamic devices

Enables the calculation of the effect of other devices on each device, used to show preview counts and to determine the effect of "Show values excluded by other devices". If disabled, most of the options below will be unavailable.

For complex data files with many fields, it may take a second or two after changing filters for these calculations to complete. The application will remain responsive during this period, but a tiny spinning clock will be shown in the device toolbar to indicate that preview counts, etc., are being updated.

Available from the device panel toolbar.
Show "(no value)"

If unticked, the "(no value)" option, if present, will be hidden. Has no effect on the way filtering is applied.

Available for category list and number/date slider devices. Can also be set globally from the device panel toolbar.
Show values excluded by other devices

If unticked, only choices which have an impact on remaining data will be shown. So if all records with value "X" have already been excluded by another filter, you won't see "X" in this device.

Example use: you have "Country" and "State" devices. The Country device might have 20 options, and the State device might have 30 options for every country. Use this setting on the State device to limit available choices to those relevant to the selected countries.

Available for category list and number/date slider devices. Also available for yes/no options (individually) and the named-query device. Can also be set globally from the device panel toolbar.
Show frozen devices

If unticked, all frozen query devices will be hidden. If actively filtering, they will continue to filter "silently".

Example use: you are creating a tab that simulates the effect of loading only a subset of data into Omniscope. You use a query device to filter down to the simulated data, you freeze it to exclude it from resets, and you hide it using this option.

Example use: see below. Available from the device panel toolbar.
Rebase main barometer for frozen devices

If ticked, the barometer in the main toolbar will "rebase" to simulate the effect of deleting all records excluded by frozen devices.

Example use: you are creating a tab that simulates the effect of loading only a subset of data into Omniscope. Use a query device to filter down to the simulated data, freeze it to exclude it from resets, hide it using "Show frozen devices", and use this option to rebase the main barometer.

Available from the device panel toolbar, and from right-clicking the barometer.
Show empty devices

This new option is unticked by default and demonstrates a new behaviour typically needed when some of the above options are used. If all options in a device are removed due to "Show values excluded by other devices" and/or "Show (no value)", the device itself will disappear from the sidebar.

Available from the device panel toolbar.
Sort values by frequency

This old option has now been enhanced to dynamically reorder options according to their frequency in the filtered data. When ticked, you will observe checkboxes reorder as you play with other devices. Also now extended to other device types.

Useful to highlight the more populated values in your current filtering context, which will appear at the top of the device.

Available for category list devices and the yes/no and named-query devices. Can also be set globally from the device panel toolbar.
Restrict to single value

Allows you to change a list of checkboxes into a list of radio buttons. Radio buttons only permit one choice to be selected at one time. This means that the device cannot be reset, and is always filtering. The user can choose any available single value.

Useful if you want to prevent the user from ever seeing more than one set of data at once - where, for example, this might sum data in a way that would be incorrect.

Available for category list devices only.
Show total

This allows you to choose whether to show the total number of records in the main barometer or not. For example, this is shown as "/100" as in: "83 [barometer] 17 / 100".

Available from right-clicking the barometer.

]]>

Displaying My Data on Internal Web via a web link

ddemarco — Mon, 24 Oct 2011 10:43:34 -0400

Layout: Floating scrollbars (2.7)

steve — Mon, 24 Oct 2011 05:36:16 -0400

They no longer take up any space on-screen and instead "float" where needed. This removes visual clutter from the display, since they only appear when you move your mouse over the relevant area.

You can go back to "classic scrollbars" via Settings > Advanced > Miscellaneous]]>

Pie chart splits now restricted

Wayne — Mon, 24 Oct 2011 06:38:06 -0400

Security: Domain locking from Desktop?

Kiddo29 — Thu, 20 Oct 2011 09:40:37 -0400

Quick one. I wanted to domain lock an iok file but in version 2.6 i cant seem to find an option for it. On your website it says for 2.5 go to save as and tic the box which says domain lock but there isn't one in 2.6.

Could you direct me to where this option is in 2.6 please?

Thanks]]>

Master data management & versioning

davedunckley — Tue, 18 Oct 2011 11:08:41 -0400

How do you guys deal with versoning? We have many teams per deivision that deal with analysis. I have created each an IOK file so that I can ensure they are all working from the same data. Howerver if two people from the same division open the same IOK file at the same time, one of them is going to lose charts or work they have done analysing the data. Any one got any ideas?

Thanks, Dave
]]>

Percent Change

hgross — Wed, 12 Oct 2011 21:03:11 -0400

Is there an easy way to calculate percent change month to month? If I'm aggregating by date in column 1 (histogram monthly) and I have a value in column 2 as the monthly total, how can I easily get the third column to show the percent increase or decrease over the past month?

Any suggestions would be appreciated!

Thanks!]]>

Hiding fields in Data Explorer tabs

davedunckley — Tue, 11 Oct 2011 05:16:45 -0400

Thanks, Dave
]]>

Y axis customisation on graph view

Kiddo29 — Fri, 07 Oct 2011 05:52:20 -0400

I have multiple graph views on one tab and want to customise what data can be seen when you choose a Y axis.
I did this without any problems but then when i went to another graph view in the same tab the changes i had made were carried over to it. Is there a way of showing certain sets of data in one graph view when choosing a Y axis and then having different sets of data visible when choosing a Y axis in another graph view within the same tab?

Really annoying if this isn't possible - let me know if you need further info.

Thanks]]>

Visokio Free Viewer

Paramjit — Mon, 10 Oct 2011 10:31:58 -0400

If you are aware can you please let me know how I can get Visokio Free Viewer.

Please note I just want to install Visokio Free Viewer and don't want any trial versions of Visokio.

]]>

Omniscope free viewer - only online?

shannon_toh — Tue, 07 Jun 2011 06:43:58 -0400

Dates in Omniscope

benjamin — Wed, 05 Oct 2011 04:46:16 -0400

Week Formatting

hgross — Fri, 30 Sep 2011 17:04:45 -0400

It is only working for certain rows and I'm not too sure why. Any suggestions?

[Pic attached]]]>