Hi, I am a retailer EC site marketer, and I am trying Qlik Sense.
First, I am Japanese. I am sorry if my English is wrong.
I want to calculate the number of purchases during the term.
Example data,
No | Date | Name
1 | 2016/01/01 | a
2 | 2016/03/10 | b
3 | 2016/07/12 | b
4 | 2016/09/19 | a
5 | 2016/11/21 | c
6 | 2017/01/11 | a
7 | 2017/08/10 | c
8 | 2017/12/30 | d
9 | 2018/02/02 | b
10 | 2018/06/20 | a
I want to this,
No | Date | Name | purchases on a year
1 | 2016/01/01 | a | 1
2 | 2016/03/10 | b | 1
3 | 2016/07/12 | b | 2
4 | 2016/09/19 | a | 2
5 | 2016/11/21 | c | 1
6 | 2017/01/11 | a | 2
7 | 2017/08/10 | c | 2
8 | 2017/12/30 | d | 1
9 | 2018/02/02 | b | 1
10 | 2018/06/20 | a | 1
Can I help me, how to calculate "purchases on a year"?
