Hi, I am currently trialing Sawmill Pro and would like to get your help on something that I would like to use Sawmill for. We have several NPS servers and I would like to create a report that has our different user groups as rows (field "NP policy names" works for that) and as columns I want "hour of day". The data (count) can be taken from any field. It should basically be a representation of how many of which group connected at what time. I used to do that with Excel pivot tables which works fine but is very labor intensive. Therefore I wanted to automate it using Sawmill but I can't get it to display as described above. Maybe my understanding of a pivot table is different than yours and I am looking for something that isn't there? But on the other hand a report showing usage broken down by time shouldn't be too far fetched. So far I tried to modify the "Hour by day" and "NP policy names" reports, but I can only add rows - not columns. Anybody got a hint for me? Thanks!
Printer-friendly copy
