Hi Everyone,
I am trying to compare viewers for first day of the month and Last day of month . Here in this below report, I am entering dates manually every time while running a report to compare viewer results. I want to avoid typing /choosing the dates every time to generate results, report has to take automatically or dynamically dates ( choosing First date of month and last date of month) and compare the results . In this way, I will schedule my report . Please help me out, how could I modify below report to schedule my report PS : "Viewers_Today" field has calendar days
index=* Client="HelloPunter" AND "Viewers_Today"="2019-04-30" OR Viewers_Today="2019-04-01" | stats values(Total_PCs) AS "Total PCs", values(Total_iPADs) AS "Total iPADs" values(Total_MACs) AS "Total MACs" by Viewers_Today | transpose header_field=Viewers_Today | rename column AS Category, 2019-04-01 AS "First_Day_Month", 2019-04-30 AS "Last_Day_Month"
Thank you,
Punter
... View more