Show Most Common User / FileName From Each Day

[matt_crowther]

Hopefully this will be a fairly straight forward one:

I'm looking at the QVS Log files to do a little monitoring of daily Server usage and want to create the following straight table:

Simply; 'Date' as the Dimension (so 1 line per day) and then to display the most commonly opened .qvw and most active user for that day. It's fairly straight forward to display the number of times the most commonly opened .qvw was opened or the number of Sessions the most active User ran (via aggr()) but getting the actual name is proving difficult.

I've also come across several other areas where this could be of great use and I'm sure I'm not the first to need it so I hope there's a swift solution that I'm missing.

Many thanks,

Matt

[Miguel_Angel_Baeyens]

Hello Matt,

If you enable your sessions log, you will find that the resulting document has a Timestamp field and a Document field you can use for your chart and seem to be easily loadable into your model.

I'll get back with an example if I find time to develop it.

In regards to get only the name of the field something like

=Mid(Document, index(Document, '\', -1) +1, Len(Document))

should work.

Regards.