Splunk Search

How to calculate distinct count for present values and 7 days ago values for a given field?

POR160893
Builder

Hi,

My initial Splunk query was:
index="ABC" sourcetype="DEF"
| stats dc(fruit) AS "Fruits" by Diet
| sort -"Fruits"

However, I need to add a new field "Fruits 7 days ago" which finds the distinct count of "fruit" by "Diet". My current query is as follows:

index="ABC" sourcetype="DEF"
| stats dc(fruit) AS "Fruits" by Diet
|append [search earliest=-1w@w latest=@w
index="ABC" sourcetype="DEF"
| stats dc(fruit) AS "Fruits 7 days ago" by Diet ]
| sort -"Fruits", "Fruits 7 days ago"


Can you please help as I should be getting 3 outputted fields: "Diet", "Fruits", "Fruits 7 days ago" BUT I am still only getting  "Diet" and "Fruits".

Can you please help?


Many thanks!


Labels (4)
0 Karma
Get Updates on the Splunk Community!

Transforming Financial Data into Fraud Intelligence

Every day, banks and financial companies handle millions of transactions, logins, and customer interactions ...

How to send events & findings from AWS to Splunk using Amazon EventBridge

Amazon EventBridge is a serverless service that uses events to connect application components together, making ...

Exciting News: The AppDynamics Community Joins Splunk!

Hello Splunkers,   I’d like to introduce myself—I’m Ryan, the former AppDynamics Community Manager, and I’m ...