Started as a simple charting tool for monitoring a snow depth near the owner’s country house in Norway, Highcharts quickly became one of the most popular visualization libraries. It provides a lot of great built-in interactive features and is easy to use.In this tutorial we are going to build a simple e-commerce dashboard with Cube.js and Highcharts. We’ll use the main Highcharts library, as well as Maps, Stock, and Solid Gauge modules. Please keep in mind that Highcharts libraries are available under different licenses, depending on whether it is intended for commercial/government use, or for personal or non-profit projects. Make sure to check its . license page Below, you can see the demo of the dashboard that we’re going to build. You can find and . a live demo here the source code is available on Github To implement this example, we’ll need: Database (we will use PostgreSQL) with sample data Cube.js backend to handle communications between our database and the frontend The frontend application (we will build one with React) Analytics Backend We’re going to use a PostgreSQL database and an example e-commerce dataset. Use the following commands to download and import the example dataset. $ curl http: $ createdb ecom $ psql --dbname ecom -f ecom-dump.sql //cube.dev/downloads/ecom-dump.sql > ecom-dump.sql Next, let’s install the Cube.js CLI and create a new project. $ npm -g install cubejs-cli $ cubejs create highcharts -d postgres Cube.js uses environment variables inside the .env file for configuration. Update the contents of the .env file with your own database credentials. CUBEJS_DB_NAME=ecom CUBEJS_DB_TYPE=postgres CUBEJS_API_SECRET=SECRET Now, let’s start with the Cube.js backend. $ npm run dev At this step, you can find the Cube.js playground at . http://localhost:4000 Here, you can see all the tables from our database and we can choose any of them to generate the schema. concept is based on multidimensional analysis and should look familiar to those with experience in OLAP cubes. The Cube.js Data Schema The two main entities are measures and dimensions: are ”as is” properties that we get from our database, but are results of aggregation operations like count, sum, average, and others. dimensions measures In this example, we need an orders and users table. Please, check it and click “Generate Schema.” Cube.js will then generate Orders.js and Users.js files inside the schema folder. Cube.js data schema is javascript code and can be easily edited. You can also , if needed. dynamically generate schema Let’s update the schema/Users.js file. We’ll keep only state, id dimensions, and count measure because we’ll need to use them in our example. cube( , { : , : { : { : , : }, : { : , : , : } } }); `Users` sql `SELECT * FROM public.users` dimensions state sql `state` type `string` id sql `id` type `number` primaryKey true That’s it for our backend. We’ve configured the database and created the Cube.js. backend. Now, we’re ready to start working on our frontend application. Frontend Dashboard with Highcharts Let’s generate our app with Cube.js templates. Navigate to the Dashboard App tab and select “Create custom application” with React and Ant Design. It will take some time to create a dashboard app and install dependencies. Once it is finished, you should see the dashboard-app folder inside your project’s folder. Next, let’s install the dependencies we’ll need. Run the following commands in the dashboard-app folder. $ cd dashboard-app $ npm install --save highcharts highcharts-react-official @highcharts/map-collection The command above installs the following dependencies: . Highcharts . Highcharts React wrapper . Highcharts map collection for our map chart wrapper Feel free to remove all the files inside the src folder and the page folder, as well as update the dashboard/index.js file with the following content. React ; ReactDOM ; ; App ; * serviceWorker ; ReactDOM.render( <App></App> import from 'react' import from 'react-dom' import './index.css' import from './App' import as from './serviceWorker' < > React.StrictMode , document.getElementById('root') ); serviceWorker.unregister(); </ > React.StrictMode Our application will have the following structure: App as the main app component Dashboard component that stores data and manages the app state Map, Line, Stock, and other chart components that manage chart render according to applications data and state. Let’s create the <Dashboard /> component in the dashboard-app/src/components/Dashboard.js file with the following content. (We’ll create the <Map /> component later): React ; { Layout } ; { useCubeQuery } ; ; Dashboard = { { resultSet } = useCubeQuery({ : [ ], : [ ], : [ { : , : , }, ], }); (!resultSet) { “Loading…”; } data = regions.tablePivot().map( [item[ ], (item[ ])]) ( <Map data={data} /> </Layout> import from 'react' import from 'antd' import from '@cubejs-client/react' import Map from './Map' const => () const measures 'Orders.count' dimensions 'Users.state' timeDimensions dimension 'Orders.createdAt' dateRange 'last year' if return const => item 'Users.state' parseInt 'Orders.count' return < > Layout ); }; export default Dashboard; In the above snippet, we did several things. We imported React hook first. useCubeQuery { useCubeQuery } ; import from "@cubejs-client/react" Next, to render the amount of orders in each state, we need to change the data into Highcharts’ format, where the first element is the state key and the second element is the value. [ [ , ], [ , ], [ , ], [ , ], [ , ] ] "us-ca" 967 "us-ny" 283 "us-wa" 239 "us-il" 205 "us-tx" 190 We’re using to access data returned from the backend and to prepare it for rendering. resultSet.tablePivot() data = regions.tablePivot().map( [item[ ], (item[ ])]) const => item 'Users.state' parseInt 'Orders.count' Now, we’re ready to pass our data to the Map chart. Let’s create a new dashboard-app/src/components/Map.js file with the following content. React, { useState, useEffect } ; Highcharts ; HighchartsReact ; highchartsMap ; mapDataIE ; highchartsMap(Highcharts); staticOptions = { : { : , }, : { : , }, : { : , : , }, : { : , }, : { : , : , }, : { : , : , }, : [ { : , : mapDataIE, : , : , : , : , : , : { : , : , : , }, : { : { : , : , }, }, }, ], }; ({ data }) => { [options, setOptions] = useState({}); useEffect( { setOptions({ ...staticOptions, : [ { ...staticOptions.series[ ], : data, }, ], }); }, [data]); ( import from 'react' import from 'highcharts' import from 'highcharts-react-official' import from 'highcharts/modules/map' import from '@highcharts/map-collection/countries/us/us-all.geo.json' const chart styledMode true credits enabled false title text 'Orders by region<small>Highcharts Map API</small>' useHTML true colorAxis min 0 tooltip headerFormat '' pointFormat ` <b>{point.name}</b>: {point.value}` colorAxis minColor '#FFEAE4' maxColor '#FF6492' series name 'Basemap' mapData borderColor '#FFC3BA' borderWidth 0.5 nullColor '#FFEAE4' showInLegend false allowPointSelect true dataLabels enabled true format '{point.name}' color '#000' states select borderColor '#B5ACFF' color '#7A77FF' export default const => () series 0 data return ); }; < = = ' '} = /> HighchartsReact highcharts {Highcharts} constructorType { mapChart options {options} Inside the Map.js file, we imported useState, useEffect hooks, and a bunch of Highcharts components. Then, we defined chart options based on specs. Highcharts Map API In staticOptions, we can set map styling, source, data, event handlers, and other options. Highcharts has a wide selection of to use. We’ve picked . SVG maps this one Lastly, we merged our staticOptions and props.data and then passed it to the Highcharts component. That’s all for our <Map/> component. Now, we just need to update the ‘dashboard-app/App.js’ to include the <Dashboard /> component: + Dashboard ; - <Layout.Content>{children}</Layout.Content> + <Dashboard /> import from './components/Dashboard' - < /> Header …and we’re ready to check out our first chart! Navigate to in your browser, and you should be able to see the map chart that we’ve just built. http://localhost:3000 A similar workflow can be used to create other chart types, as in the GIF below. Define the static chart options, according to Highcharts API . documentation Add data to options.series. Pass options to the Highcharts component. The full source code of the above dashboard is , and you can check . available on Github the live demo here I hope you’ve found this tutorial helpful. If you have any questions or any kind of feedback, please let me know in this . Slack channel Previously published at https://cube.dev/blog/react-highcharts-example/
