This content has been marked as final.
Show 3 replies
-
1. Re: How to calculate data on Last X visits of different dates
Shinichiro MurakamiJan 13, 2019 8:10 AM (in response to Abdul Aleem Imam)
Here you go.
Store ID Visit ID
Visit Date
Data
Store1 N001 1/1/2018 1 Store1 N002 1/2/2018 1 Store1 N003 1/3/2018 1 Store1 N004 1/4/2018 1 Store1 N005 1/5/2018 0 Store1 N006 1/6/2018 1 Store2 N007 1/7/2018 1 Store2 N008 1/8/2018 0 Store2 N009 1/9/2018 0 Store2 N010 1/10/2018 0 Store2 N011 1/11/2018 1 Store2 N012 1/12/2018 0 Store2 N013 1/13/2018 1 Store3 N014 1/14/2018 1 Store3 N015 1/15/2018 1 Store3 N016 1/16/2018 1 Store3 N017 1/17/2018 0 Store3 N018 1/18/2018
1 Step 1 specify the data in range
Step2 sum by store
Step3 filter and layout, format.
Thanks,
Shin
-
table_calc_SM_10.5.twbx 54.3 KB
-
-
2. Re: How to calculate data on Last X visits of different dates
Abdul Aleem Imam Jan 15, 2019 3:36 AM (in response to Shinichiro Murakami)Hi Shin,
Thank you very much for the response.
Can you please tell me how can I specify the date range in it?
For example I want to take sum of data of latest X visits in a specified date range.
-
3. Re: How to calculate data on Last X visits of different dates
Shinichiro MurakamiJan 15, 2019 4:28 AM (in response to Abdul Aleem Imam)
Add date filter and change that filter to context.
Shin