how to plot a bar chart by grouping the values on X-axis

[#1]

Hi all

I want to plot a bar chart for the above table. I want the column "type" to be on the x-axis and the time on the y-axis.

But, i would like to group the rows which end with same name(like .php,.js,.css) in column "type".

please ask me , if I am not clear in my exlaination

Thanks

[sunny_talwar · Accepted solution]

Ganesh -

Create a new field for file extension in the script like this to make your life easier

SubField([cs-uri-query], '.', -1) as File_Extension

[#3]

Thanks very much