http://forums.visokio.com/categories/power-tips/p3/feed.rss Mon, 30 Oct 17 12:57:53 -0400 Power tips en-CA http://forums.visokio.com/discussion/1002/variables-switching-measures-for-multiple-charts-on-a-single-tab Wed, 21 Sep 2011 08:43:11 -0400 AndyS 1002@/discussions I have a tab with 4 pie charts, split on categories with a single measure; I'd like the user to be able to switch the measure for all 4 charts with a single action, rather than having to switch it for each chart independently. (Ideally, I'd like this functionality on any combination of views within a tab)

The first tab of "Retail-Coffee sales" demo serves well as an example of what I'm trying to achieve - I'd like to be able to select "Sales ($)" or "Total Bags" across all four charts with a single action.

Is this possible?

Thanks,
Andy]]> http://forums.visokio.com/discussion/897/trial-version-2.5-entering-purchased-desktop-licence-keys-and-then-upgrade-to-version-2.6- Wed, 27 Jul 2011 10:28:15 -0400 SimonThomasUK 897@/discussions http://forums.visokio.com/discussion/708/dynamic-funnel-charts-in-omniscope-using-new-bar-view-features Fri, 15 Apr 2011 03:07:30 -0400 steve 708@/discussions
http://forums.visokio.com/discussion/701/funnel-charts-in-omniscope-using-content-view-with-static-image-backdrop

An alternative way of doing funnel charts in the very latest builds of Omniscope 2.6 is to use the new "Tools > Layout > Reflect in origin" option in the Bar view.

Let's say you're looking at web advertising data. The following settings would enable a dynamic funnel chart which shows a dynamically adapting visualisation, unlike the above example which only shows dynamically updating numbers on a static image.

Configuration:
- 3 measures "Impressions", "Clicks" and "Conversions" (in this sequence)
- Split by "Measures"
- "Flip" (so bars go sideways)
- "Tools > Layout > Reflect in origin" (new option, so the view is mirrored horizontally)
- "Tools > Style > Origin" (uncheck to disable the origin line)

A picture speaks a thousand words - see attachment below:]]> http://forums.visokio.com/discussion/122/multiple-data-sets-in-same-report Wed, 03 Jun 2009 10:29:18 -0400 Allan 122@/discussions http://forums.visokio.com/discussion/325/new-position-and-add-and-move-view-features Thu, 27 May 2010 17:40:21 -0400 kmatrix999 325@/discussions http://forums.visokio.com/discussion/260/how-can-i-persist-which-fields-are-exported Tue, 16 Mar 2010 15:33:19 -0400 mofleybk 260@/discussions
A workaround is to add a Table View to a tab that only contains the columns you want to persist. Selecting [ViewTools-->Export view data] will present you with an Export dialog that has preselect only the columns defined in the Table View. It even persists the order of those columns.]]> http://forums.visokio.com/discussion/19/table-view-difference-between-aggregation-and-groupings Thu, 04 Dec 2008 09:06:39 -0500 Guy_Cuthbert 19@/discussions
Aggregation allows the Omniscope to work on a reduced data set - so the chosen view (including a Table View) is displaying a different set of data - whereas Grouping is a means of hiding or revealing some of the rows in the data set. It is quite possible to use both techniques together to hide/reveal (Grouping) summarised data rows (Aggregation). The essential difference can be though of as this:

* Aggregation is a data-level summarisation technique which causes data to be summarised before it is presented to the user in one of many views
* Grouping is presentation-level Table View (only) summarisation technique which allows rows to be "rolled up" to a summary level and then expanded by the user to get back to the underlying detail in the Table

When data is aggregated, Omniscope will combine rows based on the options selected - typically this is used to create a summary level of data which can then be manipulated as if it were the base data set in Omniscope. The user selects one or more fields to aggregate by, and Omniscope generates a summarised data set where the values of the selected fields are retained, but all non-selected fields are either ignored (shown as an aggregation value of none) or summarised in some manner (e.g. sum, mean, maximum etc.).The resultant summary data set can be manipulated in Omniscope exactly as if it were the base data held in the Omniscope IOK model. For more information on Aggregation search the FAQ for additional examples.

Grouping allows the user to "roll up" rows within a Table View and then "drill down" into detail within the rows. Grouping is a presentation-level technique and, as such, alters the way in which Table View data is displayed. Once Grouping is active, on one or more fields, Omniscope places an expansion arrow next to each summarised row to allow the user to expand the rolled up row and see the individual data rows beneath (subject to the Grouping > Settings > Expandable tree options being ticked). Grouped data cannot be sorted (the underlying rows are sorted, but not the grouped totals) which can cause confusion - if you need to sort columns of summarised data then use Aggregation.]]> http://forums.visokio.com/discussion/17/how-can-i-choose-which-fields-are-shown-and-wheres Thu, 04 Dec 2008 09:04:24 -0500 Guy_Cuthbert 17@/discussions
1. The Table View allows selection and reordering of multiple fields by selecting Column Options > Columns to show from the View Tools toolbar button
2. Right-clicking a field name in the headings at the top of the Table View brings up the field options - select Tools > Hide from this view to hide the field
3. Columns can be rearranged in the Table View by dragging them left or right with the left mouse button]]> http://forums.visokio.com/discussion/21/how-can-i-tell-if-a-text-field-contains-certain-texts Thu, 04 Dec 2008 09:08:46 -0500 Guy_Cuthbert 21@/discussions
SEARCH("Smith",[Name]) will return, for the following values of the [Name] field:

1. "John Smith" = 6
2. "Terry Jones" = 0
3. "David Naysmith" = 0

To detect the "smith" in "Naysmith" you would need to use UPPER or LOWER to convert the value of [Name] to a detectable form - both of the following will return a value of 10 for example 3 above:

* SEARCH("smith",LOWER([Name]))
* SEARCH("SMITH",UPPER([Name]))]]> http://forums.visokio.com/discussion/20/why-dont-i-get-a-nice-line-graph-when-i-choose-connect-markerss Thu, 04 Dec 2008 09:07:34 -0500 Guy_Cuthbert 20@/discussions
Before you Connect Markers you need to think about the nature of your graph and how it relates to your underlying data; specifically, is your underlying data exactly what you want to graph or not? For example, if your base data represents sales of items by week in a range of stores, then when you plot a graph of Sales Value (Y) against Week (X) you need to remember that you will have many points of the graph for each week - one for every combination of store and item (subject to active filters). If you want to see a single line on the graph when you Connect Markers you first need to aggregate your data...

In this case, with sales of items by week by store, you would need to aggregate by Week to get a single Sales Value for each week, which you can then plot, Connect Markers and view a single line.

If you wanted a line per Store (reasonable if not too many stores are selected) then you would need to aggregate by Week and Store, and then select to show a line for each Store in the Connect Markers options.

If you leave the base data alone and do not aggregate (and aggregation is not possible in Omniscope releases before 2.4) then Omniscope will do what you ask, and Connect Markers... but with a marker for every store/item comination the lines that Omniscope draws between them result in a confused mess on screen.

So think through your aggregations needs first, and then Connect Markers will give you the line(s) that you require... and a little exploration of the many Connect Markers options will let you smooth, trend and colour the resultant lines.

Happy Line Graphing!]]> http://forums.visokio.com/discussion/16/why-cant-i-open-my-data-file-in-omniscopes Thu, 04 Dec 2008 09:02:41 -0500 Guy_Cuthbert 16@/discussions
Omniscope will always open Excel files from the File > Open menu, but it will expect a single header row in the first row of the worksheet from which to create names for all of the fields it creates. If the first row in your worksheet is blank, or contains data (rather than field names), then you can tell Omniscope this - simply tick the Customise data import behaviour box in the bottom right of the Open file dialogue. From the Customise data import window you can then specify the number of rows to ignore (if your worksheet contains blank rows, or comments etc.), or specify that your data doesn't contain a header row.

When opening CSV files Omniscope expects to find those files in Excel-compatible CSV format, with rows terminated by CR+LF character codes. Most softeare applications which provide CSV export facilities do prepare CSV files in this way, but if you struggle to open the file in Omniscope it is worth checking the export options in your external application to see if you can alter the settings. It is also worth noting that Omnniscope expects to find text values enclosed within quotation marks (") - it will read files in which the data is not enclosed, but any commas in the raw daat will force extra columns to be created; a common problem with some CSV export routines. If Omniscope fails to read your CSV file as you expect then it is worth trying to open the file within Excel and then saving it again (as CSV or XLS) - but watch out for Excel truncating the data if you have more than 65,000 rows (or 1,000,000 rows if using Excel 2007 onwards).

If you are struggling to open your file in Omniscope or Excel, then it is worth trying a text editor - explore search and replace options to create an Omniscope-readable verion - a favourite of mine for this task is the excellent (if rather basic) HiEditor, available free from WinAsm at www.winasm.net/hieditor-1016.html.

If you are still struggling to open your data file, then it's probably time to invoke your technical support option and contact Visokio...]]> http://forums.visokio.com/discussion/1288/import-adding-source-table-names-into-data-setss Thu, 09 Feb 2012 10:09:40 -0500 naruemon 1288@/discussions