General

Default Lats and Longs with Yahoo! Disconnected

Wayne — Thu, 29 Sep 2011 13:23:09 -0400

I've recently run an update on one of my IOKs and it appears that the lats and longs default reference to Yahoo! has been broken. The default is reporting back a 503 error. Screenshot attached. Cloudmade is functioning fine, for now.

Removal of 'no value' from Devices

TomW — Mon, 08 Aug 2011 11:26:11 -0400

Hi team,

Is there a way of removing the 'no value' option from devices whereby there is no value attributed within the data?

Many Thanks

Tom

Multiple Databases

OmarKhan — Wed, 03 Aug 2011 11:21:47 -0400

One development that I would've loved is the ability to have multiple databases running at once. Currently you can only have one database loaded into omniscope, it would be great to have multiple omniscope databases that you could plug into different parts of the dashboard. This would remove the requirement to do tricky work arounds with aggregators and whatnot.

Refreshing Images in Tile View

cedricb — Tue, 20 Sep 2011 12:47:24 -0400

We have brand logo images stored on a folder on our extranet and I want the tile view to show these logos. I have uploaded new images to this folder but the tile view doesn't refresh with the new logos. I have tried clicking 'refresh image sizes' many times and have saved and closed the file many times but it refuses to show the new images.
If I save the images on my local c drive and point the omniscope to that it works fine but we need it to work from the central online folder otherwise clients won't be able to see them. Is the fact that it is beind a security wall a problem?
Is there anything else I can try? It used to work fine.

Containers

davedunckley — Wed, 21 Sep 2011 05:27:24 -0400

Hi Guys,

A quick question. In data Explorer, I have noticed it puts all YES/NO feilds into one container. This is really handy as it keeps all my options toggether. is it possible to create my own. So I could have one called Weights and Messuares for exapmle?

Substitute empty cells with the value"0"

Maty — Wed, 21 Sep 2011 08:58:13 -0400

My goal is to substitute empty cell with a “0” value. I’ve found the way, however I think that it could work much easier if this function was integrated within operations block. A “delete empty data” block already exists, I could imagine substitute "0" for "nulls" command somewhere there.

Layout: Reordering file tabs

kmatrix999 — Fri, 16 Sep 2011 10:20:12 -0400

I'm working with files that include 100's of tabbed views. I want to be able to change the order of groups of tabs for different clients. Clearly I can drag individual tabs into a new position in the file, but this takes time. Is there a way to group tabs for moving them, or is there some way of moving tabs (like fields) using hand grabs.

Error in Time Fields

Wayne — Mon, 12 Sep 2011 06:03:22 -0400

After having installed b771, all of my date fields set to show as unique values now also exhibit extraneous strings. A field programmed to show "MMM yy" is now showing "ww MMM dd hh:mm:ss GMT yyyy". The only way to be rid of these extraneous string is to show field as Historgram, something that is not acceptable to our client. Please advise on remedy. Thank you.

Time formatting Error

TomW — Mon, 12 Sep 2011 10:32:57 -0400

Hi,

I am currently trying to use the time format option within a Field Organiser with the format Hmm. However, I am using a 24 hour format at this is only picking up on any time prior to 10.00 or if it is 10.00 or 20.00 hours then it is converting to 1.00 and 2.00. When I use the HHmm format, it reads on everything above 10.00 but not below and I am missing a lot of times because of this.

How am I able to get a format that allows me to have all of my cells filled correctly so I can have the correctly formatted dates for time series analysis?

Thanks

Batch Output: Excel document with formatting applied

adam_varney — Wed, 07 Sep 2011 11:07:42 -0400

I have been trying to output some data based over several different markets, where each market requires a separate excel file that has conditional formatting applied as a template.

Is it possible to batch output the file and filter it per market to the template excel file and then have it save as a different name so in the end i have a file for each market that has been filtered accordingly and the excel file has the conditional formatting in it?

I hope this makes sense and if any further clarification is required i can provide this.

Data manager 2.6

davy — Wed, 07 Sep 2011 03:15:17 -0400

Hi there,

My colleague has data manager (2.6 beta b745) and she's found that some data she has merged from another file doesn't correctly transfer across. More specifically she's noticed that zeros are dropped off (eg $206.15 shows as $26.15).

Does anyone else experiencing this problem?

Is this issue specific only to data manager licence or does it impact on someone like myself with professional licence (2.6 Okavango)?

Cheers

Y-axis scale references

davidluria — Fri, 26 Aug 2011 13:16:31 -0400

Is it possible to add y-axis scale references to a bar view, similar to the attached pic?

Bar Chart - measurement, value naming

dartymarty — Thu, 25 Aug 2011 14:07:38 -0400

When selecting a value in the bar graph. Is there a way to remove the type of value from appearing next to the field name in the bar chart?
For instance, if I were charting the sum of Clicks per website on the bar graph on the graph it will appear "Clicks (sum)". I would like the option to remove the word "(sum)" from the viewer.

Filter Like Excel

OmarKhan — Fri, 19 Aug 2011 06:09:35 -0400

Could I dynamically change cell value? I managed to achieve a situation where I have a weight for each and every record in the de-pivoted data table. The weights were calculated so that they add to 521 (number of respondents in our data source). I managed to create a dummy column in which I sum the number of respondents (I get 521) and then I divide each weight per 521 (to make my weights sum to 100). The problem starts when i would like to filter out a part of data for example female or male respondents. What I get in the chart is a percentage of all respondents who answered this questions and are male or female. What I would like to get is a pecentage of male or female who answered this question. Is it possible to dynamically change the sum of weights I would like to divide it for?

For example: If I would like to see only Male's answer to question Q2 I need to sum the weights of all male respondents (lets call it X) and divide the sum of weights of male respondents who answered this question per X (not per 512 cause I filtered out all the female respondents and my overall number of respondents is less now), so that I get the right percentage. Is it doable at all?

I enclose the screen shots of sample calculation in Excel and Omniscope and the Omniscope file I created.
In total, the weights in Excel and Omniscope are the same: After filtering I get different results due to the fact that in Omniscope I cant divide the weights by only the filtered sum of weights whereas it is really easy in Excel.

Linking Views

davidluria — Wed, 17 Aug 2011 06:19:52 -0400

How do you specify the master/slave relationship between views?

Bar - Pane View sizing

neilmerchant — Wed, 17 Aug 2011 05:12:27 -0400

Hi
I am sure this has been asked before but I cannot find the answer to it.

I have a Bar chart and I have a pane up the Y axis to pane the data by Primary/Secondary Country and then by country. What I am finding is that I can have 3 countries in primary and 10 in secondary. However the primary part of the pane still takes up half the screen meaning there is a huge white gap below the last country before the first country in secondary starts.

How can I get this to space equally on country rather than on primary/secondary?

Thanks
Neil

Manage Fields - Duplicate fields (2.7+)

steve — Mon, 15 Aug 2011 04:50:29 -0400

...and everywhere else you can convert field types, rename fields, etc.

This has been implemented.

Fix Fields

OmarKhan — Mon, 08 Aug 2011 11:39:41 -0400

Saw this field recently , Can you please tell me what is this used for. An example would be very helpful for knowledge sharing purpose.

Omniscope 2.7 Alpha now available for private testing

steve — Mon, 08 Aug 2011 08:25:53 -0400

We have split the Omniscope 2.6 pipeline into two, freezing existing robust functionality in 2.6 (DataManager, for example) and continuing ongoing development in 2.7 (dual axis charts).

This allows us to stabilise 2.6 in a short and guaranteed time-frame, without affecting the availability to alpha partners of new feature development now in 2.7.

2.6 has already become "Beta" and will transition to "Release Candidate" and then "Stable" by end September. It now has only non-experimental functionality included. To continue using experimental and in-development features, you must upgrade to 2.7 Alpha.

The alpha partner download page for 2.7 is at http://www.visokio.com/gala

Please be aware that all experimental and in-development features in 2.7 Alpha are subject to change and may not work correctly. Files created with these features may not retain their configuration in future versions.

DataManager: API feeds and SQL servers

shamong — Tue, 02 Aug 2011 23:12:49 -0400

Hi,...was wondering. For all the API Connector feeds that are provided by DataManager, is it possible to get all these fields appended into one SQL Server folder stored locally?

Meaning to say, the data is extracted from the feeds and linked to the SQL Server stored locally for some minor processing to be done straight from the server?

Thanks!

Scheduler: Copy tasks?

Mees — Mon, 01 Aug 2011 07:25:32 -0400

Is it possible to copy a task in Scheduler. I have repetative chain actions wich are all the same in terms of actions but differ on a parameter value entered manually in the action. If we can copy and reuse all the actions, we only have to adjust the parameter value. Saves a lot of manual actions and time for us and is less sensitive to wrong entries.

Date/Time: Formulae for measuring staff performance?

Kefsid — Thu, 07 Jul 2011 14:26:36 -0400

Hi - We have a ticketing system in our company and i am suppossed to measure the staffs performance with 2.6 Omniscope.

In attached document there is a sample you can see..

Question is What the avarage waiting time for each part is (client, staff, partner)?

Is there any way to measure them in Omniscope? In this example there is only 2 unique tickets with several replies but in my database there is a few hundred thousands of unique tickets with tons of replies!! And i must find a way to show the performance of our staff and our partners...

Kefsid

FTP Task

Jon — Mon, 18 Jul 2011 06:36:18 -0400

Hi

I know this might have been covered in the past but I was hoping one of you guys will maybe help me find a better way of doing it. I've got an IOK file which is just for publishing Source information to a template file and then saves it locally... now what i want to know is can I then add an FTP task or something to transfer them up to our live box?

Versions: Free trial of version 2.6?

xwang — Thu, 14 Jul 2011 14:07:10 -0400

Hi, I have tried edition 2.5 seven days ago and found it can not import different excel sheet one time. So today I downloaded edition 2.6 which may help me to solve the problem. However, it seems I can't use it for the reason I already installed 2.5. Does anybody can tell me what should I do to use trial edition of 2.6. I already uninstall 2.5. Thank you so much

Split Pie by Columns

guptaankitcse — Thu, 14 Jul 2011 02:16:07 -0400

Hi,

Is there any way I can split the pie on the basis of columns. For example, my column names are X, Y, Z etc. and the values under these columns are figures for various heads (rows). I want to show the total figures split by these columns. Is this possible? If yes, how? Any clues are appreciated.

Thanks,
Ankit

Content View Formulae Stylised Indicator

benjamin — Tue, 21 Jun 2011 07:01:56 -0400

Hi

I am in contents view and have constructed a specific table with defined formulaes in each cell.

I am trying to do a red /amber /green colouring scheme to highlight numbers when they are greater than a specified level.

When i go to stylised text , then custom rules and add my own custom rules i have a few problems :

1.By default the formula in edit for which i apply this styled text rule to always is converted into text even if i leave it as a number.I have to delete the added "Text" operator in the edit formula when this is automatically added by default.How do i stop this ?
2.When i put a custom rule in styled text it works well initially when clicking off of Content view to view result .But then when i click back on content view and the formulae it says there is a error ( i.e a + operator was expected ..)
3.To overcome this i have edited the content view in html code and found a way around this (using < tdclass,... )

=30,"#ffdd00","#b1ffac")}}>

which colours the whole cell in the table (which is the preferred option instead of just colouring the text).However when i convert back to formulae mode in the content view the formatting of the table is not maintained and cells are added and deleted .If i leave the content view in html mode it work fine.Why is this, this should not occur ?
4.As a idea , could you add a coloured cell operator under the display value along with fixing the styled text function.

Other problems/Request :

1.In field operator in data manager could i have a search box added at the top much like what is availiable in the other data manager blocks as else i have to search by eye to find coloumns i want added/deleted from omniscope in data manager.

2.In bar graph is it possible to plot two fields in one coloumn so for instance if i have a field which is expected sales and actual sales i can have one bar which shows total sales and a proportion of the bar coloured which represents expected sales

3.Change coloumn names in table view .I.e when i aggregate and apply either mean/sum/formulae result accross coloumns i would like to change the name of that coloumn for that table view only to reflect whether it is sum/mean/formulae etc .
Otherwise when presenting this information in the table it gives a misleading names for the coloumn

4.Add graphs across tabs .I.e for instance say i have a content view or bar graph which i have formatted specifically in one tab i would like to add the same graph to another tab but without having to add it individually to every tab.I would like to either drop and drag view into tabs on the rhs of the main tab.Or copy and paste into views.

5.I would like to define formulae on specified views without having to create a coloumn .(I.e similar function as to measure in power pivot ) in effect to define a formulae on teh fly (Much similar to define a coloumn then using aggregate and formulae results ..)

Any help would be much appreciated

Thanks

Ben

Visokio 2.6

Mai — Thu, 16 Jun 2011 20:38:12 -0400

Hi there,
Just got Visokio 2.6. Where can I find the option to show just top 20 in a bar graph? Such as in 2.5 version, under "Options"-> "break down" ->"fit to screen".

Thanks.

Dials

kmatrix999 — Sun, 12 Jun 2011 07:05:31 -0400

I am using 2.6 build 650. I have 200 records in a file and want to show a value for a single measure in a single record as a dial, with the upper and lower values on the dial matching the upper and lower values of the range for that measure. The device slider shows that the range is from 0 -290. The dial however, shows the range as 0- 5,071 (the sum of the values for all 200 records). I can see that sometimes this might be useful, but it is not helpful to me.

I could just force the range value, using the current edit screen, but I want to use this file as a template for 300 others for which that forced range would no longer be appropriate and I would end up having to edit each one individually.

I must be missing the best way to do this. Is there a function that I should be applying that will automtically calibrate a dial to the highest and lowest values in the range?

Pie chart total vs filtered rows conflict

Louise_Peers — Thu, 09 Jun 2011 06:46:50 -0400

Hi.
I've got a filter on a pie chart and although I have excluded all rows (correctly) I'm still getting a total. Please can you help?
Ta

Summing Unique Values

stilley — Fri, 10 Jun 2011 11:03:33 -0400

Hello I would like to be able to add my unique values together. Is there a way to do this? I have box Office numbers for different movies and I would like to be able to add them together for each studio and be able to get an average of how much was earned by each Studio.