Hello All,
I am stuck with a calculation where I need to identify / sort based on the number of times a particular object noted on a given duration. For instance, I need to list out top domains which have been seen/accessed daily on the last N days.
Please refer the below screenshot for understanding:
As you can see in the image, the current sort is done on the count; due to which the domain called: hirro.com is on top. The requirement here states, the sorting must be based on the number of times (days on the considered period). According to this, the top 3 domains should be: vorot.com, boiscit.com, krink.com.
Attaching the .twbx file (2018.3.1). Thanking you in advance.
Regards,
Souti
Hi Souti,
I have checked your data source, so all you need to do is to use count function.
You need to change the time frame(Monthly), as you are checking the number of occurrence on daily basis which will come to one as per your data source. So change it to year and month.
Done.
-Nikher Verma
