I am making an aging report. Suppose i have 2 tables:
Load Script joins these two tables like below:
SYSDATE-TRDATE = Days
to get the bucket wise quantity.
Now the issue is instead of a fixed SYSDATE i want to give a date filter on front end and the then buckets should be calculated as per the date selected and data change accordingly.
create a variable as vDate.
declare it as vDate = Max(DateField)
then use it while creating buckets in Dimension section of chart.
If(Date($(vDate))-Date(TRDATE) >0 and Date($(vDate))-Date(TRDATE) <30, '0-30 Days',
If(Date($(vDate))-Date(TRDATE) >31 and Date($(vDate))-Date(TRDATE) <60, '31-60 Days'))
Using it as Dimension gave Invalid Dimension then i put it in measure and worked.
But the main problem is i want to show all buckets and data keep appearing in relevant buckets. rather than as a separate column.