rolling count(date beetween count )

[ramakrishnaraavi]

how i get between dates count of days

[Anil_Babu_Samineni]

I am replying from mobile so i haven't seen your attachment

May be

Date1-date2

Or

Internal also helps here

[Shiva123]

hey ,

          rama can u explain a little more about the issue you are facing ?

[ramakrishnaraavi]

hi,

i have two years dates like 15/10/17,18/10/17,22/10/17 ,25/10/17,29/10/17,2/11/17,5/11/17

i want all dates between count of days

every excutive  every sale how many days they will take

[shiveshsingh]

Hi

may be this..

LET vMinDate=NUM(YearStart(AddYears(TODAY(),-2)));
LET vMaxDate=NUM((TODAY()));


Date:LOAD [Row ID],
[Order ID],
[Order Date] as Date,
[Order Priority],
[Order Quantity],
Sales,
[Sales Target],
Discount,
[Ship Mode],
Profit,
[Unit Price],
[Shipping Cost],
[Customer Name],
Province,
Region,
[Customer Segment],
[Product Category],
[Product Sub-Category],
[Product Name],
[Product Container],
[Product Base Margin],
[Ship Date]
FROM

(biff, embedded labels, table is Orders$);

NoConcatenate
Calender:
Load
Date($(vMinDate)+RowNo()-1,'DD-MMM-YYYY') AS Date
AutoGenerate
$(vMaxDate)-$(vMinDate)+1;

[pradosh_thakur]

May be this

LOAD [Row ID],

     [Order ID],

     [Order Date],

     [Order Priority],

     [Order Quantity],

     Sales,

     [Sales Target],

     Discount,

     [Ship Mode],

     Profit,

     [Unit Price],

     [Shipping Cost],

     [Customer Name],

     Province,

     Region,

     [Customer Segment],

     [Product Category],

     [Product Sub-Category],

     [Product Name],

     [Product Container],

     [Product Base Margin],

     [Ship Date],

     [Ship Date]-[Order Date] as count_days

FROM

[Sample - Superstore Sales (Excel).xls]

(biff, embedded labels, table is Orders$);

[sasikanth]

HI RAMA,

Sample script

Load

         Executive,

        Order_Date,

        IF(Executive=Above(Executive), Order_Date-Above(Order_Date) , Order_Date) as NoOfDaysForAnOrder

FROM SALES

Order by Order_Date Asc

If not please share your application, attached is a sample file i think.