Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
I have some date which looks like this:
Stuff Target Achieved
A 1 1
A 1 1
A 1 0
A 1 1
B 1 1
B 1 1
B 1 1
B 1 1
B 1 1
I need to create a barchart which would tell me what's the percentage of the stuff achieved, thus, in this example the barchart would be like:
A -> 75%
B -> 100%
The problems now is that I want to display values on the chart, but instead of the percentage I want to display the number of stuff achieved in each A and B, so it would be like 3 for A and 5 for B, but I want to keep the percentage from 0 to 100 on the Y Axis. How would I do that?
Thanks,
Adrian
PS: No scrips because I can't open them
Create a Bar Chart
Dimension
Stuff
Expression
SUM(Achieved)/SUM(Target)
Make sure for this expression Bar is Ticked and Values on Data Points Unticked
COUNT({<Achieved = {'>0'}>}Achieved)
Make sure Bar is unticked and Values on Data Points Ticked
Now Go To Number Tab... Select 1st Expression and Tick Fixed To 0/1/2 Decimals (whatever you want to keep)
TIck Show in percentage %
For some reason, requirements have changed. Instead of a bar chart, I now have the Combo Chart (Bar+Line). What you said it worked perfectly for bar chart, but it doesn't work for combo chart. Any ideas?
Thanks,
Adrian
It should work....
Make sure that for 2nd expresssion only Values on Data point is ticked...
The number on the bar chart is not displayed anymore. i can't open scripts, unfortunately, so could you explain me what's in there?
Thanks,
Adrian
Provide your qvw... i will look into it...
Hi,
This is my qvw. Thanks
Hi,
Select the combo Chart,
Add Stuif as dimension,
SUM(Achieved)/SUM(Target) as first expression you could see as line chart representation in left corner for the expr
COUNT({<Achieved = {'>0'}>}Achieved) as second expre
In the Number tab for the first expres cick on integer and ennale %
Hope this will help you
FYI
Hi,
I did that and it worked perfectly for bar chart. I'm using combo chart now because I need a threshold, which in this case in 100%, but it can vary. Using combo and having the threshold, the number is not shown anymore on the bars (all I did was to "add" a line at the top, at 100%). Any ideas?
Thanks