In order to create grouped line chart report, you have to follow certain steps which are below.
- Login into Helical Insight application
- Create datasource and on top of that datasource create metadata by selecting required tables and columns
Steps in order to achieve your requirement :
- Click on “Reports” tab in order to open adhoc interface
- Click on “Connect to Metadata” button in order to connect to metadata which you have created.
- Once you will connect to metadata, you will able to see all tables/columns which are part of your metadata selection.
- Now drag and drop columns in order to generate report.
Note : Follow this order while dragging columns. First drag date column, then name column and at last price column
- Now click on Generate to view the data rows of your selected columns
- Now search for “Grouped Bar” visualization.
- This will generate multibar chart of your data.
- In order to make this multi bar into multi line, Click on “EDITOR” tab
- First option is JS Editor.
- Paste below lines of code in the editor :
- Once you place the code click on “Inject”. This will apply your script
- Now again generate the report
Hope this helped you.