Wiki Markup |
---|
{anchor:top} {toc: class=contents} h2. Overview {styleclass: Class=topLink}[top|#top]{styleclass} A chart which gives a quick overview of series of values and their statistical properties. h3. Chart Data Options |||Option||Description|| |Label|Select a label to split your series up by.| |Series|Select at least one metric to analyse in the chart.| h2. Box & Whisker Tutorial {styleclass: Class=topLink}[top|#top]{styleclass} h3. Summary In order to set up a Box & Whisker Chart you will need: # Create a report with chart display ## Select a field to use as the *Label* ## Select a field to use as the *Series* ## Enable the display of *duplicate records* # Create your chart, selecting *Analytical* as the type, and *Box & Whisker* as the chart # Provide the *Label* and *Series* options and *Refresh* # Customise the Chart as required # *Close* the Chart Builder # *Save* your report h3. Tutorial {section} {column: width=30%} *1.* Click on the *Create* link and select *Report* to begin building your report. {column} {column: width=70%} !01.png! {column} {section} {section} {column: width=30%} *2.* You should now be on the Initialise Report page. Select the *Drag and Drop Builder* as the build tool. {column} {column: width=70%} !02.png! {column} {section} {section} {column: width=30%} *3.* Select *Ski Team* as the View. *4.* Now click the !step_right_on.png! button to proceed. {column} {column: width=70%} !2a.png|thumbnail,border=1! {column} {section} {section} {column:width=30%} *5.* As the Box and Whisker Chart requires all invdividual values available you will need to enable the display of Duplicate Records so that Yellowfin doesn't limit the results to distinct values. *6.* To do this, expand the *Report Data* section and enable the *Show Duplicate Records* option. {column} {column:widhth=70%} !89.png! {column} {section} {section} {column:width=30%} *7.* On the Report Data page, drag and drop the !rpt_dim.png! *Year* dimension, and !rpt_metric.png! *Profit Margin* metric into the Column Fields area. *8.* Add the !rpt_dim.png! *Booking Status* dimension to the Filters area as well. *9.* You will need to remove the aggregation from the !rpt_metric.png! *Profit Margin* field by selecting it and clicking on the !clear.png! Clear button. *10.* Click on !step_right_on.png! at the top of the page to move to the next step. {column} {column:widhth=70%} !dataPage.png|thumbnail,border=1! {column} {section} {section} {column:width=30%} *11.* Next you will need to setup a filter to remove results where the booking was cancelled. *12.* Set the filter to *Booking Status* Equal to *Active*. *13.* Click on !step_right_on.png! at the top of the page to move to the next step. {column} {column:widhth=70%} !filter.png! {column} {section} {section} {column:width=30%} *14.* You should now see the Pie Chart image (pictured here). Click on the image to go to the Chart Format page where you can setup your chart. {column} {column:widhth=70%} !ChartClick.png! {column} {section} {section} {column:width=30%} *15.* Click on the *Chart* Menu, select *Analytical* as the Chart Type and click on the picture of the *Box and Whisker* Chart to select it. *16.* Click *Save*, this will load the options for a Box and Whisker Chart. !save.png! {column} {column:widhth=70%} !selectChart.png|thumbnail,border=1! {column} {section} {section} {column:width=30%} *17.* In the *Chart Data* section you will need to select the data for each setting in the chart. *18.* Set the Series to *Camp Rating*. *19.* Click the *Refresh* link to generate your chart. !refresh.png! {column} {column:widhth=70%} !setData.png! {column} {section} {section} {column:width=30%} *20.* You should now have a chart that looks like the one pictured. *21.* You now need to *Save* and *Activate* your chart. Click on the *Close* button to go back to the Report Preview page. {column} {column:widhth=70%} !generateChart.png|thumbnail,border=1! {column} {section} {section} {column:width=30%} *22.* Click on the *Save* Menu and use *Box and Whisker Chart Tutorial* as the Name. *23.* Type *This Box and Whisker Chart was created using the Charts Tutorial* as the Description. *24.* Enter *Tutorial* as the Category and *Charts* as the Sub Category. *25.* Click *Activate*. !activate.png! {column} {column:widhth=70%} !saveChart.png|thumbnail,border=1! {column} {section} \\ \\ {horizontalrule} {styleclass: Class=topLink}[top|#top]{styleclass} |
Page Comparison
General
Content
Integrations