Tagged with data-export - Visokio Forums http://forums.visokio.com/discussions/tagged/data-export/feed.rss Mon, 30 Oct 17 14:25:00 -0400 Tagged with data-export - Visokio Forums en-CA Pivot View: Export of Aggregated Data in Excel tables http://forums.visokio.com/discussion/3135/pivot-view-export-of-aggregated-data-in-excel-tables Mon, 06 Jun 2016 08:33:42 -0400 Phillipa 3135@/discussions We are constantly being asked by clients if it is possible to export the view data into excel tables.

I am aware that this option exists but what the clients really want is aggregated data in a format similar to a pivot table.

When I export from the pivot table to excel I get aggregated data but cannot restrict which fields are exported.
This results in unneccessary fields, which are often meaningless as they contain "no value" as there is no unique single answer due to aggregation.
This is not very intuitive for our clients.

Ideally I would like to be able to reproduce a pivot table view in an excel table.

Can anyone help me with this problem?
Thanks for any advice.
Phillipa]]>
Export: How to export in JSON format? http://forums.visokio.com/discussion/2964/export-how-to-export-in-json-formats Thu, 02 Jul 2015 06:59:53 -0400 Alexander 2964@/discussions
For one of our clients we will be exchanging JSON files. We would like to generate our own JSON files, as outputs of our dataflows.

Would be interesting if someone has already experience generating JSON files. Thanks for contacting us, via this forum topic. ]]>
Export: Remove thousands separator when outputting CSV? http://forums.visokio.com/discussion/2474/export-remove-thousands-separator-when-outputting-csvs Thu, 20 Feb 2014 11:28:21 -0500 joshlk 2474@/discussions
foo,boo,"10,000",16

When outputting CSVs from Omniscope, could there please be a option which removes the thousand separator in numbers so that quoting the numbers to enclose the separator commas within a comma de-limited file is not necessary?

Thanks]]>
Pivot View: Export pivoted data now enabled http://forums.visokio.com/discussion/2174/pivot-view-export-pivoted-data-now-enabled Thu, 30 May 2013 04:05:43 -0400 alexPIB 2174@/discussions Are there any plans to make exporting data as a pivot easier?

I seem to remember an 'export as pivot' option on a 2.7 build a while ago but now it no longer exists?]]>
Free Viewer: Export data from free Viewer? http://forums.visokio.com/discussion/1837/free-viewer-export-data-from-free-viewers Tue, 16 Oct 2012 13:31:12 -0400 kikorw 1837@/discussions
Summary: I share an .IOK file with end users with a free Viewer only license, how could they export data from the .IOK?]]>
Copy-Paste: Global "Copy selection" option? http://forums.visokio.com/discussion/935/copy-paste-global-copy-selection-options Mon, 15 Aug 2011 06:13:36 -0400 steve 935@/discussions
Probably using all fields, or fields currently configured to show in the details popup.]]>
Pivot View: How to export only a Pivot View as an Excel file? http://forums.visokio.com/discussion/797/pivot-view-how-to-export-only-a-pivot-view-as-an-excel-files Wed, 01 Jun 2011 05:27:46 -0400 Kefsid 797@/discussions