http://forums.visokio.com/categories/ideas/p7/feed.rss Mon, 30 Oct 17 12:23:09 -0400 Ideas en-CA http://forums.visokio.com/discussion/1867/idea-dynamic-normalisation-base-index-vs-moving-index-demo Fri, 26 Oct 2012 05:27:49 -0400 davedunckley 1867@/discussions
So in the example below, I will use that start figure as 100.

So I would have a column of my data called (data) and one for the index

Data Index
100 100
50 50
25 25
11 11

But, if my start figure was say 22, the below would be displayed.

Data Index
22 100
100 454.55
50 227.27
25 113.64
11 50

In Excel, I could do it like this:-

=(C$4/B$4)*B5

Any ideas? - Dave]]> http://forums.visokio.com/discussion/1888/datamanager-custom-sql-tab-review-wthout-refreshs Fri, 09 Nov 2012 07:09:31 -0500 bfromson1 1888@/discussions http://forums.visokio.com/discussion/101/google-analytics-download-all-reports-at-onces Fri, 10 Apr 2009 13:39:58 -0400 checkyourfuel 101@/discussions http://forums.visokio.com/discussion/1881/idea-display-deriving-tab-namesview-headers-from-filter-settingss Thu, 01 Nov 2012 10:47:17 -0400 kmatrix999 1881@/discussions
Is there a way that filter selections ( i.e. Austria/Air Quality Control or Ukraine/Air Quality Control) could be linked (as an option) to a title field?

Also, on a separate issue I have noticed that when I export using screenshot, PowerPoint or PDF the spanner (top right) always (unhelpfully) appears. ]]> http://forums.visokio.com/discussion/1538/idea-connectors-creating-custom-connectorss Wed, 09 May 2012 06:18:16 -0400 naruemon 1538@/discussions
We are finding that this is causing significant bottlenecks on HDD or in the mySQL read/write process.

So we would like to know how we might develop our own custom Omniscope connector to collect the data from the remote database and read it directly into Omniscope memory or at least into Datamanager RAM.

Please advise whether and how we might modify our Java app to do this.]]> http://forums.visokio.com/discussion/1862/idea-table-view-hide-all-empty-fields-options Wed, 24 Oct 2012 05:15:02 -0400 ZhouNan 1862@/discussions
I have a data file which generates six different data sources from database, and each data source is populated in an individual tab. Because there is few overlapping column names, it ends out about 150 fields in total.
So, the problem now is that when user clicks any parts of the data in any tab and view the details, it shows all the fields including 100 or more empty and unrelated columns (as shown in the attachment) although the unrelated data sources are filtered out by Source filter.

I am wondering if there is a easy and centralized way to manage the fields shown in Details view on each tab. Or, do I have to manually hide all the unrelated columns in each graph and do the same for the other tabs which might a huge amount of zombie work.

Thank you very much!

]]> http://forums.visokio.com/discussion/1855/idea-graph-view-labelling-axis-values Tue, 23 Oct 2012 09:13:49 -0400 Mees 1855@/discussions



]]> http://forums.visokio.com/discussion/1841/idea-labelling-legend-limitations Thu, 18 Oct 2012 04:23:30 -0400 dszl136154 1841@/discussions As you can see, there are just two coloured labels, even though there is so much space it is not possible to see the full labels.
]]> http://forums.visokio.com/discussion/1608/idea-sources-detaching-data-file-from-an-exchange-based-emails Tue, 19 Jun 2012 04:54:39 -0400 Kefsid 1608@/discussions http://forums.visokio.com/discussion/1836/idea-imports-batch-append-wildcard-search-on-worksheetss Mon, 15 Oct 2012 12:22:50 -0400 kikorw 1836@/discussions http://forums.visokio.com/discussion/1798/idea-source-auditability-tracking-the-originchanges-in-fieldss Fri, 28 Sep 2012 09:42:16 -0400 davedunckley 1798@/discussions http://forums.visokio.com/discussion/1706/idea-datamanager-remove-fields-in-deduplicate-blocks Wed, 15 Aug 2012 09:22:54 -0400 Mees 1706@/discussions
Thanks - A]]> http://forums.visokio.com/discussion/1813/import-numeric-textzip-codesids-with-leading-zeros Thu, 04 Oct 2012 10:22:10 -0400 sara_llamasoft 1813@/discussions
I'm attaching a sample Excel file containing some US store locations and the associated IOK. This file contains eastern US locations and therefore some of the zip codes have leading zero, e.g. 01752. It's not appropriate to trim the leading zero(s). First, people just expect that the postal code will retain 5 digits. Without the leading zero, it just looks "funny". More importantly, the first three digits have meaning - they're geographical groupings and therefore also have meaning on their own. All 038's are in New Hampshire, etc. We sometimes build models based on the 3-digit zip, so we'd calculate this incorrectly if we lose the leading zeroes. In the IOK, you'll see my solution, which is to use the TEXTVALUE function to enforce 5 digits. Note that it doesn't matter the type in the Excel file (see the two zip code fields). Omniscope handles them identically whether Excel sees them as text or numbers.

It creates considerable additional work if I fall back on the source file input block and simply not type any fields. My issues would be solved for the zip code fields but then I'd have to re-type what would be many more fields back to their intended types.

It would be very useful to selectively type fields or have another way to say on a field-by-field basis, "I know this looks like a number, but treat it like text and don't trim or otherwise modify it".

This would also apply to order numbers or shipment numbers in other circumstances, which would also typically have a fixed-character format, so there's application beyond US postal codes.

Thanks for your consideration! - Sara
]]> http://forums.visokio.com/discussion/1805/idea-filtering-date-filters-in-calendar-formats Tue, 02 Oct 2012 07:44:20 -0400 OmarKhan 1805@/discussions
I didnt find any such option, but maybe it would be an interesting suggestion to your developers :)
]]> http://forums.visokio.com/discussion/1803/pivot-view-2-long-text-values-in-1st-column Tue, 02 Oct 2012 02:46:23 -0400 Avizua 1803@/discussions http://forums.visokio.com/discussion/1793/ideas-sources-parametric-bookmarkssource-blockss Thu, 27 Sep 2012 11:02:30 -0400 Alfonso 1793@/discussions ]]> http://forums.visokio.com/discussion/1794/idea-exportingimporting-variables-between-filess Thu, 27 Sep 2012 12:07:19 -0400 Steve_Randall 1794@/discussions Thanks, Steve]]> http://forums.visokio.com/discussion/1531/idea-multiple-sequential-filters-to-segment-data-setss Fri, 04 May 2012 15:06:43 -0400 earheart 1531@/discussions http://forums.visokio.com/discussion/1783/idea-barline-view-marker-optionss Tue, 25 Sep 2012 06:59:27 -0400 dszl136154 1783@/discussions http://forums.visokio.com/discussion/1530/outputs-splitting-one-file-into-manys Fri, 04 May 2012 15:05:21 -0400 earheart 1530@/discussions http://forums.visokio.com/discussion/1317/filtering-record-filters-using-variable-datess Thu, 16 Feb 2012 14:39:43 -0500 earheart 1317@/discussions http://forums.visokio.com/discussion/646/datamanager-parameterising-bookmarks-tabs Mon, 14 Feb 2011 08:09:55 -0500 benjamin 646@/discussions
i.e To enable bookmarks to be created then in the data block just to reference the name of the bookmark (and then the bookmark references the database)

Currently as far i am aware the only functionality of the bookmark is that you can drag the bookmark across and thus do not have to repeatedly set up frequently used databases.

The purpose is that it would enable me to change the database the bookmark references and not have to change the individual data blocks within each Omniscope if the DBs change the name/locations of the database/server.]]> http://forums.visokio.com/discussion/1781/idea-barline-view-solid-colouring-below-the-liness Mon, 24 Sep 2012 04:06:03 -0400 benjamin 1781@/discussions
Thanks - Ben
]]> http://forums.visokio.com/discussion/1779/formulae-allow-scrolling-while-formula-editor-is-opens Fri, 21 Sep 2012 09:16:25 -0400 DominicChan 1779@/discussions http://forums.visokio.com/discussion/1777/idea-table-view-units-display-formatting-of-numberss Thu, 20 Sep 2012 14:57:23 -0400 benjamin 1777@/discussions
I know there is a way around by dividing by 1000 and 1000000 retrospectively and then adding a suffix but this is a hassle.

Thanks - Ben
]]> http://forums.visokio.com/discussion/1765/sources-sas-compatibilitys Mon, 17 Sep 2012 09:51:59 -0400 amchance 1765@/discussions http://forums.visokio.com/discussion/1755/idea-scheduler-output-logs-to-email-and-log-files Mon, 10 Sep 2012 08:08:09 -0400 Keesup 1755@/discussions http://forums.visokio.com/discussion/1762/venn-view-sizing-relative-to-record-count-2-subsetss Wed, 12 Sep 2012 10:36:40 -0400 MartijnVisser 1762@/discussions http://forums.visokio.com/discussion/1307/idea-color-key-e.g.-formatting-multi-lineetc. Wed, 15 Feb 2012 13:47:23 -0500 hgross 1307@/discussions
Also, when using Data Effects: Gradients - why doesn't the color square shade along with the rest of the page?

Thanks!]]> http://forums.visokio.com/discussion/690/dial-view-showing-formula-results Fri, 25 Mar 2011 11:56:46 -0400 jrudman 690@/discussions