Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
Hi,
you can use your dates variables in a set analysis, like this:
...{< Date = {">=$(=v_fromdate) <=$(=v_todate)"} >}...
wht abt dimension? should i break voucher_date into year-month and select as dimension?
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')
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