Skip navigation

4 Replies Latest reply on Dec 3, 2018 8:08 PM by Wahyu Kusumawardani

How to get the latest data of every quarter?

Wahyu Kusumawardani Nov 29, 2018 2:26 AM

Hi,

I would like to create a filter to get the latest data of every quarter.

This is the example of data

Project | CreationDate
------------- -----------------------

Project A | 1 January 2018

Project A | 10 January 2018

Project A | 13 January 2018

Project A | 2 February 2018

Project A | 20 June 2018

Project A | 3 September 2018

Project B | 3 January 2018

Project B | 10 May 2018

Project B | 3 June 2018

Project C | 3 February 2018

Project C | 2 May 2018

Project C | 3 June 2018

Project C | 10 December 2018

The expected output:

Project | CreationDate
------------- -----------------------

Project A | 2 February 2018

Project A | 20 June 2018

Project A | 3 September 2018

Project B | 3 January 2018

Project B | 3 June 2018

Project C | 3 February 2018

Project C | 2 May 2018

Project C | 3 June 2018

Project C | 10 December 2018

How is the calculation field for creating this filter?

Latest Data In Every Quarter.twbx 28.0 KB

1. Re: How to get the latest data of every quarter?

Zhouyi Zhang Nov 29, 2018 3:35 AM (in response to Wahyu Kusumawardani)
Hi, Wahyu

Please find my solution attached. below is the screenshot of result.

Hope this helps

ZZ

Latest Data In Every Quarter_v10.2.twbx 38.2 KB

1 of 1 people found this helpful
Like Show 0 Likes(0)

Actions
2. Re: How to get the latest data of every quarter?

Wahyu Kusumawardani Dec 3, 2018 8:08 PM (in response to Zhouyi Zhang)

Hi Zhouyi Zhang,

Thank you! With your latest date of the quarter calculation, it helps me to create the filter with this formula:
DATEDIFF('day',[CreationDate],[LatestDataEveryQuarter])=0

Have a nice day!
Like Show 0 Likes(0)

Actions
3. Re: How to get the latest data of every quarter?

Zhouyi Zhang Dec 3, 2018 7:38 PM (in response to Wahyu Kusumawardani)

Cool ~~

ZZ
Like Show 0 Likes(0)

Actions

Go to original post

More Like This