Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
- About Prathyusha891
Prathyusha891
Explorer
Member since:
01-19-2023
03-02-2023
Community Statistics
| Posts | 9 |
| Solutions | 0 |
| Karma Given | 1 |
| Karma Received | 0 |
| Member Since | 01-19-2023 |
Activity Feed
- Tagged How can I show the comparison between dates? on Dashboards & Visualizations. 03-01-2023 10:55 PM
- Tagged How can I show the comparison between dates? on Dashboards & Visualizations. 03-01-2023 10:55 PM
- Posted How can I show the comparison between dates? on Dashboards & Visualizations. 03-01-2023 10:53 PM
- Tagged How can I show the comparison between dates? on Dashboards & Visualizations. 03-01-2023 10:53 PM
- Karma Re: Compare products sold today vs last week same day for bowesmana. 02-07-2023 12:09 AM
- Posted Re: Compare products sold today vs last week same day on Splunk Search. 02-06-2023 11:59 PM
- Posted Re: Compare products sold today vs last week same day on Splunk Search. 02-06-2023 10:40 PM
- Tagged How to compare products sold today vs last week same day? on Splunk Search. 02-06-2023 09:28 PM
- Tagged How to compare products sold today vs last week same day? on Splunk Search. 02-06-2023 09:28 PM
- Posted How to compare products sold today vs last week same day? on Splunk Search. 02-06-2023 09:07 PM
- Tagged How to compare products sold today vs last week same day? on Splunk Search. 02-06-2023 09:07 PM
- Posted Re: Need help with count of count using Timechart on Reporting. 01-20-2023 01:38 AM
- Posted Re: Need help with count of count using Timechart on Reporting. 01-20-2023 01:35 AM
- Posted Re: Need help with count of count using Timechart on Reporting. 01-20-2023 01:21 AM
- Posted Re: Need help with count of count using Timechart on Reporting. 01-20-2023 12:46 AM
- Tagged Need help with count of count using Timechart on Reporting. 01-19-2023 11:28 PM
- Tagged Need help with count of count using Timechart on Reporting. 01-19-2023 11:28 PM
- Tagged Need help with count of count using Timechart on Reporting. 01-19-2023 11:28 PM
- Tagged Need help with count of count using Timechart on Reporting. 01-19-2023 11:28 PM
- Posted Need help with count of count using Timechart on Reporting. 01-19-2023 11:22 PM
Topics I've Started
| Subject | Karma | Author | Latest Post |
|---|---|---|---|
| 0 | |||
| 0 | |||
| 0 |
03-01-2023
10:53 PM
earliest=-0@d latest=now) OR (earliest=-7d@d latest=-6d@d) -- This is giving me the comparison of Today vs -7 days. Instead, Dynamically I need to choose the date (whatever I want) and other should automatically show the -7d. Could someone please help with this.
... View more
Labels
- Labels:
-
dashboard
02-06-2023
11:59 PM
Modified as "(earliest=-0@d latest=now)" and able to get the solution. Thankyou.
... View more
02-06-2023
10:40 PM
Hi @bowesmana Thanks for the help. But I see count is not matching for the last week same day using the below query though its totally working fine for today's count. Could you please help. index=sold (earliest=-d@d latest=now) OR (earliest=-7d@d latest=-6d@d)
| eval Today=if(_time>=relative_time(now(), "@d"), 1, null())
| stats count(eval(if(isnull(Today), 1, null()))) as LastWeek count(eval(if(isnotnull(Today), 1, null()))) as Today by Product
... View more
02-06-2023
09:07 PM
Today : index=sold Product=Acer , Product=iphone last week : index=sold Product=Samsung , Product=iphone Query Used : index=sold earliest=-0d@d latest=now |stats count as Today by Product | appendcols [search index=sold earliest=-7d@d latest=-6d@d |stats count as Lastweeksameday by Product] --- As Samsung Product is not sold on "Today" that particular Product is not showing up in the Output though it was sold on "Last week". Ideally it should show as 0 for "Today" and as 1 for "Last week" in the output. Could someone please help.
... View more
01-20-2023
01:38 AM
Thanks @ITWhisperer , @gcusello
... View more
01-20-2023
01:35 AM
Sure Thanks. But I don't think stats and Timechart work together.
... View more
01-20-2023
01:21 AM
Sorry. Let me rephrase it for better understanding _time sku count 01-04-23 123 1 01-04-23 234 1 01-04-23 987 1 01-04-23 789 3 01-04-24 678 1 O/P I'm looking for - _time count 01-04-23 6 01-04-24 1
... View more
01-20-2023
12:46 AM
Its giving us the distinct count of sku but not the total count
... View more
01-19-2023
11:22 PM
Event 1: Product=shirt1 sku=123 sku=234 Event 2: Product=shirt2 sku=987 sku=789 index= store | rex field=_raw max_match=0 "sku\W(?P<sku>.*?)\," |stats count by _time, sku o/p: _time sku count 01-04-23 123 1 01-04-23 234 1 01-04-23 987 1 01-04-23 789 1 Output I’m looking for _time count 01-04-23 4
... View more
Labels
- Labels:
-
other
