count wrt day timescale

tejaswini

Hello , 

 

I/p screen 

Products	start date	End Date
A1	1/3/2020	5/3/2020
A2	1/3/2020	8/5/2020

 

O/p Screen should contain the product count and it should look like

	1-Mar	2-Mar	3-Mar	4-Mar
No of Products	2	2	2	1

Can we able to do this in anaplan?(As the output screen in Day time scale)

 

Thanks

Tejaswini

Ingilavicus

Hi @tejaswini ,

 

The first thing that comes to mind is that you should make an additional module with Products and time in dimensions. 

 

Then you just see if the product is active within a given period: IF date >= Start Date AND date <= End Date THEN 1 ELSE 0

 

If you have a top-level for the product you should see the # of products right away as a summary of that 1/0 condition. 

 

Hope this helps, Andris