Successfully!

Error!

Extended Chart - Scene Switching Map

  • Last update:  2024-03-06
  • I. Overview

    a) Scene Switch Map integrates multiple 3D map scenes in a chart. With powerful information display capabilities, each map scene displays points, lines, columns and planes simultaneously.

    b) Set the Scene Switch Map with the same method for setting up Rotating GIS Point Map and Three-dimensional Earth. This document firstly introduces how to set up a basic scene switch map, with which dazzling scenes can be produced using default chart style and data. Then the document will walk you through how to modify default settings so that you can customize the visual effect of the scene as per specific business needs.

    II. Make a basic scene switch map

    1. Update plugin and JSON file

    a) Update the Extended Chart plugin to version 4.0 and above (you can contact our sales or technical support for help).

    b) Open the webapps/webroot/WEB-INF/assets/map/geographic folder in the FineReport installation folder. If no world-3.json can be found there, please download the attachment using the link below and place the file in the folder.

    c) Restart the Designer to use the scene switch map.

    https://attachments-cdn.shimo.im/3BfWrPyDRtyyoCwT.json?attname=world-3d.json

    1.png 

     

    2. Insert a scene switch map

    a) Insert a floating chart and select [Extended Chart - Scene] for Chart Type.

    b) Adjust the chart size

     


    3. How to set up a scene switch map

    You can set up the attributes of the scene switch map in a separate interface so as to preview setup effects in real time.

    4.png 

     

    4. Set the map boundary

    a) Map Boundary is set as [world-3d] by default. You can select a smaller area as the boundary.

    b) [Auto Smooth] is enabled by default. Some complicated map boundaries will be simplified, without showing some smaller points, such as islands. It is suitable for maps with a larger display area.

     

    c) If [Auto Smooth] is disabled, the map boundaries will become more complicated and more practical in displaying the actual territory. It is suitable for maps with a smaller display area, especially those with a number of islands.

     


    5. Prepare data

    a) The embedded datasets [ds1] and [ds2] of the supplied template can be used.

    b) [ds1] shows the gross profit of a company in various regions.

    c) [ds2] shows the export volumes to various regions.

     

     

    6. Set data for the first scene

    a) Select [Data]> [Point], and set up the data as shown in the diagram below. Once completed, the preview on the left will display these data in default point style.

    b) Select [Line] and set up the data as shown in the diagram below. Once completed, the preview on the left will display these data in default line style. The line is superimposed with the points. Please be noted that the lines are of the same thickness.

     

     

    7. Set data for the second scene

    a) Click [+] to create a new scene. Keep the default settings of the map boundary.

    b) Select [Data]> [Column], and set up the data as shown in the diagram below.

    c) Select [Area] and set up the data as shown in the diagram below. Once completed, the data display area will be highlighted in the preview on the left. 

     


    8. Set as carousel

    Click 41.png to select [Carousel]. Set the Time Interval to 10 seconds.

    14.png 

     

    9. Preview

    a) The scene automatically switches every 10 seconds.

     

    b) Use the buttons below to switch between scenes. Press the Pause button to keep the current scene. Click the Left or Right button to switch to the previous or next scene.

     

     

    10. Download the template

    Scene Switch_1.cpt 

    III. Modify default settings

    1. Modify the initial perspective

    a) Select the first scene. Click and drag it with mouse within the preview box and adjust the perspective. Then click [Save as initial perspective].

    b) Re-adjust the perspective, click [Back to initial perspective], and the map will be displayed at the original initial perspective.

      

    c) In preview, the first scene will display at the new initial perspective.

     

     

    2. Modify the scene color

    With the first scene selected, click [Style], and then the drop-down box following [Color Style] to change the color to [Blue-green].

    20.png 

     

    3. Modify the point style

    a) Select [Point], and set it as [Quadrangular Pyramid], [Triangular Cone Point], [Angular Cone Point] or [Light Point]. You can also customize the color of these points.

     

    b) Turn off [Aperture] to display no light spots below each point.

    26.png 

     

    5. Modify the point label

    a) The method for setting up general charts is applicable to setting labels. The character size of labels can be adjusted.

    27.png 

    b) You may set display method as [Floating], which means the label will only be displayed when the mouse is hovering over the point. In this case, a label is equivalent to a prompt box.

     

    6. Modify the line style

    a) Select [Line] to customize its colors.

    b) Opacity of lines is adjustable.

     

    c) The starting and finishing points of a line always turn on aperture by default. You can turn it off respectively.

     

     

    7. Set the background

    Select [BG] to turn off some special effects in the background: [Particle], [Meteor], [Gear], [Light Wipe], and [Bottom Layer]. The sky background is displayed in dark by default, which can be set as [None].

    33.png 

     

    8. Modify the column style

    a) Select [Column] to have it displayed in gradient color.

    b) The width and height of the column are adjustable.

     

    c) The aperture can be turned off to eliminate the aperture at the bottom of the column.

     

     

    9. Modify the column label

    Similar to the settings of point labels, the character size of columns can be adjusted.


    10. Modify the area style

    Select [Area] to customize the color of the area.

     

     

    11. Modify the area label

    Scale up the character size of the area label and modify the character color so as to tell it from the column label.


    12. Final preview

     

     

    13. Download the template

    Scene Switch_2.cpt


    IV. Drill-dwon Scene and Component Linkage

    In this part, your will learn how to create a dirll-down map in Scene and use the drill-down level to control data of other components in the same dashboard.

    The final result:

    • A map on the left shows the sales data of all provinces and a chart on the right plays the provinces with top 5 sales.

    • After clicking a province named Jiangsu in the map, the map drills down to this province and shows the sales data of its subordinate cities while the chart on the right changes the displayed data as cities in Jiangsu with top 5 sales.

    • If clicking China(Province) in the drill-down directory of the map, the map changes to display sales data of all provinces and the chart on the right changes accordingly.


    1. Insert components

    Create a new dashboard and drag two components to the canvas: one is Extended Chart-Scene and the other is Carousel Catalog Gear.


    2. Prepare data

    Create 3 datasets. Two of them is for creating a drill-down map in Scene and the other is for Carousel Catalog Gear.

    1) The source database table integrates province level data and city level data.

    2) SQL for dataset province

    SELECT * FROM drill_down_jiangsu
    WHERE [level] = "China(Province)"

    Preview dataset:

    3) SQL for dataset jiangsu

    SELECT * FROM drill_down_jiangsu
    WHERE [level] = "Jiangsu"

    Preview dataset:

    4) SQL for dataset other chart:

    SELECT * FROM drill_down_jiangsu
    WHERE [level] = '${region}'
    ORDER BY sales DESC
    LIMIT 5

    Set the default value of parameter region as China(Province).

    The statement ORDER BY sales DESC LIMIT 5 is to filter regions with top 5 sales.

    Preview dataset:


    3. Set boundary for the drill-down map

    1) Set map boundary as China(Province). In the left window, drag the boundary and  scroll the mouse to make the boundary be fully displayed and click Save as initial perspective.

     

    4. Set data for the drill-down map

    1) In tab Data, select Area > Drill Map and choose All levels are designated.

    2) Set data for 1st layer

    3) Set data for 2nd layer


    5. Set data for Carousel Catalog Gear


    6. Link the 2 components

    1) Add a hyperlink for map area and the hyperlink type is Current Form Object. After setting this hyperlink, the displayed area in the map can be used to control data in other charts.

     

    2) Set the hyperlink. Set the Form Object as chart1, which is the id of Carousel Catalog Gear (this id varies for different situations). Click [+] to add a parameter passing rule. The parameter that is controled is named region, and this is used to control the dataset other chart. The value passed to region is Area Name and you can choose it by clicking .

    3) If you only set the hyperlink for map area, the data of Carousel Catalog Gear cannot change back for all provinces when you click China(Province) in the drill-down directory. Therefore, you need to add a hyperlink for the drill-down directory in the same way.

    Note 1: If the two components are cell/floating elements in a cpt template, you shoud change the hyperlink type to Hyperlink: Linkage Cell or Hyperlink: Linkage Floating Elements.

    Snag_43597c5.png

    Note 2: Using Dynamic Parameters can also realize component linkage, however, this type of hyperlink will refresh the whole report each time you change the drill-down level. In other words, you will see that the Scene and other charts restart each time you change the drill-down level, and this harms the visual effects.


    7. Preview the result

    You will get the effect as show at the beginning.

     

    8. Mechanism

    1) When the map displays data for all provinces, the area name is China(Province) as indicated by the drill-down directory. Since this value is passed to parameter region, it helps to filter provinces with top 5 sales in dataset other chart.

    2) When the map is drilled down to Jiangsu, the area name changes to Jiangsu either. Similarly, by passing the value to parameter region, cities with top 5 sales become the result of dataset other chart.

    3) The two area name China(Province) and Jiangsu can be known in advance by checking the Geographic Information in the Decision-making Platform.


    9. Completed Template

    Drill-down Scene.frm

    Attachment List


    Theme: Chart
    • Helpful
    • Not helpful
    • Only read

    Doc Feedback