Hi,
We have a use case where we do not want to send repetitive data in the consecutive scheduled analytics report emails.
I came across "Base Count" feature which promised to solve the exact case.
But unfortunately, it does not seem to be working for me. Please share your inputs and suggestions if I am doing something wrong or missing anything.
As per the documentation in Creating Elasticsearch-based Analytics Controls (Version 2) using SQL Query (saviyntcloud.com)
My Analytics details:
Query: select username from users where username like '%reuse%'
Risk: Low
Base Count: 1
Number of History to Keep: 10 (Archival disabled)
Where do you want to save your data?: Save Data is checked
The above query in data analyzer had 14 results. So the analytics on its first run gave 14 results. I then modified 1 new test user so that the query now gives 15 results in data analyzer.
The expectation was that the Analytics will now give only 1 entry in the result but it gave 15.
I then modified the analytics with below
Base Count: 2
Number of History to Keep: 5 (Archival disabled)
After this, I modified few more test users and the query in data analyzer kept on increasing the number of results but the analytics gave 0 results.
Haardik Verma
yes,
The query returns data in Data Analyzer and the data keeps on increasing as I keep modifying new test users.
| # Run | Result in Data Analyzer | Result in Analytics |
| 1 | 14 | 14 |
| 2 | 15 | 15 |
| 3 | 16 | 0 |
| 4 | 18 | 0 |
After the 2nd run, the base count was modified from 1 to 2 and the history to keep was modified from 10 to 5
Sorry but the actual use case is not that chronologically incremental.
We will need Base Count feature to work
These are the only 3 options I see
Also, I do not see download option in history page; only delete.
created new analytics.
Base count 2, history to keep 5
On the first run, analytics gave 20 results (same as in data analyzer)
after this, I modified the data and now data analyzer gave 21 results but analytics gave 0 results
