# Regarding daily active users count formula **URL:** \ **Category:** Kibana\ **Created:** [January 15, 2023, 3:32am UTC](https://discuss.elastic.co/t/regarding-daily-active-users-count-formula/323188 "2023-01-15T03:32:40Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![bhavin.shah](https://avatars.discourse-cdn.com/v4/letter/b/278dde/32.png) [@bhavin.shah](https://discuss.elastic.co/u/bhavin.shah)\ **Post date:** [January 15, 2023, 3:32am UTC](https://discuss.elastic.co/t/regarding-daily-active-users-count-formula/323188/1 "2023-01-15T03:32:40Z")
Hello team, I am trying to calculate one number output as , how many customers have placed daily atleast one order in last one day. My index formation is like following Ord\_order\_no - unique record / document ID Client\_id - customer ID Ord\_trd\_trade\_date - timestamp at which order was placed. There are other columns but i thnk this should help to calculate. Basically, I need in last one week how many unique clients have placed at least one order on daily basis. It should return single matric number. Or as table as follows Days total repeat order 1 3450 2 3288 3 3300 4 3177 5 2975 It would be great if someone can assist in preparing this visualisation ---
**Author:** ![stephenb](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/stephenb/32/40856_2.png) [@stephenb](https://discuss.elastic.co/u/stephenb)\ **Post date:** [January 15, 2023, 6:00pm UTC](https://discuss.elastic.co/t/regarding-daily-active-users-count-formula/323188/2 "2023-01-15T18:00:00Z")
What version are you on? 7 Days each with Unique `client_id` that purchased something each day? You should be able to do this fairly straightforward in Lens if you are a fairly recent version. Seems like you just need the unique `client_id` perday over the last week. The data histogram would be based on your `ord_trd_trade_date` and set interval to 1 d Here is using the sample Kibana eCommerce Data that comes with every elasticsearch. ![Screen Shot 2023-01-15 at 10.07.39 AM](https://us1.discourse-cdn.com/elastic/original/3X/c/c/cc1a61a414ec0e31e926ae54ad762a2d33c4c62f.jpeg) ---
**Author:** ![bhavin.shah](https://avatars.discourse-cdn.com/v4/letter/b/278dde/32.png) [@bhavin.shah](https://discuss.elastic.co/u/bhavin.shah)\ **Post date:** [January 16, 2023, 5:20am UTC](https://discuss.elastic.co/t/regarding-daily-active-users-count-formula/323188/3 "2023-01-16T05:20:59Z")
Ho thanks for your response. I am looking for output in little different way. Suppose I did transactions for 10 times in one that week and unique days on which i 4 different days On the contrary you took transactions for 20 times but it was only for 2 unique days. So I am expecting output as following Days. Total repeat orders 1 2. -----1( your) 3 4. -------- 1(mine) 5 I hope this clarifies. ---
**Author:** ![stephenb](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/stephenb/32/40856_2.png) [@stephenb](https://discuss.elastic.co/u/stephenb)\ **Post date:** [January 16, 2023, 5:52am UTC](https://discuss.elastic.co/t/regarding-daily-active-users-count-formula/323188/4 "2023-01-16T05:52:57Z")
Apologies no I do not understand /it's not clear, Perhaps someone else will understand. You will need show more complete samples and results... Plus you did not provide the version. ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [February 13, 2023, 5:53am UTC](https://discuss.elastic.co/t/regarding-daily-active-users-count-formula/323188/5 "2023-02-13T05:53:42Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.