# of accounts created
# of purchases1/1/20191/1/2019
10
51/1/20191/2/201920101/1/20191/3/20192511
I have a data source structured like above. What I would like to do is create a single view that shows how many installs happened by install date, and how many purchases happen by purchase date. I would also like to run a calculation by the fixed date. See below what I am trying to accomplish.
Measure1/1/20191/2/20191/3/2019# of accounts created5500# of purchases51011# of accounts/ # of purchase=5/55=10/0=11/0
Any ideas how to get the type of date I am using in my axis relative to what I am counting?
3 件の回答
Hi,
Create a Calculated Field:
IF [Account create date] = [Purchase Date]
THEN { FIXED [Account create date]: SUM([# Of Accounts Created])}
ELSE
0
END
Then
