Example 3

In the example above, you populated the Measure Values box with A, B, C, D, E, F, G. If you skip a value such as A, the transformed data will display as:

:

In the original dataset, the three rows with the A value had the dates 10/1/2015 12:00:00 AM and 10/29/2015 12:00:00 AM:

Not including the A value in the pivot still displayed the dates but did not include the A data since in Panopticon, pivoting is always with respect to time.