Count from the first seen

Hi v-frfei-msft 

Thank you again for your help

here is the link: https://1drv.ms/u/s!AmE_jLrjHUAN9ggaX2Z3OSTVoeQq?e=2XsIcQ 

if i choose time range  January 9th - 12th,

So first, we should see if a Client Mac it had a first seen date earlier than the date filtered in the month.

If the client Mac was first seen on day 9 January and we run the report for days 9-12 then the client is still a previously seen device so we should show a value in day  12, 11,10 but not 9. And calculate how many times the Client Mac has been seen in this period.

if the client was first seen on day 7 January, then we should count the times he was seen starting from 9th-12 January the date filterred

if we are running the report only for 12 january and the first seen was on 7, then we will count starting with 8,9,10,11,12 of January

Example: Client MAC = 24:18:1d:7f:2b:bd

 to show how many time this client has been seen, i will count the days marked with yellow and the result will be 72 times (48+9+15)