Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Bar Chart with No Dimensions and Multiple Expressions

Good Afternoon -

I have a simple bar chart with no dimensions and multiple expressions (as my data is in different columns) and I'm trying to figure out how to not only show the actual value but include an industry benchmark.  Much appreciate any help!!!!

This is what I have

Current Chart.png

This what I want

Future Chart.png

26 Replies
chaper
Creator III
Creator III

Connect the standard values(as Excel or Inline) to data through dimension or date .Then you can easily plot the standard values.If you can't connect to data other option is add calculated expression ex:if (Dimesion='SBE','6.5%') and display it as text as popup.Downside is you won't see number in chart until you hover over each bar.

chaper
Creator III
Creator III

Post a sample app or data

Not applicable
Author

Here you go....I'm looking to have Standard_A displayed within the A bar, and so on.

chaper
Creator III
Creator III

I used Inline table

Not applicable
Author

How would you do in without Inline as my data in the graph is made up of 15 different expressions

chaper
Creator III
Creator III

Inline is similar to your excel file I added Standards to respective Fields(A,B,C,D) instead of variables.If you post real sample application with 15 expressions then I can look into.

Not applicable
Author

Thx Chai - appreciate the time and help.  I've found an alternative to displaying the benchmarks but will try to post something as soon as I can as I know this will come up again for me.

chaper
Creator III
Creator III

Capture.JPG

I got the wrong graph in app.The bar chart will look like this

kkkumar82
Specialist III
Specialist III

Hi ,

As suggested use combo chart and make the line expression as invisible in the expressions tab then you won't get the line.

Hope it helps .

KK

Not applicable
Author

Thanks KK - how ever a combo chart is not going to work as I do not have any Dimensions and 15 expressions representing 15 different results.