How do I reformat table values in columns to rows ...

chandra61446 · ‎08-08-2016

I have table like below

Backup_Status   BackupDate  Servers
Success       07/16/2016    archiveserver1
Failed         07/16/2016   archiveserver2
Success       07/17/2016    archiveserver3
Success       07/18/2016    archiveserver4
Failed         07/18/2016   archiveserver5

I would like to have:

BackupDate  Server1         Server2         Server3         Server4         Server5
            archiveserver1  archiveserver2  archiveserver3  archiveserver4  archiveserver5
07/16/2016  Success         Failed                                 
07/17/2016                                  Success
07/18/2016                                                  Success         Failed

sundareshr · ‎08-08-2016

Try this

... | chart values(Backup_Status) as Status over BackupDate by Servers

javiergn · ‎08-08-2016

Is this what you are looking for?

your base search
| xyseries BackupDate Servers Backup_Status

Output:

How do I reformat table values in columns to rows and rows to columns?

Re: How do I reformat table values in columns to rows and rows to columns?

Re: How do I reformat table values in columns to rows and rows to columns?