Hi all, i created a report, now i need to create a dashboard that takes data from this report with loadjob savedsearch. the report has as the name of the fields 1_month_previous, 2_month_previous, ...
See more...
Hi all, i created a report, now i need to create a dashboard that takes data from this report with loadjob savedsearch. the report has as the name of the fields 1_month_previous, 2_month_previous, ......(I could not rename the names of the months in the command stats sum (DIM) as 1_month_previous, I also followed a post here in the community) I would like to create a filter in the dashboard with the names of the months instead of the previous_month. I tried with this code: <query> | makeresults | eval MPR0 = strftime (relative_time (now (), "-0month @ month"), "% B") | eval MPR1 = strftime (relative_time (now (), "-1month @ month"), "% B") | eval MPR2 = strftime (relative_time (now (), "-2month @ month"), "% B") | eval MPR3 = strftime (relative_time (now (), "-3month @ month"), "% B") | eval MPR4 = strftime (relative_time (now (), "-4month @ month"), "% B") | eval MPR5 = strftime (relative_time (now (), "-5month @ month"), "% B") | eval MPR6 = strftime (relative_time (now (), "-6month @ month"), "% B") | eval MPR7 = strftime (relative_time (now (), "-7month @ month"), "% B") | eval MPR8 = strftime (relative_time (now (), "-8month @ month"), "% B") | eval MPR9 = strftime (relative_time (now (), "-9month @ month"), "% B") | eval MPR10 = strftime (relative_time (now (), "-10month @ month"), "% B") | eval MPR11 = strftime (relative_time (now (), "-11month @ month"), "% B") | eval MONTH = mvappend (MPR0, MPR1, MPR2, MPR3, MPR4, MPR5, MPR6, MPR7, MPR8, MPR9, MPR10, MPR11) | table MONTH </query> but in Dinamic Option -> Search String by inserting this code, it returns me the names of the months separated by commas, all on a single row and not in a column to let me choose the month I need. Do you have any suggestions? I have tried mv append, split, delim, etc .. to no avail. I ask for help from you Splunk gurus. Tks BR Antonio