How to show maximum values

[Javid88]

My data is about connections in 2019. It should show the day in which maximum connections conducted in each month.

It should be 

Jan    01.01.2019    45

Feb    02.02.2019    43   like that

but i was able to achieve 

Jan    01.01.2019    752

Feb    02.02.2019    742    this so far. It shows total number of connections in that month instead of that day. 

I will be grateful if somebody helps me solve this. Thanks ahead.

[deepanshuSh]

Hi, if you could provide some sample data and the syntax that you are using for the same. Based on the data provided above you need to use the aggregation function on the front end and dimension as day for the aggregation or if you are doing it on the backend then you need to group it using group by function based on the summation or count function that you might be using. 

[Javid88]

Here you are. The data is attached below.