De-Pivot Operation: converting rows to column for analysis?
-
Hi There...Based on my screenshot attached, I want to create then entire row into column and all the data attached to it and do my further calc based on the conversion. Is it possible within omniscope?Attachments
Capture.PNG 2K -
2 Comments
-
Nicci - There are data orientation operations in Omniscope for Pivot (change column into many rows) and De-Pivot (change many rows into column(s)).
Note that Pivot and De-Pivot operations change the orientation of data, and are not really related to Pivot View or pivot tables, which are really ways of showing aggregations.
Also note that you can combine data sets in various orientations into a single IOK file, and use Named Queries to focus visualisations on differently-oriented subsets that have been appended together.
The video showing how to use these operations to manage data orientation is here:
http://tc.visokio.com/videos/?name=DataManagerPivotDePivotTranspose&title=Pivot%2C+de-pivot+%26amp%3B+transpose&lang=gb
Welcome!
It looks like you're new here. If you want to get involved, click one of these buttons!
Categories
- All Discussions2,595
- General680
- Blog126
- Support1,177
- Ideas527
- Demos11
- Power tips72
- 3.0 preview2
Tagged
To send files privately to Visokio email support@visokio.com the files together with a brief description of the problem.