How to Create as Customer Map
After Login (on the Dashboard tab) click on the "Add Chart" button in the "Create New Dashboard" dialog, or click on the plus (+) button in the "Edit Dashboard" dialog. The setting section has 8 parts namely:
1. Access the Dashboard
2. Choose the Chart Type
3. Add a Chart Tag
4. Add a Chart Title
5. Add a Chart Description
6. Add Legend Aggregation Column
7. Choose Legend Type
8. Add a Query
To start creating your Customer Map chart, you'll first need to access your dashboard. If you don't have a dashboard yet, you'll need to create one. Once you're in your dashboard, click on the "Add Chart" button if you're in the "Create New Dashboard" dialog, or click on the plus (+) button if you're in the "Edit Dashboard" dialog.
A dialog box will appear for you to select the type of chart you want to create. From the dropdown menu, select "Customer Map".
Next, you'll need to add a chart tag. This tag should be related to the Customer Map you're creating. For example, if you're creating a map for visits per customer, you might choose a tag like "visit_map".
Now, add a title for your chart. This title should represent what the chart is about. For example, if your Customer Map shows visits, you might choose a title like "Visits Per Customer".
It's always a good idea to add a description for your chart. This helps other users understand what the chart is about and what the query does. For example, "Nbr of Visits Per Customer."
Choose the column that you want to use for aggregating data in the legend. This choice will depend on the type of legend you select in the next step.
The legend aggregation column can be either:
- Numerical: Use a numerical column, such as num_visits, if you want to display a gradient-based legend showing a range of values. This option is ideal when you’re visualizing metrics that vary by quantity or intensity, like the number of visits per customer.
- Categorical: Use a categorical column, like customer_channel or category , if you want to display a legend based on specific categories. This is suitable for visualizing group-based metrics, where each category, like customer type or region, has its own color representation on the map.
You can create three different variations of the Customer Map using the legend type:
Choose the gradient legend type for numeric data. The legend aggregation column must be numeric, such as num_visits to show the number of visits per customer.
Example:
- Aggregator Column Used: num_visits
- Legend Type Selected: Gradient
- Query Used:
- Output:
Choose the categories legend type for categorical data. The legend aggregation column should be categorical, like customer_channel. The legend automatically assigns colors to each category.
Example:
- Aggregator Column Used: customer_channel
- Legend Type Selected: Categories (Automated)
- Query Used:
- Output:
Choose the categories legend type for user-defined categories. The legend aggregation column should be a category explicitly defined in the query, which allows you to set classifications and specify colors using hex codes.
Example:
- Aggregator Column Used: category
- Legend Type Selected: Categories (Defined)
- Query Used:
- Output:
Finally, you'll need to add a query that will fetch the data from the respective table. Ensure your query includes the following:
- Customer ID: Unique identifier for each customer.
- Latitude and Longitude: To plot each customer's location accurately on the map.
- Filters: Add filters such as user, team, and date as applicable.
Example Query:
1. Access the Dashboard
2. Choose the Chart Type
3. Add a Chart Tag
4. Add a Chart Title
5. Add a Chart Description
6. Add Legend Aggregation Column
7. Choose Legend Type
8. Add a Query
1. Access the Dashboard
To start creating your Customer Map chart, you'll first need to access your dashboard. If you don't have a dashboard yet, you'll need to create one. Once you're in your dashboard, click on the "Add Chart" button if you're in the "Create New Dashboard" dialog, or click on the plus (+) button if you're in the "Edit Dashboard" dialog.
2. Choose the Chart Type
A dialog box will appear for you to select the type of chart you want to create. From the dropdown menu, select "Customer Map".
3. Add a Chart Tag
Next, you'll need to add a chart tag. This tag should be related to the Customer Map you're creating. For example, if you're creating a map for visits per customer, you might choose a tag like "visit_map".
4. Add a Chart Title
Now, add a title for your chart. This title should represent what the chart is about. For example, if your Customer Map shows visits, you might choose a title like "Visits Per Customer".
5. Add a Chart Description
It's always a good idea to add a description for your chart. This helps other users understand what the chart is about and what the query does. For example, "Nbr of Visits Per Customer."
6. Add Legend Aggregation Column
Choose the column that you want to use for aggregating data in the legend. This choice will depend on the type of legend you select in the next step.
The legend aggregation column can be either:
- Numerical: Use a numerical column, such as num_visits, if you want to display a gradient-based legend showing a range of values. This option is ideal when you’re visualizing metrics that vary by quantity or intensity, like the number of visits per customer.
- Categorical: Use a categorical column, like customer_channel or category , if you want to display a legend based on specific categories. This is suitable for visualizing group-based metrics, where each category, like customer type or region, has its own color representation on the map.
7. Choose Legend Type
You can create three different variations of the Customer Map using the legend type:
a. Gradient (Numeric Values)
Choose the gradient legend type for numeric data. The legend aggregation column must be numeric, such as num_visits to show the number of visits per customer.
Example:
- Aggregator Column Used: num_visits
- Legend Type Selected: Gradient
- Query Used:
- Output:
b. Categories (Automated)
Choose the categories legend type for categorical data. The legend aggregation column should be categorical, like customer_channel. The legend automatically assigns colors to each category.
Example:
- Aggregator Column Used: customer_channel
- Legend Type Selected: Categories (Automated)
- Query Used:
- Output:
c. Categories (Defined)
Choose the categories legend type for user-defined categories. The legend aggregation column should be a category explicitly defined in the query, which allows you to set classifications and specify colors using hex codes.
Example:
- Aggregator Column Used: category
- Legend Type Selected: Categories (Defined)
- Query Used:
- Output:
8. Add a Query
Finally, you'll need to add a query that will fetch the data from the respective table. Ensure your query includes the following:
- Customer ID: Unique identifier for each customer.
- Latitude and Longitude: To plot each customer's location accurately on the map.
- Filters: Add filters such as user, team, and date as applicable.
Example Query:
Updated on: 12/11/2024
Thank you!