Loading...

qChartView format secondary Y-axis as percent

qChartView format secondary Y-axis as percent

Home Forums QuickApps Forum qChartView format secondary Y-axis as percent

  • This topic is empty.
Viewing 9 reply threads
  • Author
    Posts
    • #5777
      Anonymous
      Anonymous
      Participant

      ,

      I don't mind exporting the data, but don't know how to export a web part. The two fields used in the graph are a date and a whole number.  I'm just looking for a solution on how to format the right y-axis to show as a percent. Not sure why you need any data or the web part to tell if that's possible and how it would be accomplished.

      Lawrence

    • #5347
      Anonymous
      Anonymous
      Participant

      Seems to be little support for such a potentially useful tool. How about adding a suffix (%) to just the secondary Y axis? I could switch the primary and secondary y-axes but prefer not to.

    • #5795
      Anonymous
      Anonymous
      Participant

      Here's what I ended up doing, but again, would prefer to have % on secondary y-axis. I didn't find a way to format or add a suffix to the secondary y-axis. If anyone knows how it was done in the example, please let me know.

      secondaryYaxis.png

    • #5794
      Anonymous
      Anonymous
      Participant

      Hello,

        Would you mind to attach your qChartView web part and list template including the data (it doesn't have to be real data, it can be some fake numbers) and also please let me know your SharePoint and QuickApps for SharePoint version?

      Thanks,

    • #5781
      Anonymous
      Anonymous
      Participant

      Chart Attributes
      <chart caption="Real Time FCUS Document Production" xAxisName="Date" canvasBorderColor="#000000" canvasBorderThickness="1" rotateYAxisName="1" labelStep="0" baseFontColor="#ffffff" palette="3" numDivLines="10"  bgColor="#FFFFFF" showBorder="1" borderColor="#FF3300" borderThickness="3" plotGradientColor="#FFFFFF" outCnvBaseFontColor="#000000" drawAnchors="1" showToolTip="1" SYAxisName="Documents" PYAxisName="Accuracy Rate" setAdaptiveSYMin="1" is2D="1" toolTipBgColor="#000000" seriesNameInToolTip="0" yAxisValueDecimals="2" showLabels="1" labelDisplay="Rotate" slantLabels="1" placeValuesInside="1" showValues="1" showPercentValues="1" formatNumber="1" formatNumberScale="1" setAdaptiveYMin="1" showYAxisValues="1" PYAxisMaxValue="100" numberSuffix="%" />

      Configuration

      <Configuration>

        <Series>

          <Items FieldName="Workshop-In" AggregateFunction="Count" SeriesName="Documents to Workshop" ChartSeriesType="COLUMN" ParentYAxis="S" IncludeInLegends="true" ShowValues="true" />

          <Items FieldName="Accuracy Formatted" AggregateFunction="Avg" SeriesName="Accuracy Rate" ChartSeriesType="LINE" ParentYAxis="P" IncludeInLegends="true" ShowValues="false" />

        </Series>

        <Items FieldName="Workshop-In" AggregateFunction="Count" ChartSeriesType="COLUMN" SeriesName="Docs In" ShowValues="true" IncludeInLegends="true" />

        <XAxis FieldName="Workshop-In" SortFieldOrder="ASC" SortFieldName="Workshop-In" />

        <YAxis />

      </Configuration>

      ple Data from List

      Workshop-In Accuracy Formatted Accuracy Rate Error
      1/23/2013 100 100.00% No
      1/23/2013 100 100.00% No
      1/22/2013 100 100.00% No
      1/22/2013 100 100.00% No
      1/22/2013 100 100.00% No
      1/22/2013 100 100.00% No
      1/22/2013 100 100.00% No
      1/22/2013 100 100.00% No
      1/22/2013 100 100.00% No
      1/22/2013 0 0.00% Yes
      1/22/2013 0 0.00% Yes
      1/22/2013 100 100.00% No
      1/22/2013 100 100.00% No
      1/22/2013 100 100.00% No
      1/22/2013 100 100.00% No
      1/22/2013 100 100.00% No
      1/22/2013 100 100.00% No
      1/22/2013 100 100.00% No
      1/22/2013 100 100.00% No
      1/22/2013 100 100.00% No
      1/22/2013 100 100.00% No
      1/22/2013 100 100.00% No
      1/22/2013 100 100.00% No
      1/22/2013 100 100.00% No
      1/22/2013 100 100.00% No
      1/22/2013 100 100.00% No
      1/22/2013 100 100.00% No
      1/22/2013 100 100.00% No
      1/22/2013 100 100.00% No
      1/22/2013 100 100.00% No
      1/22/2013 100 100.00% No
      1/22/2013 100 100.00% No
      1/22/2013 100 100.00% No
      1/22/2013 100 100.00% No
      1/22/2013 100 100.00% No

      The Sharepoint version is the free 2007 version. Web Part qChartView version 5.7 (Build 2012.3.15)

    • #5780
      Anonymous
      Anonymous
      Participant

      I used the screenshot to create the list and the configuration but it gave me an error.

      Would you mid to export the list and the web part an attach them?

      Thanks,

    • #5779
      Anonymous
      Anonymous
      Participant

      ,

      You probably need this as well:

      CAML Filter

      <Geq>

        <FieldRef Name="Workshop_x002d_In" />

        <Value Type="DateTime">

          <Today OffsetDays="-90" />

        </Value>

      </Geq>

      That's all there is except the list URL

      Lawrence

    • #5778
      Anonymous
      Anonymous
      Participant

      Hi Lawrence,

      I think that the list I created from your screenshot doesn't have the same field types and that causes a problem.

      To avoid this please export your list (don't include the data if that's sensitive) and also the web part. That would give me the exact configuration.

    • #4284
      Anonymous
      Anonymous
      Participant

      I’ve seen this used as an example in the documentation, but I can’t find a way to make the secondary access show a percentage rather than a decimal even though the data is in percentage format.

      DocsGraph.png

      Can anyone show me how this is done?

      Here’s what I’d like the secondary axis to look like (from qChartView Help – Appendix: ple Charts)

      2ndYAxis.png

    • #5776
      Anonymous
      Anonymous
      Participant

      Hello,

      This is how I see the chart using the info you gave me (except for the data content, I created different set of values).

      Exporting the list and the web part would help me a lot.

      To export the list, go to list settings, then pick save list as template, include the content then save it to a local folder then attach it to the tread.

      For the web part go to the web part verb (put the page in Edit mode, select the web part , go to the top right corner and from the menu select Export).

      A web search would help too.

      chart1.PNG

Viewing 9 reply threads

You must be logged in to reply to this topic.