total Count of number by month, week, day and hour for selected date range

[Zunu]

Hello,

Could you please help to figure out how to get a count of total numbers for the month, week, day, and hour for a selected date range?
Thank you for your support. 

[v-jingzhang]

Hi @Zunu

You can add month/week/day/hour columns to a visual, then add number column to the same visual and select Count aggregation type for it. Select Count (Distinct) if you want to count distinct values. 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[Vijay_A_Verma]

Please post the screenshot of your data without any confidential/sensitive data and explain the problem with reference to the screenshot.