Creating date dimensions from variables

[swiftfahad]

hello grus

On my dashboard I am taking to and from dates from user  using calendar and storing those dates in variables

v_fromdate

v_todate

Say after user selection I have a values

v_fromdate: 01-DEC-2016

v_todate : 30-NOV-2017

now is there any way I can set my chart dimensions from 01-Dec-2016 and 31-Dec-2017  in other words how can I map calendar selection from my existing date filed (voucher_Date) already present in table.

I wanna display month wise graph according to user selection

like

Year-month	Collection
2016-DEC	1500
2017-JAN	1000
-	-
-	-
-	-
-	-
2017-NOV	5000

[YoussefBelloum]

Hi,

you can use your dates variables in a set analysis, like this:

...{<   Date = {">=$(=v_fromdate) <=$(=v_todate)"}   >}...

[swiftfahad]

wht abt dimension? should i break voucher_date into year-month and select as dimension?

[Anil_Babu_Samineni]

May be this?

If([Year-month] >= Date($(v_fromdate), 'DD-MMM-YYYY') and [Year-month] <= Date(YearEnd($(v_todate)), 'DD-MMM-YYYY'), Date(Date#([Year-month], 'YYYY-MMM'), 'DD-MMM-YYYY')

[YoussefBelloum]

do you use straight/pivot tables or tablebox for this one ?

as soon as you use expressions you can use the calendar dimensions you want..

give it a try