• Hello Fabrik Community

    Fabrik is now in the hands of the development team that brought you Fabrik for Joomla 4. We have recently transitioned the Fabrik site over to a new server and are busy trying to clean it up. We have upgraded the site to Joomla 4 and are running the latest version of Fabrik 4. We have also upgraded the Xenforo forum software to the latest version. Many of the widgets you might have been used to on the forum are no longer operational, many abandoned by the developers. We hope to bring back some of the important ones as we have time.

    Exciting times to be sure.

    The Fabrik 4.0 Official release is now available. In addition, the Fabrik codebase is now available in a public repository. See the notices about these in the announcements section

    We wish to shout out a very big Thank You to all of you who have made donations. They have really helped. But we can always use more...wink..wink..

    Also a big Thank You to those of you who have been assisting others in the forum. This takes a very big burden off of us as we work on bugs, the website and the future of Fabrik.

Fusion Charts visualization

  • Views Views: 22,711
  • Last updated Last updated:
  • Installation Tasks​

    Install the Fabrik Fusion Charts plug-in​
    Download and install
    Create a folder fusioncharts-suite-xt at ./plugins/fabrik_visualization/fusionchart/libs

    Installing Fusion Charts​
    (Fabrik3.9+) This plugin works with the FusionCharts XT product. You can obtain a fully working trial version from https://www.fusioncharts.com/download/fusioncharts-suite-xt?framework=php

    Unzip fusioncharts-suite-xt.zip, upload the entire package to the 'libs/fusioncharts-suite-xt' folder in the Fabrik Fusion Chart plugin, such that the fusioncharts.php wrapper is at ./plugins/fabrik_visualization/fusionchart/libs/fusioncharts-suite-xt/integrations/php/fusioncharts-wrapper/fusioncharts.php.
    Make sure to have correct folder access settings (755 for fusioncharts-suite-xt).

    Then select the fusioncharts-suite-xt folder in the FusionChart Library selection in the Graph Atttributes tab, If you have a licensed copy or different versions, you can upload them to the same libs location and select the version you want to use.
    upload_2020-6-11_21-20-42.png


    Repeatable Options​

    For chart examples, fusionchart Options, settings, best practice of charts etc. see https://www.fusioncharts.com/fusioncharts
    index.php
    index.php

    • Connection - the Fabrik connection containing the list you wish to render
    • List - the list containing the data you wish to chart
    • Element - the element which contains the data to plot
    • Chart label - if you want a legend on your chart enter a label here
    • Element Type
      • data set
      • trend line - Trend lines are horizontal/vertical lines spanning the chart canvas which aid in interpretation of data with respect to some pre-determined value.
    • Colour - Sets the background colour for the canvas. HEX colour code WITHOUT "#" at the beginning (e.g. ff0000). FusionCharts Attribute: canvasBgColor
    • Alpha
    • Label Step Ratio
    • Label
    • Axis measurement unit
    • Dual Y Label
    • Multi Axis Attrs
    • Where - (Like a list pre-filter) Add a where SQL statement to filter the table results. E.g. name = 'rob'. You may use {Placeholders} for query string args, but if you do, don't use quotes, as we automagically urldecode, sanitize and quote any query string substitutions, so just foo={bar} becomes foo='whatever bar qs arg was'.
    Graph Attributes​
    For details see tooltips (hover the labels), for examples, fusionchart attributes, settings, best practice of charts etc. see https://www.fusioncharts.com/fusioncharts
    • Version
    • Chart type
    • Chart Palette
    • Palette Colors
    • Width
    • Height
    • Template
    • Loading Message
    • Parsing Data Message
    • No Data Message
    • Custom attributes
    Trend Line specific attributes​
    For details see tooltips (hover the labels), for examples, fusionchart attributes, settings, best practice of charts etc. see https://www.fusioncharts.com/fusioncharts
    • Label - The label to use for this element
    • Start Value
    • End Value
    • Show on top
    • Is a Zone
    Background Properties​
    For details see tooltips (hover the labels), for examples, fusionchart attributes, settings, best practice of charts etc. see https://www.fusioncharts.com/fusioncharts
    • Color
    • Alpha
    • Image
    Canvas or Pies Properties​
    For details see tooltips (hover the labels), for examples, fusionchart attributes, settings, best practice of charts etc. see https://www.fusioncharts.com/fusioncharts
    • Color
    • Alpha
    • Border color
    • Border Thickness
    Chart and Axis Titles​
    For details see tooltips (hover the labels), for examples, fusionchart attributes, settings, best practice of charts etc. see https://www.fusioncharts.com/fusioncharts
    • Caption
    • Sub-caption
    • x-Axis name
    • y-Axis name
    Chart Numerical Limits​
    For details see tooltips (hover the labels), for examples, fusionchart attributes, settings, best practice of charts etc. see https://www.fusioncharts.com/fusioncharts
    • y-Axis Min value
    • y-Axis Max value
    General Properties​
    For details see tooltips (hover the labels), for examples, fusionchart attributes, settings, best practice of charts etc. see https://www.fusioncharts.com/fusioncharts
    • Show Names
    • Show Values
    • Show Limits
    • Rotate Names x-Axis
    • Slant Names x-Axis
    • Rotate Values
    • Values inside
    • Animation - Whether the animation is to be played or whether the entire chart would be rendered at one go. FusionCharts Attribute: animation
    • Column Shadow
    • Num. Visible
    Font Properties​
    For details see tooltips (hover the labels), for examples, fusionchart attributes, settings, best practice of charts etc. see https://www.fusioncharts.com/fusioncharts
    • Base Font
    • Base Font Size
    • Base Font Color
    • Out-Canvas Base Font
    • Out-Canvas Base Font Size
    • Out-Canvas Base Font Color
    Number Formatting Options
    For details see tooltips (hover the labels), for examples, fusionchart attributes, settings, best practice of charts etc. see https://www.fusioncharts.com/fusioncharts
    • Number Prefix
    • Number Suffix
    • Format Number
    • Format Number Scale
    • Decimal Separator
    • Thousand Separator
    • Decimal Precision
    • Division Line Decimal Precision
    • Limits Decimal Precision
    Zero Plane​
    For details see tooltips (hover the labels), for examples, fusionchart attributes, settings, best practice of charts etc. see https://www.fusioncharts.com/fusioncharts
    • Thickness
    • Color
    • Alpha
    Divisional Lines (Horizontal)​
    For details see tooltips (hover the labels), for examples, fusionchart attributes, settings, best practice of charts etc. see https://www.fusioncharts.com/fusioncharts
    • Number
    • Color
    • Thickness
    • Alpha
    • Show Value
    • NoYes
    • Alternate Horizontal Grid Color
    • Alpha
    Divisional Lines (Vertical)​
    For details see tooltips (hover the labels), for examples, fusionchart attributes, settings, best practice of charts etc. see https://www.fusioncharts.com/fusioncharts
    • Number
    • Color
    • Thickness
    • Alpha
    • Alternate Vertical Grid Color
    • Alpha
    Hover Caption Properties​
    For details see tooltips (hover the labels), for examples, fusionchart attributes, settings, best practice of charts etc. see https://www.fusioncharts.com/fusioncharts
    • Show Caption
    • Background Color
    • Border Color
    • Separator character
    Chart Margins​
    For details see tooltips (hover the labels), for examples, fusionchart attributes, settings, best practice of charts etc. see https://www.fusioncharts.com/fusioncharts
    • Left Margin
    • Right Margin
    • Top Margin
    • Bottom Margin

    Simple example​


    Assuming a Fabrik list "Parties" with id element, party names (name) and percentages of votes (datavalue)
    upload_2022-2-25_13-4-31.png

    In your fusionchart visualization set
    upload_2022-2-25_13-6-9.png

    upload_2022-2-25_13-8-4.png

    upload_2022-2-25_13-7-7.png

    all other Options are default.
    You'll get
    upload_2022-2-25_13-8-55.png


    Example Options:
    Where: [ id > 3 ] will show only columns for "Party4" and "Party5"
    Where: [ 1=1 order by datavalue ] will show the columns ordered by percentages
Back
Top