Grouping based on date difference results..

[sreelakshmig]

I have found date difference between two dates. Then i try to group the date difference using measure based dimension like 0 to1 day, 2 to 3 days and above 3 days given measure as the date difference.Then using that dimension i have created each group using aggregation in calculated measure. But all the values coming under above 3 days group. But lots of value o to 3 days. Nothing is showing in that group. I can't find out the issue.

[Sowmiya_C]

sreelakshmig,

Here is the output of the scenario which I said. Created the calculated measure .

output:

[Sowmiya_C]

Hi Sreelakshi G,

I think you are looking for Ag ing Buckets right?

If yes then you can calculate the Buckets 0-1,2-3,Above-3 using calculated measures

Logic for Bucket 0-1days= If (Datediff >0and Datediff<=1,Amount,0)

Like this you can do further buckets.

Hope this helps you!

Thanks,

[sreelakshmig]

Is it possible to use in SAP Analytics Cloud?

[Sowmiya_C]

yes, you can do this in SAC story level calculation

[sreelakshmig]

In my model i am not using amount field. Using total count of shipments i need to group. while i using this formula getting all 0

[Sowmiya_C]

In your scenario,

DateDiff = Date a- Date b.

DateDiff consists of no of days, right?

Here, you can split the days as 0-1 days and 1-2 days, and above3 days.

use the calculated measure,

(0-1days) = if ( DateDiff>0 and DateDiff<=1,Totalcount of shipment,0)

(0-2days) = if ( DateDiff>1 and DateDiff<=2,Totalcount of shipment,0)

Above3days = if ( DateDiff>2 ,Totalcount of shipment,0)

This scenario will work!

[sreelakshmig]

I have applied the equation but o getting in graph. but there is so many values are coming in between 0 to 1.