QuintusVisuals® 1.3 User Manual
Contents
1. Option Description Data table Specifies the data table on which the visualization will work Marking Specifies the marking hence the color and relationships to other marked items that will be used to mark items in this visualization New Opens the New Marking dialog where you can specify a new marking The color of a previously created marking is edited in the Document Properties dialog Quintus consultants b v 29 QUINTUSVISUALS 1 3 FOR TIBCO SPOTFIRE USER S MANUAL Spider Plot Properties Appearance Option Show markers Marker size Show dimension lines Show measure lines Scales Inside offset Scales Outside offset Scales Reverse scale Show grid lines Number of grid lines Grid line thickness Toggle chart Art board Quintus consultants b v Spider Plot Properties Sem General Data Markers V Stow naken Formatting Marker size Fonts J Dimensions Dimensions Measure lines Colors V Show dimension lines V Show measure lines Line thickness Line thickness Tooltip 2 2 Legend Trellis Scales Grid lines Reverse scale V Show grid lines Inside offset Number of grid lines 0 T 5 T Outside offset Line thickness 0 T 2 T Visualization F Toggle chart Att board Static color Description Specifies showing of markers on the Spider Plot Specifies the marker size If a checkmark is shown in the check box then the reference line is2. Version Author Description Date 1 3 Quintus Documentation for QuintusVisuals 2012 03 02 consultants b v version 1 3 Contact information For questions and information www quintusvisuals com Quintus consultants b v i QUINTUSVISUALS 1 3 FOR TIBCO SPOTFIRE USER S MANUAL Table of contents 1 Cascade visualization ss idein otee tete dac velot detiene ter ae tide 1 1 1 What is a Cascade visualization esssssssssseeeeeneen nen 1 1 2 How to use the Cascade graph sssssssssseeseeeneenen eene nenne 4 1 3 Cascade Properties e aa UE ENIRO NERA ER Ra ERE NER Foe Pn RR san 6 1 4 Cascade Properties General sess 7 1 5 Cascade Properties Data eene 8 1 6 Cascade Properties Font sssssssssssssssseseeeen nne nennen nennen nen 9 1 7 Cascade Properties Colors nennen nennen 10 1 8 Cascade Properties Formatting sssssssssseeeenennen eene 11 1 9 Cascade Properties X Axis sse 12 1 10 Cascade Properties Label sssssssssseseeeneenen nennen 13 1 11 Cascade Properties Tooltip nenne 14 1 12 Cascade Properties Legend sse eene 15 1 13 Cascade Properties Trellis sese 16 2 Dashboard visualization esses 17 2 1 What is a Dashboard visualization Speed Dial and Traffic Light 17 2 2 Ho
3. Option Description Title The title of the visualization Tip Double click on the title bar of the visualization for a shortcut to this field Show title bar Specifies whether or not to show the visualization title Description A description of the visualization Quintus consultants b v 20 QUINTUSVISUALS 1 3 FOR TIBCO SPOTFIRE USER S MANUAL 2 5 Speed Dial and Traffic Light Properties Data Option Description Data table Specifies the data table on which the visualization will work Value Specifies the measurement value to be displayed in the Speed Dial or Traffic Light based on the defined KPI value for the current period Quintus consultants b v 21 QUINTUSVISUALS 1 3 FOR TIBCO SPOTFIRE USER S MANUAL 2 6 Speed Dial and Traffic Light Properties Segments General Data Presentation Trellis Option Continuous With segments Set to Current Range Quintus consultants b v Speed Dial Properties Continuous With segments Add Delete Segment properties Title Segment1 Segment2 Segment3 Color EN Low boundary 0 High boundary 11 5 Description Specifies a start color and end color for the speed dial this option is only available in the Speed Dial Continuous coloring is based on one segment The Segments option is used for defining the segments making up the visualization Both visualizations must have at least one segment Th
4. QuintusVisuals QuintusVisuals 1 3 for TIBCO Spotfire User s Manual Author Quintus consultants b v Version 1 Date 2 March 2012 Quintus consultants b v provides and implements IT solutions Quintus is specialized in IT implementations for financial organizations such as banks and insurance companies but also provides services to financial departments including mergers and acquisitions in other business areas such as energy companies QUINTUSVISUALS 1 3 FOR TIBCO SPOTFIRE USER S MANUAL Disclaimer The information contained in this document is the proprietary and exclusive property of Quintus consultants b v except as otherwise indicated No part of this document in whole or in part may be reproduced stored transmitted or used for design or development purposes without the prior written permission of Quintus consultants b v The information in this document is provided for information purposes only Quintus consultants b v specifically disclaims all warranties express or limited including but not limited to the implied warranties of merchantability and fitness for a particular purpose except as provided for in a separate software license agreement TIBCO and TIBCO Spotfire amp are registered trademarks of TIBCO QuintusVisuals is a registered trademark of Quintus consultants b v Intended audience This document is intended for TIBCO Spotfire end users and administrators Version history
5. How to use the Cascade graph 1 To create a new Cascade as Click on the new Cascade icon FI on the toolbar Comment You can also select Insert gt New Visualization gt Cascade from the menu Response A first attempt to set up a suitable manual column based cascade is made by the application 2 To adjust the Cascade Right click on the visualization select Properties and click on the Data tab to select the applicable data table Then adjust the Cascade to display either a manual column based or automatic row based To switch between manual column based and automatic row based cascade right click on the visualization select Properties and then the X Axis tab For a manual column based Cascade The column based Cascade requires columns to be ordered in the way they need to be displayed in the visualization This order will also be used in the aggregation of the columns Select one by one the columns that need to be displayed in the cascade The default aggregation method will be sum however by clicking on each column the aggregation method can be changed A custom expression can be defined by right clicking on the bar The offset defines where the next column will start To maintain a direct connection from one bar to the next as in the examples keep them as they are However if there is a need to adjust the offset you can change the offset for each column by right clicking and then change the custom expression To
6. Description Splits the visualization into different panels for all categories in the selected columns The number of values in the specified column controls the number of panels to be displayed in each row column or page respectively A row with trellis panels will be created for each value in the selected column A column with trellis panels will be created for each value in the selected column A new page with trellis panels will be created for each value in the selected column Scroll down in the visualization to see the next page Splits the visualization into different panels for all categories in the selected column without binding any dimensions to either rows or columns This means that the number of actual values in the column to split by does not control the number of shown rows or columns in any way The number of panels that is visible on each page is instead specified using the Max number of rows and Max number of columns controls below Specifies the column to define the categories by which the visualization should be split Select the check box to manually specify the number of rows and columns that should be visible without scrolling If the check box is cleared the application will automatically specify the number of rows and columns Specifies the maximum number of panels that should be visible on each page Specifies the maximum number of panels that should be visible on each page 16 QUINTUSVISUALS 1 3 F
7. change its formatting category Category Lists the available formatting categories for the selected axis Each category in this list has separate settings Which categories are available depends on the data type of the selected axis See Formatting Settings in Spotfire documentation for a full description of all possible options Quintus consultants b v 31 QUINTUSVISUALS 1 3 FOR TIBCO SPOTFIRE USER S MANUAL 3 8 Spider Plot Properties Fonts Trellis Font Arial X Font style Size Option Description Settings for Lists all items for which you can change the font settings Click to select an item in the list to change the font settings for that text in the visualization Font Specifies the font to use for the selected items Font style Specifies the font style to use for the selected items Size Specifies the font size to use for the selected items Quintus consultants b v 32 QUINTUSVISUALS 1 3 FOR TIBCO SPOTFIRE USER S MANUAL 3 9 Spider Plot Properties Dimensions Tooltip Legend Trellis Option Dimension Measure line Range Set to Current Range Quintus consultants b v Selection Dimension Measure line Low High Project number Year A 3 Set to Current Range J Description Specifies the selected dimension Comment You can also select Custom Expression right click on value from the menu and cre
8. change the order of the columns you can right click on each column and then move right or move left The outer columns the one most left and the one most right will obviously show only one of these options For an automatic row based Cascade The axis dimension column has the attribute values over which the steps measure is aggregated For example You want to display for each Location dimension the Net Result steps The axis snapshot column has the attribute value indicating the viewing sequence For example You want to display per Year snapshot the Net Result steps for every Location dimension The axis steps column has the quantitative attribute value For example You want to display the Profit steps or Sales Volume steps or Safety Incidents steps per Year snapshot for each Location dimension Comment For the Axis Steps you can also select Custom Expression right click on value from the menu and create your own expression Response The automatic row based Cascade is updated to show the new information Quintus consultants b v 4 QUINTUSVISUALS 1 3 FOR TIBCO SPOTFIRE USER S MANUAL Comment For more information about how to change or what to show on the several axes see Properties Quintus consultants b v 5 QUINTUSVISUALS 1 3 FOR TIBCO SPOTFIRE USER S MANUAL 1 3 Cascade Properties The Cascade Properties dialog consists of several tabs e General e Data e Font e Co
9. thousand Percentage a z d cg Scienliic ative numbers Number Cust Sample Description Displays which axes are currently being used in the Cascade Click an axis to change its formatting category Lists the available formatting categories for the selected axis Each category in this list has separate settings Which categories are available depends on the data type of the selected axis See Formatting Settings in Spotfire documentation for a full description of all possible options sii QUINTUSVISUALS 1 3 FOR TIBCO SPOTFIRE USER S MANUAL 1 9 Cascade Properties X Axis J Cacade Delta Row Option Description Manual column based Use this option to setup the axes of a manual column based cascade Automatic row based Use this option to setup the axes of an automatic row based cascade Use the Cascade Delta Row tickbox to switch between the Delta and Aggregate sub flavor Quintus consultants b v 12 QUINTUSVISUALS 1 3 FOR TIBCO SPOTFIRE USER S MANUAL 1 10 Cascade Properties Label a es Ex General Data Show labels for Font Al Colors Marked rows X Axis eae Project number Tooltip Priority Legend Year Trelis Upstream year Option Description Show labels for Determines whether to show labels on all bars All bars containing marked rows only Marked rows or not to show any labels at all None Display la
10. 10 Spider Plot Properties Colors 34 3 11 Spider Plot Properties Labels ssssssssseeeeenenenn enne 35 3 12 Spider Plot Properties Tooltip ssseeeneenenenns 36 3 13 Spider Plot Properties Legend sssssssssseeeeee enne 37 3 14 Spider Plot Properties Trellis sseeeennnnenn 38 Quintus consultants b v ii QUINTUSVISUALS 1 3 FOR TIBCO SPOTFIRE USER S MANUAL 1 1 1 Cascade visualization What is a Cascade visualization A Cascade visualization also known as a waterfall plot is a barchart like graph that is used to show the effect of sequentially positive and negative values It has a begin situation optional intermediate situations and an end situation Using the sequentially positive and negative values the visualization shows how the begin situation transitions into the intermediate and finally into the end situation For analytical purposes a Cascade graph can assist in explaining transitions in quantitative data For example it can show how the net result transitions over years via a dimension such as a physical location or a product type There are two Cascade flavors available The first flavor is the so called manual column based cascade This flavor shows how values can be broken down into individual parts As shown in the example below each column represents a bar in the chart The sales are broken down into se
11. OR TIBCO SPOTFIRE USER S MANUAL 2 Dashboard visualization 2 1 What is a Dashboard visualization Speed Dial and Traffic Light A dashboard consists of a number of graphs plots and tables that are generally financial which reproduce information or key performance indicators in a logical structured way A dashboard is also often compared to your car s cockpit which also uses dials counters and warning lights to give you a clear overview of your car s status This enables you to see at a glance what the state of affairs is The Speed Dial and Traffic Light visualizations make it possible to build an attractive dashboard in Spotfire giving a clear overview of your targets and whether or not they are still attainable The status of the metric is shown by using minimum and maximum values KPI values that have been defined in advance Example A data table contains sales figures for a number of different products and shops The speed dial and traffic light can show the current total sum of Sales Amount against the KPI for the current year Traffic Light v v x Speed Dial vw X See also How to use the Speed Dial and Traffic Light Speed Dial and Traffic Light Properties Quintus consultants b v 17 QUINTUSVISUALS 1 3 FOR TIBCO SPOTFIRE USER S MANUAL 2 2 How to use the Speed Dial and Traffic Light 1 To create a new Speed dial or Traffic light Click on the new Speed Dial or Traffic Light l but
12. as a radar plot is a diagram in the form of a web that is used to indicate the relative influence of different parameters This is usually done when there are more than three factors that can influence a result Spider Plots can be used to show the different causes of a problem situation The factors that have most influence are mainly located on the periphery of the web and parameters that have little influence on problem situations are located at the web s centre Example A data table contains sales figures for a number of different products and shops The Spider plot can show the Sales Amount against the number of orders Spider plot v v x Spider plot Data table Hi Mediamarkt v Marking Shop 8 Shop C BMarking v Color by BilTotaloraers Bilsates amp mount Hame v ShopF Shop E Totalorders v SalesAmout v v See also How to use the Spider Plot Spider Plot Properties Quintus consultants b v 25 QUINTUSVISUALS 1 3 FOR TIBCO SPOTFIRE USER S MANUAL 3 2 Howto use the Spider Plot 1 To create a new Spider plot pi Click on the new Spider plot button on the toolbar Comment You can also select Insert gt New Visualization gt Spider Plot from the menu Response A first attempt to set up a suitable Spider plot is made by the application 2 To adjust the Spider Plot to display the dimensions and measures of your choice The dimension has the attribute value wher
13. ate your own expression Specifies the selected measures Comment You can also select Custom Expression right click on value from the menu and create your own expression Specifies the boundaries for drawing the plot with the Low and High values Set values are persistent while deleting values will set the option to automatic again Sets the current filtered range for each measure Only works when range field is set to automatic 1199 QUINTUSVISUALS 1 3 FOR TIBCO SPOTFIRE USER S MANUAL 3 10 Spider Plot Properties Colors Option Description Measure line Use this option to apply a single fixed color per measure line Use the palette to change to a different color Comment On toggled Spider Plot a checkbox for continuous coloring appears at the bottom of Colors tab Marker Use this option to apply a color scheme with different colors for each measure or a fixed color for all markers Quintus consultants b v 34 QUINTUSVISUALS 1 3 FOR TIBCO SPOTFIRE USER S MANUAL 3 11 Spider Plot Properties Labels Ge ESS Data Show labels for Appearance AI Formatting Marked rows Fonts None Ec Display labels for markers Uisplay or mi Vom Tooltip 7 Year Legend Trellis Option Description Show labels for Determines whether to show labels on all bars All bars containing marked rows only Marked rows or not s
14. bels for Determines whether to show labels for markers The list of columns shown depends on markers the selected cascade flavor Quintus consultants b v 13 QUINTUSVISUALS 1 3 FOR TIBCO SPOTFIRE USER S MANUAL 1 11 Cascade Properties Tooltip Display the following values Move Up Move Down Option Description Display the following Specifies what information is to be shown when a cascade is hovered values Offset the value where the bar starts Total the value where the bar ends Value the size of the bar Total Offset X Axis the Axis Steps name Quintus consultants b v 14 QUINTUSVISUALS 1 3 FOR TIBCO SPOTFIRE USER S MANUAL 1 12 Cascade Properties Legend Option Description Show legend Specifies whether or not the legend is shown in the visualization Display the following Specifies the items that will be shown in the legend values Quintus consultants b v 15 QUINTUSVISUALS 1 3 FOR TIBCO SPOTFIRE USER S MANUAL 1 13 Cascade Properties Trellis Cascade Properties General Font Colors Formatting X Axis Label Tooltip Legend Data BX Rows and columns Rows None v Columns None v Pages None v Panels None v Close Option Rows and columns Rows Columns Pages Panels Split by Manual layout Max number of rows Max number of columns Quintus consultants b v
15. e impact over time on the projected Profit per Region The Profit is shown starting at Year 2014 value 1679 then steeply increases via Year 2015 value 3952 to a substantially lower profit in Year 2016 value 551 This visualization shows how each region influences the profit year over year For example Region Africa has in 2015 a decreasing profit when compared to 2014 but has an increasing profit in 2016 when compared to 2015 Quintus consultants b v 2 QUINTUSVISUALS 1 3 FOR TIBCO SPOTFIRE USER S MANUAL Example row based cascade aggregate Cascade Row Aggregate rS MS Cascade Row Aggregate 531 00 6182 Data table Bi Projectportfolio v 281 00 6000 Marking 5500 mmMarking v 5000 4500 4000 3500 3000 2500 2000 1679 447 00 1500 1000 2014 Africa Europe North America 2015 Africa Europe North America 2016 Dimension Region v Snapshot Year v Steps Profit v This example uses the same data as the previous cascade row However what is shown here is the aggregated projected Profit over the Year 2014 up to 2016 and how each Region contributes to the aggregated snapshot profit totals Example the snapshot total for 2016 shown here is the aggregated Profit of Year 2014 plus Year 2015 plus Year 2016 See also How to use the Cascade graph Cascade Properties Quintus consultants b v 3 QUINTUSVISUALS 1 3 FOR TIBCO SPOTFIRE USER S MANUAL 1 2
16. e segments make up differently colored areas in the visualization background For traffic light each segment corresponds to one light Add Click this button to add a new segment to the visualization Delete Click this button to remove the currently selected segment from the visualization Title Specifies a name for the selected segment This name is for identification only and is not relevant for drawing the visualization Color Specifies the color for a segment Change the color with a color picker Low boundary This is the minimum value for the segment High boundary This is the maximum value for the segment Segments are fixed and are changed by either user input or clicking Set to Current Range button Sets the current filtered range for Value expression on Data tab 22 QUINTUSVISUALS 1 3 FOR TIBCO SPOTFIRE USER S MANUAL 2 7 Speed Dial and Traffic Light Properties Presentation Comment The presentation tab is only available in the Speed Dial Speed Dial Properties zl General Data V Display measurement Segments V Display scale v Display the following text expression Trellis Ava Project number Expression builder Expression for rounding 0 Steps 30 E Display labels on each step 30 gt Decimals 0 t Close Option Description Display measurement Hide or show the measurement title in the visualization Display scale Hide or show the scale in the visualization Di
17. e the measure is over the aggregated value for example You want to display the Sales amount measure for every shop dimension attribute Right click on the visualization select Properties and click on the Data tab Choose the appropriate data table and the measure and dimension values on the Dimension tab or drag and drop the values from the filter panel on the visualization For changing the aggregation click on the column and select Aggregation then select a new aggregation method from the submenu Comment You can also select Custom Expression right click on value from the menu and create your own expression Response The Spider Plot is updated to show the new information Comment For more information about how to change or what to show on the two axes see Properties 3 To apply changes to the ranges of the axes Right click on the visualization select Properties and click on the Dimension tab In the range section you can change values for low and high ranges By default the minimum and maximum values for the measure value are used Low range This is the minimum value limiting the range of the visualization Max range This is the maximum value limiting the range of the visualization 4 To apply changes to presentation settings Right click on the visualization select Properties and click on the Appearance tab On this tab you can change many properties for the visualization You can hide or show the markers
18. how any labels at all None Display labels for Determines whether to show labels for markers markers Quintus consultants b v 35 QUINTUSVISUALS 1 3 FOR TIBCO SPOTFIRE USER S MANUAL 3 12 Spider Plot Properties Tooltip Display the following values Dimension Option Description Display the following Defines what to show in the tooltip label and in what order it should be presented values Quintus consultants b v 36 QUINTUSVISUALS 1 3 FOR TIBCO SPOTFIRE USER S MANUAL 3 13 Spider Plot Properties Legend Option Description Show legend Specifies whether or not the legend should be shown in the visualization Display the following Specifies what will be shown in the legend values Quintus consultants b v 37 QUINTUSVISUALS 1 3 FOR TIBCO SPOTFIRE USER S MANUAL 3 14 Spider Plot Properties Trellis Spider Plot Properties Sm General Rows and columns Appearance Formatting Fonts Dimensions Columns None v Colors Labels Pages None v Tooltip Legend Pam Rows None v Option Description Rows and columns Splits the visualization into different panels for all categories in the selected columns The number of values in the specified column controls the number of panels to be displayed in each row column or page respectively Rows A row with trellis panels will be created for each value in the se
19. ide or show the measurement scale and the text elements from the visualization In the text editor you create your own text which will be displayed in the visualization Text example amp Sum SalesAmount 1000 amp 10 3 You can use the expression builder to change the expression When your dataset contains large numbers you can round these using an expression For example 0 1000 In the steps and labels option you can change the number of steps and the number of labels on the scale In the decimals option you can change the number of decimal point digits shown in the scale Quintus consultants b v 18 QUINTUSVISUALS 1 3 FOR TIBCO SPOTFIRE USER S MANUAL 2 3 Speed Dial and Traffic Light Properties The Speed Dial and Traffic Light Properties dialog consists of several pages e General e Data e Segments e Presentation only available for speed dial e Trellis To reach the Speed Dial and Traffic Light Properties dialog 1 Right click on the Speed Dial or Traffic Light visualization 2 Select Properties from the pop up menu Comment You can also click on the Speed Dial and Traffic Light visualization to make it active and then select Edit gt Visualization Properties Quintus consultants b v 19 QUINTUSVISUALS 1 3 FOR TIBCO SPOTFIRE USER S MANUAL 2 4 Speed Dial and Traffic Light Properties General Data Title Segments Speed Dial Presentation Show title
20. ified column controls the number of panels to be displayed in each row column or page respectively A row with trellis panels will be created for each value in the selected column A column with trellis panels will be created for each value in the selected column A new page with trellis panels will be created for each value in the selected column Scroll down in the visualization to see the next page Splits the visualization into different panels for all categories in the selected column without binding any dimensions to either rows or columns This means that the number of actual values in the column to split by does not control the number of shown rows or columns in any way The number of panels that is visible on each page is instead specified using the Max number of rows and Max number of columns controls below Specifies the column to define the categories by which the visualization should be split Select the check box to manually specify the number of rows and columns that should be visible without scrolling If the check box is cleared the application will automatically specify the number of rows and columns Specifies the maximum number of panels that should be visible on each page Specifies the maximum number of panels that should be visible on each page 24 QUINTUSVISUALS 1 3 FOR TIBCO SPOTFIRE USER S MANUAL 3 Spider Plot visualization 3 1 What is a Spider Plot visualization A Spider Plot also known
21. in the Document Properties dialog Quintus consultants b v 8 QUINTUSVISUALS 1 3 FOR TIBCO SPOTFIRE USER S MANUAL 1 6 Cascade Properties Font Option Description Setting for Lists all items for which the font settings can be changed Click to select an item in the list to change the font settings for that item in the visualization Font Specifies the font to use for the selected item Font style Specifies the font style to use for the selected item Size Specifies the font size to use for the selected item Quintus consultants b v 9 QUINTUSVISUALS 1 3 FOR TIBCO SPOTFIRE USER S MANUAL 1 7 Cascade Properties Colors Comment the Colors properties are only applicable for the manual column based flavor Option Description Fixed Use this option to apply a single fixed color in a manual column based cascade Use the palette to change to a different color By column Use this option to apply a color scheme with different colors for all columns in a manual column based cascade Quintus consultants b v 10 QUINTUSVISUALS 1 3 FOR TIBCO SPOTFIRE USER S MANUAL 1 8 Cascade Properties Formatting Formatting X Axis Label Tooltip Legend Trellis Option Axes Category Quintus consultants b v Axes Project number Year Upstream year Category Category General Decimals Currency 2 E Use
22. labels grid lines thickness of lines reverse the scale and toggle the chart Toggling a chart means swapping the measures and the dimension in the visualization Toggling requires at least two measures Quintus consultants b v 26 QUINTUSVISUALS 1 3 FOR TIBCO SPOTFIRE 3 3 Spider Plot Properties USER S MANUAL The Spider Plot Properties dialog consists of several pages e General e Data e Appearance e Formatting e Fonts e Dimensions e Colors e Labels e Tooltip e Legend e Trellis To reach the Spider Plot Properties dialog 1 Right click on the Spider plot visualization 2 Select Properties from the pop up menu Comment You can also click on the Spider Plot visualization to make it active and then select Edit Visualization Properties Quintus consultants b v 27 QUINTUSVISUALS 1 3 FOR TIBCO SPOTFIRE USER S MANUAL 3 4 Spider Plot Properties General Title Spider Plot Show title bar Description Option Description Title The title of the visualization Tip Double click on the title bar of the visualization for a shortcut to this field Show title bar Specifies whether or not to show the visualization title Description A description of the visualization This description can optionally be shown in the Legend Quintus consultants b v 28 QUINTUSVISUALS 1 3 FOR TIBCO SPOTFIRE USER S MANUAL 3 5 Spider Plot Properties Data
23. lected column Columns A column with trellis panels will be created for each value in the selected column Pages A new page with trellis panels will be created for each value in the selected column Scroll down in the visualization to see the next page Panels Splits the visualization into different panels for all categories in the selected column without binding any dimensions to either rows or columns This means that the number of actual values in the column to split by does not control the number of shown rows or columns in any way The number of panels that is visible on each page is instead specified using the Max number of rows and Max number of columns controls below Split by Specifies the column to define the categories by which the visualization should be split Manual layout Select the check box to manually specify the number of rows and columns that should be visible without scrolling If the check box is cleared the application will automatically specify the number of rows and columns Max number of rows Specifies the maximum number of panels that should be visible on each page Max number of columns Specifies the maximum number of panels that should be visible on each page Quintus consultants b v 38
24. lors only available for manual column based flavor e Formatting e XAxis e Label e Tooltip e Legend e Trellis To reach the Cascade Properties dialog 1 Right click on the Cascade visualization 2 Select Properties from the pop up menu Comment You can also click on the Cascade visualization to make it active and then select Edit Visualization Properties Quintus consultants b v 6 QUINTUSVISUALS 1 3 FOR TIBCO SPOTFIRE USER S MANUAL 1 4 Cascade Properties General Data Title Cascade V Show title bar Description Option Description Title The title of the visualization Tip Double click on the title bar of the visualization for a shortcut to this field Show title bar Specifies whether or not to show the visualization title Description A description of the visualization This description can optionally be shown in the Legend Quintus consultants b v 7 QUINTUSVISUALS 1 3 FOR TIBCO SPOTFIRE USER S MANUAL 1 5 Cascade Properties Data Data Data table Marking string Option Description Data table Specifies the data table on which the visualization will work Marking Specifies the marking hence the color and relationships to other marked items that will be used to mark items in this visualization New Opens the New Marking dialog where you can specify a new marking The color of a previously created marking is edited
25. ons can be applied this visualisation allows for explanations of the profit amp loss statement in a visual way showing the impact of each cost category on the final result e The second flavor is the so called automatic row based cascade Instead of using multiple data table columns to show transitions this flavor is based on the combination of a snapshot dimension and a single steps column expression to show transitions This flavor requires that the data table is structured as sequential quantitative information for example time location or personnel information This flavor has two sub flavors The first sub flavor is the row based delta cascade This cascade visualization shows how one snapshot total transitions to the next snapshot total The second sub flavor is the row based aggregate cascade This cascade visualization shows how one snapshot total transitions to the next snapshot total where a snapshot total is the aggregated total of the current snapshot and all preceding snapshot totals Example row based cascade delta Cascade Row Delta v v x Cascade Roy Delta Data table 2746 00 amp Project portfolio v 1118 00 281 00 5000 Marking 4500 Marking v 4000 2467 00 3952 00 3500 3000 2500 1492 00 2000 1679 1017 00 0 00 551 00 2014 Africa Asia Europe North Ame 2015 Africa Asia Europe North Ame 2016 Dimension Region v Snapshot Year v Steps Profit v In this example we see th
26. shown in the visualization Clear the check box to hide the lines With line thickness you can specify the thickness If a checkmark is shown in the check box then the reference line is shown in the visualization Clear the check box to hide the lines With line thickness you can specify the thickness With the inside offset setting you can specify an offset from the centre of the Spider plot Use this offset when many points are close together to the centre of the visualization With the outside offset setting you can specify an offset from the outer side boundary of the Spider Plot Use this option to force points to move from the outer side boundary towards the centre of the visualization Reverses the current sort order so that the lowest value is displayed at the top of the scale Specifies whether or not gridlines should be visible To change the number of grid lines With line thickness you can specify the thickness Swap the measures and the dimension in the visualization Change the continuous coloring 930 QUINTUSVISUALS 1 3 FOR TIBCO SPOTFIRE USER S MANUAL 3 7 Spider Plot Properties Formatting General Data Axes Appearance roject name Fonts Dimensions Colors Labels E Tooltip Category This category does not contain any settings lagu Trellis Sample Option Description Axes Displays which axes are currently being used in the Spider Plot Click an axis to
27. splay the following Hide or show text in the visualization text Expression In the expression text box you can create your own expression You can use the expression builder to create an expression Comment When changing Value on Data tab this expression is changed to the expression of Value Expression for rounding When your dataset contains large numbers you can round these using an expression For example 0 1000 Steps Display labels on each step Decimals Quintus consultants b v With the steps and display labels option you can change the number of steps and the number of labels on the scale With the steps and display labels option you can change the number of steps and the number of labels on the scale With the decimals option you can change the number of decimal point digits shown in the scale 03 QUINTUSVISUALS 1 3 FOR TIBCO SPOTFIRE USER S MANUAL 2 8 Speed Dial and Traffic Light Properties Trellis Option Rows and columns Rows Columns Pages Panels Split by Manual layout Max number of rows Max number of columns Quintus consultants b v Speed Dial Properties Exa General Data Rows and columns Segments Presentation Rows enn x Columns None v Pages None v Panels None v Close Description Splits the visualization into different panels for all categories in the selected columns The number of values in the spec
28. ton on the toolbar Comment You can also select Insert New Visualization Speed Dial or Traffic Light from the menu Response A first attempt to set up a suitable Speed Dial or Traffic Light is made by the application 2 To adjust the Speed Dial or Traffic Light to display the categories and measures of your choice Right click on the visualization select properties and click on the Data tab Select the data table then select the measure Comment You can also drag and drop a column from the filter panel on the visualization To change the aggregation left click on value and select Aggregation then select a new aggregation method from the submenu Comment You can also select Custom Expression right click on value from the menu and create your own expression Response The Speed Dial or Traffic Light is updated to show the new information 3 To apply changes to the segments and colors Right click on the visualization select properties and click on the Segments tab and create your own segments By default three segments are created You can add new segments change the name color and values for the low and high boundaries Low boundary This is the minimum value limiting the range of the visualization Max boundary This is the maximum value limiting the range of the visualization 4 To apply changes to presentation Right click on the visualization select properties and click on the Presentation tab You can h
29. veral cost components It identifies how total sales are distributed over each cost category In this flavour each bar represents a column Example column based cascade Cascade Column based VAS IMS Data table amp DataTable v Marking Marking v Color by B Seles Bl Purchases E Salaries E Rent B Depreciation I Other costs Ill Profit Sales Purchases Salaries Rent Multiple columns The column based visualisation as shown above provides an explanation on the composition of a profit and loss statement The columns in the dataset are Sales Purchases Salaries Rent Depreciation Other costs and Profit The Sales values are positive all costs are shown as negative including the remaining profit These columns are listed on the x axis shown as Multiple columns On the y axis the sum of values are automatically shown for each of the columns Each column starts at the end result of the previous column Hence the first column starts at 0 and since the values for Sales are positive the bar goes up to the sum Sales here at 635 The second column starts at 635 and since Quintus consultants b v 33 QUINTUSVISUALS 1 3 FOR TIBCO SPOTFIRE USER S MANUAL sum Purchases is 272 the bar shown is from 635 to 363 The third bar in this case starts at 363 and since sum Salaries is 32 the bar shown is from 363 to 331 etc Since filtering trellis and other functi
30. w to use the Speed Dial and Traffic Light 18 2 3 Speed Dial and Traffic Light Properties cccccceseeceeseeeeeeeeceereeeeaeeeseaeeeeeeeesaees 19 2 4 Speed Dial and Traffic Light Properties General sess 20 2 5 Speed Dial and Traffic Light Properties Data ssssssee 21 2 6 Speed Dial and Traffic Light Properties Segment sssssssss 22 2 7 Speed Dial and Traffic Light Properties Presentation sesssusss 23 2 8 Speed Dial and Traffic Light Properties Trellis sss 24 3 Spider Plot visualiZatlopi uo eed toe cda i Ee rea ec eoa 25 3 1 What is a Spider Plot visualization ssssssseeeeenne 25 3 2 How to use the Spider Plot iit een Ene i tenia 26 3 3 Spider Plot Properties ded eer ned e pte retine etr raten 27 3 4 Spider Plot Properties General mrrrnannvnnannvnnenvvnnnr ann nrnnnnnvnnerrennnrrnannrnnnnnnnrsnren 28 3 5 Spider Plot Properties Data mmrnarnnvnnnnvnnnnnvnnonrnnnnrannnnrnnnnnnnnerrrnsnrneennrnnsnnnnrnnnen 29 3 6 Spider Plot Properties Appearance sssssssseeeenneneenes 30 3 7 Spider Plot Properties Formatting 31 3 8 Spider Plot Properties Fonts arnnrnrrnnnnvnnnn vener vnnnnrrnnnnrnnnnnnenerrensnrrnennrnnsnnnnrsnren 32 3 9 Spider Plot Properties Dimensions ssssseeeeeene 33 3
Download Pdf Manuals
Related Search