Hi is it possible to run dashboard hourly so it wont take a lot of time when opening the dashboard? Thanks ... View more

Hi I have a dashboard with 8-10 reports, and we have in our organization a limit of 5 searches per user. I want to see few reports before the others. Is it possible to priorities the reports and start searching one report before the other? Thanks ... View more

I have that field "numberOfDays" that I have created that returns values of number of days in float type (0.345, 1.435 ...). I would like to sum the results grouped by number(just like the excel example). In the following code it returns the count of occurrences. The code I am using: index=snow assignment_group_name=*israel* dv_state="Clos*" priority=2 | dedup number | eval month = substr(substr(sys_updated_on,6,7),1,2) | eval year = substr(substr(sys_updated_on,3,4),1,2) | eval timeField = year+"."+month | rex field=dv_u_total_time_spent "(?<DAYS>\d+)\s*Day" | rex field=dv_u_total_time_spent "(?<HOURS>\d+)\s*Hour" | rex field=dv_u_total_time_spent "(?<MINS>\d+)\s*Minute" | eval DAYS = if((isnull(DAYS)), 0, tonumber(DAYS)) | eval HOURS = if((isnull(HOURS)), 0, tonumber(HOURS)) | eval MINS = if((isnull(MINS)), 0, tonumber(MINS)) | eval numberOfDays = round(DAYS) + round(HOURS/8,3) + round(MINS/480,3) | replace OTHER with 0 in numberOfDays | table number sys_updated_on month year timeField DAYS HOURS MINS numberOfDays | chart sum(eval(numberOfDays<2)) as "0-1" sum(eval(numberOfDays>1 AND numberOfDays<6)) as "2-5" sum(eval(numberOfDays>5 AND numberOfDays<11)) as "6-10" sum(eval(numberOfDays>10)) as "11+" over timeField by numberOfDays Result graph: Also, the result graph shows extra data in the legend. and I need it to be like the excel. What am I doing wrong? Thank you ... View more

I have that field that shows time in a string. the values of the field are something like: Is there a way to extract the number of hours for each one? for example if I have value of 2 days I will get 16 hours (8 hours a day), and if I have 30 minutes value, I will get 0.5 hours. Thank you ... View more

Hi, I have a problem I cant find the solution to. I want to display 2 bar from each "by" field. for example: my report shows 1 bar for each month: I need my reports to look a bit different: for each month, I need to devide the columns by another field(dv_state), that has 7 possible values and I want to use only 2 (Ope*, Clos*). The code I am using: index=snow assignment_group_name=*israel* (dv_state="Clos*" OR dv_state="Ope*") (priority=2 OR priority=4) | dedup number | eval month = substr(substr(sys_updated_on,6,7),1,2) | eval year = substr(substr(sys_updated_on,3,4),1,2) | eval timeField = month+"."+year | replace 2 with "High" 4 with "Normal" in priority | chart count over "timeField" by priority By the way, if there is a better way to show the month/year, I would love to hear, because if the 12/16 month added, it is added to the right (the end), and it is not sorted by time. Thank you! ... View more

I have two graphs (I put example and their search code) and I want to display them on a single graph. Is there a way to create that kind of graph? 1 | inputcsv MPSMilstonesCSV | dedup Report_Milestone | eval Report_Milestone1 = if((substr(Report_Milestone, 1, 1) == "S"), substr(Report_Milestone, (len(Report_Milestone)-6), len(Report_Milestone)), Report_Milestone) | fieldformat TaskDeadline = strftime(TaskDeadline, "%d/%m/%Y") | streamstats count as milestoneNumber | eval legend = milestoneNumber+" = "+Report_Milestone1 | table TaskDeadline Report_Milestone1 milestoneNumber legend | chart sum(milestoneNumber) over TaskDeadline by legend 2 index=clearquest ("Project Name"=ipa_4*) ("Task Type"="Enhancement A*" OR "Task Type"=Defe* OR "Task Type"=Doc*) "Resolution"=* ("Severity"=*) "Task ID"=* | dedup "Task ID" | reverse | timechart span=1w dc("Task ID") AS sum_of_tasks_per_week by Severity | accum "S0-Critical" | accum "S1-High Impact" | accum "S2-Medium Impact" | accum "S3-Low Impact" | accum "S4-Unknown" | accum "No Value" Thank you ... View more