Building a Report with a ClickHouse Data Connector

Create a ClickHouse Data Connector, build a Data Store on top of it, and design a Business Report with advanced analytics using that Data Store.

Prerequisites:

• Access to the Data Center and Report Modules.

• ClickHouse connection details: Host, Port, HTTP Port, Username, Password, Database Name (dbname), and SSL Type.

• A valid SQL query you can run against your ClickHouse database.

---

Phase 1 — Create a ClickHouse Data Connector

1. Open the Apps menu → go to Data Center.

2. In Data Connectors, click Create +.

3. Choose ClickHouse as the connector type.

4. Enter:

   • Name: Workflow 2 (and optional Description)

   • Credentials: Host, Port, HTTP Port, Username, Password, Database Name (dbname)

   • SSL Type

5. Click Save.

   

• You’ll see a confirmation that the Data Connector was created successfully.

Phase 2 — Create a Data Store on the Connector

1. From the newly created connector’s ⋯ (three dots) menu, select Create Data Store.

2. Name the Data Store: self_service_02.

3. Query: Paste/write the SQL that defines your dataset → click Next.

   
4. Dimensions & Measures:

   • Set the Expected Joining Date as the Time Field.

   • Set Expected CTC as a Measure.

   • Click Next.

5. Hierarchy Definition:

   • Drill Definition (time): Add Expected Joining Date.

   • Drill Definition 1: Add Source, Skills, Team, Designation.

   • Click Next → Finish.

• The Data Store is created and visible in the list.

Phase 3— Create a Business Report from the Data Store

1. Open Apps → Report Module.

2. Create Report:

   • Name: e.g., Workflow 2 (add a Description if desired).

   • Select the workflow2 Data Store → click Create Report.

View 1 — Total Offered CTC by Skill (Mixed Chart)

1. Choose Mixed Chart.

2. Drag Skill (dimension) and Offered CTC (measure) onto the chart.

3. Customize: sorting/order-by, bar size, display names.

4. Rename the view → Save.

View 2 — Team-wise Total Experience (Pie)

1. Choose Pie Chart.

2. Drag Team (dimension) and Experience (measure).

3. Order by Team (ascending).

4. Rename the view → Save.

View 3 — Previous History of Employees (Data Grid)

1. Choose Data Grid.

2. Drag dimensions Name, Previous Organization; measure Previous CTC.

3. Sort Name ascending; update column display names.

4. Rename the view → Save.

View 4 — Team-wise Offered CTC (Treemap)

1. Choose Treemap Chart.

2. Drag Team (dimension) and Offered CTC (measure).

3. Order by Team (ascending).

4. Rename the view → Save.

View 5 — Monthly Salary by Designation (Mixed Chart)

1. Choose Mixed Chart.

2. Drag Designation (dimension) and Monthly Salary (measure).

3. Sort Designation ascending; set record limits and bar size.

4. Rename the view → Save.

View 6 — Compare Avg Previous CTC vs Offered CTC (Mixed Chart)

1. Choose Mixed Chart.

2. Drag Previous Organization (dimension); measures Previous CTC and Offered CTC.

3. Sort/order by Previous Organization, set limits, and bar size.

4. Rename the view → Save.

---

Phase 4 — Add Advanced Analysis

Timeline Play (dynamic time playback)

1. In the right pane, click Analyse → Timeline Play.

2. Set Time Dimension (e.g., Expected Joining Date), Interval = Monthly, Start/End dates, and Delay.

3. Start Timeline Play to animate charts over time.

Interactions (cross-filtering between views)

1. In the right pane, click Edit → Interaction.

2. Enable Interactions and select the target charts to link.

3. Save the view.

   • Example: Clicking a Skill updates the Total Offered CTC by Team chart.

Drill-Through (Monthly Salary by Joining Date)

1. Create a chart with Monthly Salary (measure) and Expected Joining Date (dimension).

2. Sort by Joining Date ascending → rename the view → Save.

3. Double-click the view, select a bar, and choose Drill Through.

   • All months display; click a month to view detailed dates.

     

Outcome

You have:

• A ClickHouse Data Connector

• A production-ready Data Store (workflow2)

• A multi-view Business Report with Timeline Play, Interactions, and Drill-Through enabled

Use Save frequently and adjust chart properties (labels, legends, colors) to meet your presentation standards.