Bar chart - compare selections w/grand totals

[brucejensen]

I have a bar chart showing cost per sq ft for selected buildings. I'd like to add a bar that shows the cost per sq ft for all of the buildings in the data set. So if I have two buildings selected, there would be three bars, one for each building plus total for all buildings. Any help would be greatly appreciated.

[karsten_konrad]

Hi,

I know of no simple solution, but I have an alternative: instead of an additional bar I'd use a reference line where you show the cost for all buildings per sq. This way, you can instantly compare the cost with the total cost for each building.

Best,

K

[Anonymous]

You can do this using set analysis expression which will ignore current selections i.e. one of the expression would be like that and rest will be based off selections

[karsten_konrad]

I think he has the buildings as a dimension - in which case your solution will produce too many bars.

K

[brucejensen]

That's right. I tried set analysis {1} on a second expression but got too many bars as a result.

[brucejensen]

That will work in a pinch but was hoping for a solution that showed a third bar. Thanks.

[jerem1234]

What you want to do is go to the Dimension Limits tab on your bar chart, and then click on "Show Total"  near the bottom. Then what you need to do is change your expression to something like:

if(dimensionality()=0, sum({1}total Tickets), sum(Tickets))

where sum(Tickets) would be your expression.

Hope this helps!

[brucejensen]

That didn't work unfortunately. Got "No Data to Display".

I'n not familiar with dimensionality function. Perhaps an error in the expression? Here's what I have...

=if(dimensionality()=0,sum({1}total(Cost/SqFt),sum(Cost/SqFt)))

[jerem1234 · Accepted solution]

Try:

=if(dimensionality()=0,sum({1}total Cost/SqFt),sum(Cost/SqFt))

Hope this helps!

[brucejensen]

Perfect! Thank you so much!