I have data that looks like the following: Week               Employee        Project# 6/3/2022         A                      001 6/3/2022         A                      002 6/10/2022       A                      002 6/10/2022       B                      002 6/17/2022       A                      003 6/17/2022       B                      001 6/17/2022       B                      002 6/24/2022       B                      001 I would like to get a count of the total of the number of distinct weeks that employees appear in the data regardless of how many projects they have an entry for .  So, for the above the count should be 6 as below: 6/3/2022 > Employee A > Count=1 6/10/2022 > Employee A and B > Count=2 6/17/2022 > Employee A and B > Count=2 6/24/2022 > Employee B > Count=1 Is there some way I can use multiple fields in Distinct Count to accomplish this?   ... View more

I would like to add a column to a chart that is the difference of the two columns before it in an application where I am showing the Cost for each employee for the last 2 weeks.   Using the search: index=SampleData  | where _time>relative_time(now(),"-2w@w") | convert timeformat="%m-%d-%Y" ctime(_time) | chart sum(Cost) over Employee by _time The above produces a chart that looks like the following Employee        05-08-2022     05-15-2022 Employee1      100.00             150.00 Employee2      200.00             175.00 How can I add a column at the end that shows the difference between the two weeks? ... View more

I am looking to search in one Index for a specific field name and then use a second field from that Index to search a second Index for that value.  For example IndexA has field names Project and IRNumber / IndexB has a field named InternalRequest IRNumber in Index A and InternalRequest in IndexB are the same values I would like to search IndexA by Project and then use the associated IRNumber from IndexA to search IndexB for the InternalRequest with the same value and then table various values from IndexB associated with that InternalRequest value.  Is there some way to use a sub-search to do this? ... View more