Support

Table View: Grouping & 'Contains' function issue

JfJf — Wed, 29 Aug 2012 08:12:47 -0400

Hi - I am using the Contain formula inside a conditional to group data i.e., from a group of items I want to create a 3 groups #1 group named "Group 1" = contains the text "group1", #2 group named "Group 2" = contains the text "group2", #3 group named "Other" = everything else that doesn't have the "group1" or "group2" text.

The problem that I am having is that when I put the values in a table, and group them by the category function I've created, the 3 categories are isolated properly, but the name value that appears on the table is "Other", which is the group I've created to include everything else that is not in group 1 & 2. Instead of the 3 categories: 'Group 1', 'Group 2' and 'Others'.

Some help on this would be appreciated! Thank you, JF

Dial View: Dynamic Targets in Dials?

s_daffern — Wed, 29 Aug 2012 15:18:59 -0400

Is there any way to set a dynamic target on the dials view and ranges? Also, is it possible to add a formula to the dials value. I have tried using a formula field but I can't seem to force it to use the formula result. This is quite important when the field is an percentage and thus a sum etc. is not applicable. - Thanks

Formulae: Calculating differences by time periods (WoW, MoM)

Kefsid — Tue, 29 Nov 2011 03:35:00 -0500

Could you please help me if there is anyway to show yesterday's data, last week's same day's data, last month's same day data.. I want to compare this weeks data wth last week's data etc..

Content View: Subset functions?

Cynthia_Recchi — Mon, 27 Aug 2012 10:51:36 -0400

Hi, I was wondering whether you could help me creating this formula because it's driving me mad.

I have a file, with the following fields: Brand, Media, Period (MMM-yy) and Investment. What I am trying to do is to generate an formula (in a Content block) so It does the following: total amount of investment in Open TV in brand of the selected period ABOVE total amount of investment in Open TV of the selected period.

I want it to change according to what I select in the right sidebar. I am trying to create the formula in the Content View, but it keeps on colouring my parameters in red, as if they are wrong.

How do you suggest I should do this?

Thanks in advance for your help.

Output: Database Tables - Date/Time values (2.8+)

sunicha_sherriff — Thu, 16 Aug 2012 07:16:03 -0400

Hi - At the first,the content is as in picture "Original content" and then I would like to update it to my database using operation "Database Output" and select Publish method: Update data.

But the result is Omniscope change my content that you can see in picture "Result Content" and see at column Platts Created. It changed from "Oct 1, 2010 5:42:26 PM" to "Oct 1, 2010 12.00.00 AM". Omniscope 2.8 build 258(Alpha) *64

Best Regards - Palm

Colouring: Behaviour when changing colour styles?

WKeith — Wed, 22 Aug 2012 10:12:37 -0400

If I change the colour for a value in "Manage Fields">"Options" >"Value order,colours and shapes", then change it back to default, then change the style, the colour does not change to the default for the new style. Omniscope doesn't seem to forget that the value had been changed from default - is this expected behaviour? (This happens in 2.7 b 413).

Working Day Formula

Allan — Tue, 02 Jun 2009 16:28:09 -0400

Have two dates formatted below

dd/mm/yy hh:mm:ss

Can we have a formula that will enable us to calculate the working hours/mins (based on a 7hrs working day) between them. We must take into account that the two dates/times may span more that one day.

Subset Function: Unique combinations of two fields?

Alexander — Fri, 17 Aug 2012 07:37:57 -0400

Hi - When using the formula: SUBSET_UNIQUECOUNT([ProjectId],subset([locplaats])).

I get the following message:

Cannot use field value references. This formula is evaluated in the context of multiple records, without any specific individual record. You must identify the summary function, such as: SUBSET_SUM([locplaats]) or SUBSET_MEAN([locplaats]). If using SUBSET([locplaats]), you must specify at least 2 arguments, such as SUBSET([locplaats], "Required value").

I think this is a bug, or I am doing something completely wrong. Please advise... Thanks! (Running 2.7 b413)
Regards, Alexander

Preselection for Viewer

Mees — Thu, 26 Nov 2009 20:06:41 -0500

Hi there,

I have made a selection in my iok file and saved the file. When the user with a Viewer version of Omniscope opens the file, it opens based on my selection.
Now, the user can make additional filtering selections. However, resetting should always return to my selection and not to the complete basis of the file.
Can you let me know what the possibilities are?

Thanks, Arjan

Microsoft Office 2010

bgrovens — Tue, 14 Aug 2012 15:01:57 -0400

Hi Support,

It has been brought to my attention that we are no longer allowed to install Microsoft Office 2010 on Windows Servers at our firm. After discussions last week on the phone I was told that Visokio required PowerPoint to be installed on the server for you to automatically publish a report to PowerPoint Formatt. Please advise if anything else is effected like sourcing data from an excel sheet?

My next question is what is the feasibility of getting PowerPoint exporter packaged within the installation .exe of Visokio. Thus fixing the problem of needing the software installed on the box. This would work similar to outputting a .pdf as you don't have to have Adobe writter installed on the server to output this way.

Thanks for the help,
Brian

Conditional formatting and IF statement

William — Mon, 13 Aug 2012 08:50:00 -0400

Hi,

I am trying to recreate this (see attachment) in Omniscope. The part that I need help with is columns H, J and L. I am not sure how to go about creating it in Omniscope.

Thanks and regards,
William.

Difference Bars / Bar Comparisons

aknotts — Fri, 22 Jun 2012 06:11:44 -0400

Hi

I have a chart and I want to see the differences between the bars. I have created a difference formula that does a subset_sum for each year and basically subtracts one from the other to get my total percentage difference and I have stacked the bars so I can see the difference within the bar (see attached). The trouble is that my subset_sum only refers to the year. The user may change one of many devices but the percentage in the bar doesn't change. Is there any way of making this more dynamic? I could make my subset formula be a subset 5 so it will be affected by more of the filters but there are many more filters than 5 and some could be all on and some selected individually.

Any ideas gratefully received.

Thanks

Andy

Dynamic Subtotals

stefan — Mon, 19 Apr 2010 10:17:15 -0400

I have a simple table
Product 1, Sales = 4, FTE = 2, [calculated field] Sales/FTE = 2
Product 2, Sales = 6, FTE = 4, [calculated field] Sales/FTE = 1.5

When I select either item in the a bar view with Sales/FTE as my measure I want this value (either 2 or 1.5) to be displayed as Sales/FTE.

However, when I have both items selected, for Sales/FTE I dont want to sum, or take median, or mode etc What I want to have is 1.666 =10/6 = (4+6)/(2+4).

So I guess I want to use a subset_sum(Sales)/subset_sum(FTE) where the subset is the current filtered data. In my real data set, I have too many filters to define all subsets manually - I just want to use the current filter as selected from the devices.

Or is there an easier way that I have missed?

How should this be done?

Regards,

Stefan

Formula field in Table view

GPC — Wed, 26 Jan 2011 11:22:57 -0500

Hi guys,

I have a formula field set up to display in a Table View. It calculates the following:

Cost / subset_sum(Cost, subset(Region))

So basically it calculates a percentage of cost based on the entire cost for a region. This works fine when I only have one Region selected in the filters. But when I reset the Region filter (i.e. 5 Regions) then the percentages don't add to 100% anymore because it isn't summing for everything. If it was working it would see that it needs to sum Cost across all Regions (or more than 1 depending on how many I have selected). So I'm thinking I don't have the formula quite right.

How can I alter the formula so that it evaluates the subset of Regions to be a list (I have tried Subset_Uniqueslist, but this doesn't work in the current formula).

Thanks in advance.

gpc

Problem using Geocodelat and Geocodelon

DarrenElding — Thu, 02 Aug 2012 05:33:39 -0400

Hi, I am using the formulas Geocodelat and Geocodelon to find the X and Y coordinates of some world cities. As far as i understand the input we give to the formulas is a location field which is a text field and can be forulated such as (Postcode, City, Country) or (City, Region) for example. The problem is that there does not seem to be a way to define which fields you are using and the result is that the web based geocoding application (Yahoo) often treats my country name as the city name and I get sites located on the wrong side of the world. As an example, I have a site with the location (Rangel, Angola) where Rangel is the city and Angola is the country. The geocoder locates this to Indiana, USA as there is a city called Angola in Indiana.

Is there a way to tell it the the first field (before the comma) is the city and the second field (after the comma) is the country?

Graph View: No value as zero?

misakch — Fri, 27 Jul 2012 02:43:24 -0400

Hi,

I have a Graph View showing amount of investment in each month of the year. The problem is, that in several months there were no investment and therefore there is no value for these months. Individual points are connected by line (as shown on attached image). In month 6,7 and 10 there are no investments (no values respectively) but the line goes directly from month 5 to month 8, instead of going to zero in 6 and 7. Same situation for month 10. I have ticked "Treat (no value) coordinate as zero" but it seems it has no effect...

BTW, filling missing months with value 0 into dataset manually is not an option, because I would have to do that for each possible combination of filters.

Thanks for advice, Michal

Error message in Free Viewer

Mees — Wed, 01 Aug 2012 15:09:30 -0400

Hi guys. Our client uses Omniscope dashboards using Java webstart.
The attached error message is thrown. Hitting the OK button, does launch Omniscope, but what can we do the avoid the message?

Thanks

Styling: Conditional colouring in table?

Mees — Thu, 05 Apr 2012 15:00:21 -0400

Is it possible to colour cells in a table based on a value, i.e.:
Column A: <100 red, >100 green
Column B: blue if between 5% and 15% etc. ?

Bar/Line View: cannot get rid of the 100% label on top of the bar?

brian.lau — Thu, 21 Jun 2012 05:53:12 -0400

Hi - in 2.6 you can get rid of the 100% label on top of the bar (if we are using 100% bar) when we opt to show % values within bar. This functionality seems to have disappeared in 2.7?

Bar and line view

Maty — Mon, 16 Apr 2012 11:41:53 -0400

Hello!
I would very much appreciate your help, please find an iok file attached. I would like to combine view 1 and 2 (A or B, whichever works) with each other into one view. Also, regarding the value labels and view 1, is there a way to show just the overall sum for each bar without the sum for each stack (inside the bar).

Thanks very much, Matylda

Custom time periods: change versus previous year

Maty — Mon, 23 Jul 2012 12:07:51 -0400

Hi! Ideally, I would like to compare the value of selected time frame, with the value of the time frame from previous year in a Content View. Please see the file attached. It works for a monthly time frame, however I would like to compare Jan-April 2012 value with Jan-April 2011 and so on. The function "dateadd" does not allow me to define such units as: quarter, tertiaty or term. Can you please help me with this problem? Thanks a lot, Matylda

Connectors: DoubleClick/DFA - Delay in data update?

checkyourfuel — Thu, 29 Mar 2012 02:52:49 -0400

A media agency client in Australia is finding that he can make campaign updates in DoubleClick's ReportCentral (web UI) and immediately download the updated data (via the web UI), but the updated data is not immediately available via the Omniscope DoubleClick API connector.

From the client: "There has been instances where we have updated DFA data and it is visible when I pull a report from the DFA website but not in the Omniscope API. I know there is a delay from when you update the data within DFA, till you are able to extract it into your reports. However, there appears to be another lag till the API picks it up."

DoubleClick has confirmed the "time zone Sydney, Australia" is set in his DFA account.

Any ideas? Could the data update time spread be due to another time zone setting requirement - perhaps in the API connector? Other?

Many thanks,
James

Free Viewer: Export to Excel from free Viewer?

OmarKhan — Mon, 23 Jul 2012 06:27:18 -0400

Are there any chances of 2.8 having an option of transfer data to Excel from Viewer?

Display: New Source Database Columns Appearing on Every Tab?

chrisamott — Fri, 20 Jul 2012 07:32:05 -0400

An IOK file is connected to an Access query via ODBC. The IOK file contains many individual tabs in Table view and each tab shows only the fields that are relevant to the tab. The fields displayed in the views in each tab are different. Each time in the Access source a new column or columns are added to the query and the IOK is refreshed. Each new Access column is then added to each tab, unwarranted. Manually unticking each new field from every tab is time consuming and labourious. Is there a setting the user may choose to ensure each new column doesn't automatically get displayed in every tab?

Date/Time: Parsing incoming Text with no year?

sherriff — Fri, 20 Jul 2012 11:42:46 -0400

I know that Date/Time handling is one of the most basic operations in Omniscope and that I should be able to do it by now having worked with Omniscope for over a year. However I am having the following problem:

Reading in a .txt file with comma separators, I get a Text field with date/time formatted as follows:

Tue 19 Jun 19:33

I am trying to format this into a recognised Date/time field using the Date format (input):
EEE dd MMM HH:mm
but I see no output? What am I doing wrong?

Max memory issue

alec_webliquid — Wed, 06 Jun 2012 08:41:38 -0400

Hi,

I am trying out Omniscope on a new machine, using a trial license, and am puzzled by the maximum amount of memory it says is available (obtained by Help --> About --> Max memory). I am running 64-bit Omniscope on Windows 7 Professional 64-bit, with 16GB RAM, however the amount available is only 1936MB and the performance of the program certainly reflects this. Surely it should default to 75% * 16GB = 12GB? This is a fresh install with no config options changed. I installed for all users. I had the same issue when trying it out on a virtual machine also.

Help and/or advice would be much appreciated!

Cheers

Pie Chart Total % error

rajeshbalu29 — Fri, 20 Jul 2012 03:35:03 -0400

Hi All,
I have created some pie views where it displays the total % which cannot be removed. If I right click the option selected as never but still it displays. If I select always and select back to never it disappears but when I go to another tab and come back to this tab, it displays the total again. Please find the attached file and request you to fix this issue.

Regards
Rajesh B

Database output drop table

Mees — Thu, 16 Feb 2012 10:06:46 -0500

We are updating data in tables on an external database using the Database output in DM.
As the table is dropped and rebuilt by omniscope, all fieldsettings and indexes are changed or completely removed.
This is causing the system running on these tables, to crash completely.

We basically need a solution that just updates or adds records in an existing table without changing any structures.

Is anything like this possible?

Thanks

Bar/Line View: Ordered Dates along Bottom Axi?

schergr — Mon, 23 Jan 2012 17:44:14 -0500

I have a Bar/Line View which along the bottom (split) axis contains a series of dates (data imported from Excel in the date/time format -- 3/14/2012) the dates are not sorting in chronological order and I'm trying to figure out how to ensure that the dates are displayed chronologically.

Any thoughts?

Scheduler: workaround for MS Office applications read/write issues

antonio — Fri, 08 Jun 2012 10:11:13 -0400

This only applies if you are running the Scheduler as a Windows service.

If you have Excel sources in your DataManager workflow, and the Reader type for the file block is Excel rather than different Omniscope Reader, then you may encounter the following problem (found in the Scheduler log):

Microsoft Office error
Error communicating with Application. Please try again. Check for solutions here: http://www.visokio.com/kb/scheduler-troubleshooting style='font-size: 9pt; color: #666666'>Invoke of: Open
Source: Microsoft Excel
Description: Microsoft Excel cannot access the file 'C:\Users\Visokio\Desktop\file.xlsx'. There are several possible reasons:

• The file name or path does not exist.
• The file is being used by another program.
• The workbook you are trying to save has the same name as a currently open workbook.

Possible solution, suggested on the msdn forum, is to create the following folders:
- C:\Windows\SysWOW64\config\systemprofile\Desktop
- C:\Windows\System32\config\systemprofile\Desktop

If the above workaround does not work, then change the reader type to "Omniscope".