15 Replies Latest reply: Dec 12, 2016 8:56 AM by Andreina Toledo

# Built a Pie in a straight table

Hello,

Is it possible to build a pie in a straight table ( see attachment)

I have a straight table with one Dimension (CompanyNumber) and 5 expressions:

1) Sum(BudgetAmount)

2) Sum(ActualAmount)

3) Sum(ActualAmount) - Sum(BudgetAmount)

4)  if (Sum(BudgetAmount) > 0, Sum(ActualAmount) /  Sum(BudgetAmount), 0)

5) If ((Sum(BudgetAmount) - Sum(ActualAmount))/ Sum(BudgetAmount)> 0, (Sum(BudgetAmount) - Sum(ActualAmount))/ Sum(BudgetAmount), 1)

If I create a Pie, I use 4 and 5 to build the two Pie-parts, so 4 + 5 is the hole pie

I had created a straight table and a trellisbox with pies for every Company one pie.

Now my Managers wants that I integrate the pies into the straight table. But I don't know how I can do that with the expressions I have,

even don't know if it is possible at all

So I could use some help

Thanks in regards

Court

• ###### Re: Built a Pie in a straight table

Extra Information:

There was such a kind of question in the past: Solution was : go to chart properties -> Select expression -> Display option -> representation -> select mini Chartdate and in Mini chart settings  Select Dimension of the straight table and mode is available there.

When I do that I only have the mode Options:Sparkline, Line with dots, Bars and Whiskers.

So I think that is not the right solution, if there is a solution

• ###### Re: Built a Pie in a straight table

It might be possible, but not sure how to make the widths dynamic based on the dimension... sorry don't have more time to play but will fiddle later!

• ###### Re: Built a Pie in a straight table

Pity you have no more time to explain how you can do it, watching your Image. Hope to hear from you later

Court

• ###### Re: Built a Pie in a straight table

Hi Court,

I added the qvw for you as well.

Basically it is just a circular gauge with lots of bits turned off and the segment set to the expression

• ###### Re: Built a Pie in a straight table

When I am logged on I don't see if  a file is added to the message.

But thanks for the qvw, downloaded and will open it and learn from it.

I will try it myself,

Keep you informed

Court

• ###### Re: Built a Pie in a straight table

I have build in your way of define pies in a straight table.

At the Moment Managers are happy that they have their pies.

But I'm wondering how it works because in a normal pie there are two expressions.

In the Pies I just build in, I could only see one Expression

Hope you can explain me  so I can learn more and more

Thanks

Court

• ###### Re: Built a Pie in a straight table

Hi Court,

Is it working OK in your example? In mine I couldn't get the pie values to differ so each pie chart was the same.

Basically in your case because the pie will always add up to 100% you just need the one expression to tell it where the next segment should start. The first segment is 'assumed' to be 100% less your formula if that makes sense

• ###### Re: Built a Pie in a straight table

it's not working in my example:

I have limited my Dimension: only the 8 best are shown, so I have a rest.

if I have a rest of 10% or a rest of 40%, the pie looks alway the same. I think the problem is that you don't have two expressions like normal pies have.

Court

• ###### Re: Built a Pie in a straight table

stalwar1 can you think how to adapt the segment formula to fire for each dimension rather than the object as a whole?

• ###### Re: Built a Pie in a straight table

thought this might work but it doesn't

=PICK(MATCH(dimension,'A','B','C','D','E'),Sum({<dimension={'A'}>}ActualAmount) /  Sum({<dimension={'A'}>}BudgetAmount),

Sum({<dimension={'B'}>}ActualAmount) /  Sum({<dimension={'B'}>}BudgetAmount),

Sum({<dimension={'C'}>}ActualAmount) /  Sum({<dimension={'C'}>}BudgetAmount),

Sum({<dimension={'D'}>}ActualAmount) /  Sum({<dimension={'D'}>}BudgetAmount),

Sum({<dimension={'E'}>}ActualAmount) /  Sum({<dimension={'E'}>}BudgetAmount))

• ###### Re: Built a Pie in a straight table

I think it´s impossible to adjust dynamically the segment lower bound depending on the dimension (at least through Set Analysis, due to Set Analysis takes effect in a chart-level, but not in a row-level)

Did you find another way to do it or the answer is directly "not possible" :-(

Thank you,

• ###### Re: Built a Pie in a straight table

I didn't have any further time to look at this unfortunately  but I suspect it isn't possible

• ###### Re: Built a Pie in a straight table

Hello Andreina,

Like Adam, I have discovered that it is not possible. a gauge turned over in a pie (like adam did) is as a small chart not possible because the expression has always the same answer.

I tried to bring in the expressions from a normal gauge /pie in to a small gauge/pie and it didn't work

• ###### Re: Built a Pie in a straight table

this idea isn't the best as you can't use mini charts in a pivot either....

• ###### Re: Built a Pie in a straight table

Thank you!

Andreina