Author Topic: Help. Percent Value and Data Value to be shown  (Read 209 times)

Offline lexlukkia

  • Full Member
  • ***
  • Join Date: Apr 2018
  • Posts: 23
  • Forum Citizenship: +0/-0
Help. Percent Value and Data Value to be shown
« on: 18 May 2018 05:05:23 am »
Good day experts.

im here again seeking your help.

is there a way that we can display both percent value and data value on chart?

see file attach.

thank you.

Offline lexlukkia

  • Full Member
  • ***
  • Join Date: Apr 2018
  • Posts: 23
  • Forum Citizenship: +0/-0
Re: Help. Percent Value and Data Value to be shown
« Reply #1 on: 18 May 2018 06:02:51 am »
want i want to achieve is something like the attach image.

i add a note on my chart.

but my problem is... i have more series... this method will not work.

Online Lynn

  • Statesman
  • ******
  • Join Date: Apr 2008
  • Posts: 2,645
  • Forum Citizenship: +337/-1
Re: Help. Percent Value and Data Value to be shown
« Reply #2 on: 18 May 2018 06:14:05 am »
You can add another axis to plot the %

Offline lexlukkia

  • Full Member
  • ***
  • Join Date: Apr 2018
  • Posts: 23
  • Forum Citizenship: +0/-0
Re: Help. Percent Value and Data Value to be shown
« Reply #3 on: 18 May 2018 06:52:11 am »
You can add another axis to plot the %

thanks for the reply lynn.
can you please enlighten me how to do it.

after i add the secondary axis, i drag the data item containing the expression to get the percentage... but after that, the result is like there is a bar covering the two measure. (see file attach)

Online Lynn

  • Statesman
  • ******
  • Join Date: Apr 2008
  • Posts: 2,645
  • Forum Citizenship: +337/-1
Re: Help. Percent Value and Data Value to be shown
« Reply #4 on: 18 May 2018 07:12:01 am »
thanks for the reply lynn.
can you please enlighten me how to do it.

after i add the secondary axis, i drag the data item containing the expression to get the percentage... but after that, the result is like there is a bar covering the two measure. (see file attach)

It looks like you are using the standard charts (not rave visualizations) so my response is specific to those.

Click on the chart and look at the properties pane. You should see a property called "Combinations". You can tick the box for both primary and secondary axis. On the Primary Axis you can have your clustered bar to show the numeric values and on the Secondary Axis you can use a clustered line for the percentages.

The line can be styled to show only points without the connecting lines between them. The height of the bars will correspond to the Y-axis on the left of the chart (the primary axis) and the height of the dot will correspond to the percentage value on the Y2-axis on the right side of the chart (the secondary axis).

Attached is an image of this idea using the sample data plotting quantity by product line on the bars with a second axis for the % of total.


Offline lexlukkia

  • Full Member
  • ***
  • Join Date: Apr 2018
  • Posts: 23
  • Forum Citizenship: +0/-0
Re: Help. Percent Value and Data Value to be shown
« Reply #5 on: 18 May 2018 07:22:03 am »
it looks like i dont have the rave visualization.  :-[ :'(

see file attach.

Offline lexlukkia

  • Full Member
  • ***
  • Join Date: Apr 2018
  • Posts: 23
  • Forum Citizenship: +0/-0
Re: Help. Percent Value and Data Value to be shown
« Reply #6 on: 18 May 2018 07:31:25 am »
is there another way to achieve it?

or just in rave visualization?


Online Lynn

  • Statesman
  • ******
  • Join Date: Apr 2008
  • Posts: 2,645
  • Forum Citizenship: +337/-1
Re: Help. Percent Value and Data Value to be shown
« Reply #7 on: 18 May 2018 07:42:57 am »
is there another way to achieve it?

or just in rave visualization?

Sorry I was not clear in what I wrote earlier. My response is specific to charts, not to Rave. You don't need rave to do what I suggested.

Offline lexlukkia

  • Full Member
  • ***
  • Join Date: Apr 2018
  • Posts: 23
  • Forum Citizenship: +0/-0
Re: Help. Percent Value and Data Value to be shown
« Reply #8 on: 18 May 2018 08:11:04 am »
Sorry I was not clear in what I wrote earlier. My response is specific to charts, not to Rave. You don't need rave to do what I suggested.

what am i doing wrong with this.(see file attach)

i have your instruction.
i drag 2 data item to secondary axis.
change the bar to line, and set markers only.

but the markers are in the middle.
i cant find in the property to set the market on top or inside the bar.

and i have two result of the same data item.


Online Lynn

  • Statesman
  • ******
  • Join Date: Apr 2008
  • Posts: 2,645
  • Forum Citizenship: +337/-1
Re: Help. Percent Value and Data Value to be shown
« Reply #9 on: 18 May 2018 08:25:58 am »
what am i doing wrong with this.(see file attach)

i have your instruction.
i drag 2 data item to secondary axis.
change the bar to line, and set markers only.

but the markers are in the middle.
i cant find in the property to set the market on top or inside the bar.

and i have two result of the same data item.

If you mock up a similar situation using the sample data package then it might be easier to help. The markers would correspond to the values on the secondary axis which would presumably be from 0% to 100%. They would line up with the corresponding bar because the X-axis is the same, but their position otherwise has nothing to do with the bar.

Look again at the image I attached to see if my suggestion suits your requirement or not.

 


       
Twittear