topic Re: Previous Quarter based on date selected in App Development

Previous Quarter based on date selected

h2k18 — Sat, 16 Nov 2024 20:33:31 GMT

Hi,

We have a Date selection object on a sheet. User can select only "single" date at any given time on the filter pane. We have a Text & image object which should reflect previous Quarter based on the date selected on the filter pane.

Example1:

Date selected (Field Name = "Start Date") = "04/01/2018" (MM/DD/YYYY)

Previous Quarter should show " 1st Quarter 2018"

Example2:

Date selected (Field Name = "Start Date") = "02/01/2018" (MM/DD/YYYY)

Previous Quarter should show " 4th Quarter 2017"

Thanks,
H

Re: Previous Quarter based on date selected

dplr-rn — Fri, 28 Jun 2019 15:50:07 GMT

Sure. You can do so using set analysis

Use something like below

Sum({<OrderDate={">=$(=quarterstart(AddYears(Max(OrderDate),-1))) <=$(=quarterend(AddYears(Max(OrderDate),-1)))"}>}LineSalesAmount)

Re: Previous Quarter based on date selected

h2k18 — Fri, 28 Jun 2019 16:12:55 GMT

Thanks for the response. It is not applicable here as no aggregation is required here.

Re: Previous Quarter based on date selected

dplr-rn — Fri, 28 Jun 2019 16:44:19 GMT

What are you trying to display then? a single dimension?

Similar concept can be used but with only function instead of other aggregation functions