Built a Pie in a straight table

[pacoli2013]

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

[pacoli2013]

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

[adamdavi3s]

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!

[pacoli2013]

Hello Adam,

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

Court

[adamdavi3s]

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

[pacoli2013]

Thanks Adam,

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

[adamdavi3s]

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

[adamdavi3s]

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

[adamdavi3s]

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))

[pacoli2013]

Hello Adam,

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