Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts!
I've a simple table with ID, OrderDate and Sales.
I also have another table which is not linked with the above table. This table has a list of dates like a calendar.
I want to be able to select any date from Calendar and then show all the OrderDate which >= Calendar Date and <= CalendarDate+15days.
For example if I select date 01/04/2016 I get this list:
Now what I actually want is a straight table that looks like this:
Is this something possible?
Hi Waqas,
Add the above expression as your calcuated dimension.
A code may come in different dates, and how would you want to deal such situation, show against only one date? if so which date?
I guess the OP wants, that once a Code is available on a day, it should be made available on every subsequent day after it was first available in that 15 day window
That;s exactly what I'm looking for Sunny!
You may create the data accordingly in the script using Peek()/Previous(). Check it here :How to populate a sparsely populated field