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:
<code>Date/City/Day/Response ----------------- 09-01/New York/Monday/Yes 09-05/New York/Friday/Yes 09-01/Los Angeles/Tuesday/Yes 09-07/Chicago/Monday/No 08-28/San Francisco/Wednesday/No 08-23/Dallas/Sunday/Yes </code>
How can I organize/sort these data so it reports the following for all days:
<code> City/Yes/No Chicago/0 /1 Dallas/1 /0 Los Angeles/1 /0 New York/2 /0 San Francisco/0 /1 </code>
And reports the following for Monday only:
<code> City/Yes/No Chicago/0 /1 New York/1 /0 </code>
Splunk and variables/constants 1 Answer