Dear experts,
I defined the below mentioned pivot to generate a monthly report of the most frequently used URL paths on a web server. In the email sent by the scheduled report, I would like to show the name of the month and current year. My idea is to use the auto-extracted fields date_month and date_year as tokens in the email ( $report.date_month$ , $report.date_year$ ). It is acceptable to show these two attributes in the statistics part of the report, but not in the visualization part (a bar chart). Is there any way to make these two fields invisible in the chart?
Also other approaches to accomplish the functionality are welcome!
| pivot WebServer_KPIs Bandwith sum(bytes_out) AS "Bandwith/bytes" first(date_month) AS "Month" min(date_year) AS "Year" SPLITROW application_name AS Apps TOP 10 sum(bytes_out) ROWSUMMARY 0 COLSUMMARY 0 NUMCOLS 0 SHOWOTHER 1
Thanks and br,
Elmar
... View more