4 Replies Latest reply on Oct 30, 2018 3:00 AM by Prajval T

# side by side with stacks

Hi Team,

Can we develop the view like below mentioned?

I need side by side across time period and time period should come below not on top (Should be continuous).

And Each bar should have two stacks like mentioned below.

• ###### 1. Re: side by side with stacks

Hi Prajval

Create piviot and add all measures first.

Create calculation follows

if

DATETRUNC('month',[Date])+0

elseif [Pivot Field Names]='New' then

DATETRUNC('month',[Date])+3

elseif [Pivot Field Names]='Open' then

DATETRUNC('month',[Date])+6

elseif [Pivot Field Names]='Planeed' then

DATETRUNC('month',[Date]) +9

END

Drag to view and select exact date.

drag pivot values into row.

drag pivot name into color.

• ###### 2. Re: side by side with stacks

Thank you Sankar,

exact solution for my requirement.

Small addition to the calculation to get the exact view like i mentioned in my post like below.

if you keep the same size for related measures(planned and actual, New and Open) stack is coming.

if  [Pivot Field Names]='New' then

DATETRUNC('month',[Date])+7

elseif [Pivot Field Names]='Open' then

DATETRUNC('month',[Date])+7

elseif [Pivot Field Names]='Planeed' then

DATETRUNC('month',[Date]) +15

ELSEIF  [Pivot Field Names]='Actual' then

DATETRUNC('month',[Date])+15

END

Only issue is, Time period labels are not aligned to center and Jan 2018 is coming which is not there in the data set.

Can you help me how to fix this done.

• ###### 3. Re: side by side with stacks

Hi Prajval,

Try this calc

if [Pivot Field Names]='Actual' then

DATETRUNC('month',[Date])-4

elseif [Pivot Field Names]='New' then

DATETRUNC('month',[Date])-1

elseif [Pivot Field Names]='Open' then

DATETRUNC('month',[Date])+2.5

elseif [Pivot Field Names]='Planeed' then

DATETRUNC('month',[Date]) +6

END

i am not get any jan 2018 in my view

Thanks

sankar

• ###### 4. Re: side by side with stacks

Thank you so much shankar.

Solution helped.