conversion and formulas
I have reports with informations in colums in seconds and number of sessions, bytes, ...
I would like to know if it is possible to modify my report to :
Convert for example seconds to hours or bytes to MB
Add a column with an average per session. For example : Total bytes divide by session.
Unfortunately I don't believe this is possible within the enVision web interface. All you are manipulating with the report query is just the "Where" clause of the SQL statement. You can't use temporary variables or manipulate the data coming from the database to display differently..
That being said... if you pull the data into Event Explorer, you may be able to do some of these formulas and data manupulation by creating an Advanced Table and creating your own modified SQL query. I've just been getting into trying to use EE to extend my output options by doing this.
If you get adventurous and come up with some cool output, let us know on here! If it's useful to you, I'm sure others would find it useful as well.
You can always output the report to CSV and use excel to do your conversions or even write a PERL script to automate the process.
As Jim suggested you can use EE and if you use EE 4.03 with the external database option, I think you open up a world of opportunities to develop reports and enrich the data.
Actually, you can to the bytes/kbytes/Mbytes conversion - but not in the UI.
There is a function that will allow you to do this in the device XML. It is not directly supported by the ESI tool so you would have to enter it into the device XML manually, but you can find it in the old UDS Users Guide on page 4-36.
I'm not sure if it is readily available anymore, so I'm attaching the .pdf for it here.