Date range from selected period

Question & Answer
,
1

I have created the custom period like last 12 months using below calculation
ifelse(orderdate > addDateTime(-12,‘MM’,now()),sales,NULL)
here i would like to show the date range beginning and end of the month like Date Range: Jan 2023 - Feb 2022. in table or text box. Please advise me. Thank you.

2

Hi,

you can use the period over period functions.

regards,
Naveed Ali

3

I would like to see only start month and end month not all the months.
Like i have the data like -
Jan-22
Feb-22
Mar-22
Apr-22
May-22
Jun-22
July-22
Aug-22
Sep-22
Oct-22
Nov-22
Dec-22

in this i want to show in box saying data is from Jan-22 to Dec-22.
In this i want to point you that i am using the date picker.

4

I would like to see only start month and end month not all the months.

5

@raju123 you might look to do an ifelse on your date then.

ifelse({date}=minOver({date},[],PRE_AGG) OR {date}=maxOver({date},[],PRE_AGG),{date},NULL)

This should render only the min and max dates.