6 Replies Latest reply on Nov 20, 2016 8:26 PM by Mahfooj Khan

Aligning Shapes and triming white spaces from bottom

vivek kompella Nov 7, 2016 12:26 AM

Folks need your help;

I ma trying to build a funnel chart in a dashboard with custom shapes. Everything works as expected but the alignment of shapes is going for a toss.

There is too much whitespace at the end of the each pane and looking for a way to align the shapes to the bottom so that i can put all the sheets together in one Dashboard. tried many things but nothing seems to be working. I am using the shapes from the folder "custom Shapes".please guide me attaching the sample workbook

Stage_Funnel.twbx 56.9 KB
Stages.xlsx 8.8 KB

1. Re: Aligning Shapes and triming white spaces from bottom

krishna sarath Nov 7, 2016 1:32 AM (in response to vivek kompella)
Hi,
Just reduce the height of each sheet.This is all u need to do.
I have the same thing,and arranged them.It seems to work.
Have look at it and see if this is what u have asked for.

Stage_Funnel-Answer.twbx 55.9 KB

2 of 2 people found this helpful
Like Show 0 Likes(0)

Actions
2. Re: Aligning Shapes and triming white spaces from bottom

Mahfooj Khan Nov 7, 2016 2:04 AM (in response to vivek kompella)

Hi vivek,

You can achieve this in a single sheet. Just follow the screen shot.
Drag the fields and select the chart type as shape from marks card. Increase the size of the marks till you get this view.
Funnel Chart: Create a calculated field with -ve measure.
Let me know If you've any query.

Mahfooj
1 of 1 people found this helpful
Like Show 1 Likes(1)

Actions
3. Re: Aligning Shapes and triming white spaces from bottom

vivek kompella Nov 7, 2016 12:55 PM (in response to Mahfooj Khan)

Mahfooj Khan Thanks a lot man you have saved my day. simple and straight forward.
Like Show 0 Likes(0)

Actions
4. Re: Aligning Shapes and triming white spaces from bottom

vivek kompella Nov 7, 2016 12:56 PM (in response to krishna sarath)

Krishna thank you very much you have saved my day.
Like Show 0 Likes(0)

Actions
5. Re: Aligning Shapes and triming white spaces from bottom

sreevidya.yandra Nov 20, 2016 12:30 PM (in response to vivek kompella)

Why are we taking -ve measure for the calculated field?
Like Show 0 Likes(0)

Actions
6. Re: Aligning Shapes and triming white spaces from bottom

Mahfooj Khan Nov 20, 2016 8:26 PM (in response to sreevidya.yandra)

To get the bars behind zero line so that we could give a shape of funnel.
Like Show 0 Likes(0)

Actions