About hagar71

hagar71 · ‎05-22-2023

last 2 questions please if I want to take the values only for the newest IDs as the IDs are duplicated but with different dates how could I do this? and if I want to click on the chart to show the IDs for the red, yellow and green how could I make this? thank you so much for your support

hagar71 · ‎05-22-2023

and how could I visualize it? <option name="charting.fieldColors">{"red":"#DC4E41","yellow":"#F8BE34","green":"#5CC05C","gray":"#A9A9A9"}</option> isn't working here

hagar71 · ‎05-22-2023

the y-axis is the count if the IDs while the RED,GREEN,YELLOW are the criticality of the difference between the two dates and for the gray one it's based on another column where the value of the column is yes or no when it's no it should be gray otherwise it should check the another condition to choose RED,YELLOW or GREEN

hagar71 · ‎05-22-2023

this is my query till now based in the if condition that I want but I want to visualize them based on their colors in the query index=test | eval start=strptime(PlannedDate_1,"%d.%m.%Y %H:%M") | eval end=strptime(PlannedDate_2,"%d.%m.%Y %H:%M") | eval difference = start - end | eval red = if(difference<14 AND DateChanged="yes" ,total_time,0) | eval yellow = if(difference<20 AND difference>14 AND DateChanged="yes",difference,0) | eval green = if(difference>20 AND DateChanged="yes", difference, 0) |eval gray=if(DateChanged="no", difference, 0) | table red, yellow, green

hagar71 · ‎05-22-2023

I am working with csv file and I stopped in index=test becuse I don't know how could I create if condition in Splunk

hagar71 · ‎05-22-2023

No I didn't, how could I do that?

hagar71 · ‎05-22-2023

Hello Splunkers I want to customize the color of the bars based on condition like the example where ID, DateChanged,PlannedDate_1 and PlannedDate_2 are columns and the Date format is dd.mm.yyyy HH:mm and there is a dublication in the ID so I wanted to take the latest Dates Green --> All the ID with the DateChanged = no Red --> All the ID with the DateChanged = yes AND PlannedDate_1 and PlannedDate_2 have a gap of less than 14 days yellow --> All the ID with the DateChanged = yes AND PlannedDate_1 and PlannedDate_2 have a gap between 14-20 days Green --> All the ID with the DateChanged = yes AND PlannedDate_1 and PlannedDate_2 have a gap of more than 20 days

hagar71 · ‎02-09-2023

Hello everyone, I want to change the percentage of pie chart to be integer I am using this to show the percentage <option name="charting.chart.showPercent">1</option> and my query is index="test" sourcetype=csv | chart count by status

hagar71 · ‎02-09-2023

@bowesmana I tried | rex field=Date "week(?<week_no>\s+)" | where week_no>="week1" AND week_no<="week5" | fields - week_no but No results found the column of the weeks called Date

hagar71 · ‎02-08-2023

hello everyone, I have a column which contains week1 , week2 ,week3,week4,week5 and I want an input to the chart to show me the data from week1 to week3 for example or week2 to week5 how could I do that?

hagar71 · ‎08-05-2022

ok let me explain it to you as I don't understand your answer, I will pick a date and this date should print output to me according to comparison between the date and the field for example the start date=08/08/2022 (I put this in time picker) so it will compare this date with field planning freeze and once it finds it, the output should appear to me

hagar71 · ‎08-05-2022

I would like to create a dashboard that shows it's output when the time is picked and the values of the time is equal to two fields in the index data itself, how can I make this ?

Posts	13
Solutions	0
Karma Given	1
Karma Received	0
Member Since	‎08-05-2022

Online Status	Offline
Date Last Visited	‎05-22-2023 11:07 AM

How to achieve color bar based on condition?

How to approximate pie chart percentage?

How to change week to time format?

How to create a dashboard with date picture?

Re: color bar based on condition

Re: color bar based on condition

Re: color bar based on condition

Re: color bar based on condition

Re: color bar based on condition

Re: color bar based on condition

How to achieve color bar based on condition?

How to approximate pie chart percentage?

Re: How to change week to time format?

How to change week to time format?

Re: creating a dashboard with date pic

How to create a dashboard with date picture?