Hi, I have a few columns of data and I would like to generate a pivot table that is similar to the one in Excel.
As an example:
How can I organize/sort these data so it reports the following for all days:
And reports the following for Monday only:
asked 07 Sep '10, 19:09
This is a fairly simple search, provided that you extract the fields City and Response from a set of events, where each event is one line of your data:
answered 07 Sep '10, 21:43
Stephen Sorkin ♦