All Apps and Add-ons

Why does the rising number not match the batch number?

Path Finder

Hi there,

I am trying to get a rolling number whenever proposals get activated. I am able to execute the following SQL script which gets me a figure for proposals activated today using this:



select * from cr_managementinformation where activation_date >= '06-JUNE-23'
order by proposal_status 



When I change the input type to Batch then i use this:



SELECT * FROM cr_managementinformation
AND activation_date = TO_DATE(current_date)



The rising number does not match the batch number. i.e. the batch number of activations today is 302 but the rising number is only 5.


Can you help?

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

Splunk Observability Cloud | Customer Survey!

If you use Splunk Observability Cloud, we invite you to share your valuable insights with us through a brief ...

.conf23 | Get Your Cybersecurity Defense Analyst Certification in Vegas

We’re excited to announce a new Splunk certification exam being released at .conf23! If you’re going to Las ...

Starting With Observability: OpenTelemetry Best Practices

Tech Talk Starting With Observability: OpenTelemetry Best Practices Tuesday, October 17, 2023   |  11AM PST / ...