Skip to main content
Topics#Reports & DashboardsPregunta de Amber Gillis
Amber Gillis (K2M) ha preguntado en #Reports & Dashboards
3 may 2016, 12:16

% of each bar segment?

I need to include the % of each segment on this bar chart.  ie. The % of records in the NE bar that are green. Is there a way I can do that with a formula?  Any other suggestions?

 

% of each bar segment?
8 respuestas
  1. Sunil Sarilla (M&G Investments)
    3 may 2016, 13:32
    ok cool.

     

    If you wan the % field to be displayed on the report then the chart type must be a side by side vertical chart instead of the Stacked var chart

     

    Create a Cusom Summary formula on the Report and Give a Name to your Column

     

    Format Percent.

     

    Your Formula will be something like

    RowCount/
    PARENTGROUPVAL(RowCount, ROW_GRAND_SUMMARY, STAGE_NAME)

    The Syntax of the PARENTGROUPVAL is

    PARENTGROUPVAL(summary_field, ROW_GRAND_SUMMARY, COLUMN_GRAND_SUMMARY)

    In your Case the summary_field is Record count which is RowCount

     

    Depending on whether the Created by field is on the Row or Column Grouping, you will either Use Row Grand Summary or Column Grand Summary.

     

    Please see the screenshot below, in my case my report is a matrix Report with Created by as Row Grouping and Stage in the Column Grouping

     

    ok cool.

     

    Your Final Formula will be

    RowCount/
    PARENTGROUPVAL(RowCount, ROW_GRAND_SUMMARY, COLUMN_GRAND_SUMMARY)

    Now Create a Chart, Vertical Side by Side chart

     

    X:Axis - Area

     

    Y:Axis - Cusom formula field taht we created above

     

    Group by Created By

     

    see the screenshot below

     

    Please make sure the your check "Show Y-Axis Values" for the chart under the Formatting Tab

     

    User-added image

     

    Your Final Chart will look like as below

     

    User-added image
Escribir una respuesta...
0/9000