how to calculate count of distinct(user) by daily?

[cheriemilk]

hello, 

I have below dataset as an example.

date	Data Center	LOC	AGN	UID	Customer	companyID	source	target	value
2022/04/02	dc1	en_US	Safari	uid1	customer1	companyID1	view_page_modulepicker_1	scroll_2	3
2022/04/02	dc1	en_US	Chrome	uid1	customer1	companyID1	view_page_actionsearch_1	bounce	1
2022/04/03	dc1	en_US	Chrome	uid3	customer3	companyID3	view_page_homepage_1	bounce	6
2022/04/04	dc1	en_US	Chrome	uid4	customer4	companyID4	view_page_capabilityportifolio_1	exploret_2	5
2022/04/02	dc2	en_US	Chrome	uid4	customer4	companyID4	view_page_modulepicker_1	bounce	10
......

2. now i want to calcualte how many distinct user appeared daily, and create a line chart with date as X-asix, and value of distinct user as Y axis?

Is it possible to get ?

Thanks,

Cherie

[Shishir22 · Accepted solution]

Hello @cheriemilk ,

Please try creating measure as :

NoOfUsers= DISTINCTCOUNT(DATA[UID])

And pull this measure in Values section in line chart and Date feild in Axis section of line chart.

Please mark it as answer if it solves your issue. Kudos are also appreciated.

Thanks,

Shishir