Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Generating counts of dates

Avatar

Avatar
Validate 1
Level 1
Raaghuik1996
Level 1

Likes

0 likes

Total Posts

10 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Give Back
View profile

Avatar
Validate 1
Level 1
Raaghuik1996
Level 1

Likes

0 likes

Total Posts

10 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Give Back
View profile
Raaghuik1996
Level 1

18-03-2020

Hi,

 

I have queried delivery logs based on a particular delivery & I have got the necessary output in the temp worktable....now I need to get the count of same dates like in the worktable attached below there are two dates 2nd Mar and 3rd Mar both repeated many times now I want to get like no. of 2nd Mar which is repeated and same for 3rd mar aswell.

Need some help here....Group by not working

 

Raaghuik1996_0-1584515887803.png

 

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Contributor
Level 3
saikatk2447661
Level 3

Likes

22 likes

Total Posts

58 posts

Correct Reply

14 solutions
Top badges earned
Contributor
Shape 1
Give Back 5
Give Back 3
Give Back
View profile

Avatar
Contributor
Level 3
saikatk2447661
Level 3

Likes

22 likes

Total Posts

58 posts

Correct Reply

14 solutions
Top badges earned
Contributor
Shape 1
Give Back 5
Give Back 3
Give Back
View profile
saikatk2447661
Level 3

18-03-2020

Use a query block and add two columns like this:

 

asd.png

And in advanced parameter, check the 4th box.

asd.png

Answers (1)

Answers (1)

Avatar

Avatar
Validate 1
Level 2
anupk2111
Level 2

Likes

8 likes

Total Posts

16 posts

Correct Reply

5 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
Affirm 5
View profile

Avatar
Validate 1
Level 2
anupk2111
Level 2

Likes

8 likes

Total Posts

16 posts

Correct Reply

5 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
Affirm 5
View profile
anupk2111
Level 2

18-03-2020

Hi @Raaghuik1996 

 

You can use the DateOnly () function to create a temp field which does not gives you the full time stamp but just the date. You can work with the new date field to see the distribution of the dates. 

 

Thanks,

Anup