创建多维度交互图的工具建议 [英] Tool Recommendation to create Interaction Map with multiple dimensions

问题描述

我对QLik/Sense，Big Query，Google Data Studio(及相关)有知识

I have knowledge in QLik/Sense, Big Query, Google Data Studio ( and related )

我需要创建一个包含多个点的地图，每个点都将显示数据库中的数据(与点相关)

I need to create a map with multiple points and each point will display data from the database (point related)

该表格看起来像这样:

+------------+---------------------------+-----------+---------+-------+
| Store Name | Store Location (Long/Lat) | Product   | Ordered | Sold  |
+============+===========================+===========+=========+=======+
| Store 1    | XXX,XXX                   | Product 1 | True    | False |
+------------+---------------------------+-----------+---------+-------+
| Store 2    | YYY,YYY                   | Product 1 | True    | True  |
+------------+---------------------------+-----------+---------+-------+
| Store 2    | YYY,YYY                   | Product 2 | False   | True  |
+------------+---------------------------+-----------+---------+-------+

因此，当您将鼠标悬停在商店2"商店的地图上时，您将看到仅带有以下内容的弹出框:

So when you hove over with mouse on the map at store "Store 2", You will see pop up box with only:

+------------+----------+-----------+
| Product 1  | True     | True      |
+------------+----------+-----------+
| Product 2  | False    | True      | 
+------------+----------+-----------+

并存储1:

+------------+----------+-----------+
| Product 1  | True     | False     |
+------------+----------+-----------+

我尝试过:

• Google Data Studio(限制一个维度，例如商店名称及其名称)
• Qlik限制为一维
• Google地图，更好，但我只能显示1种产品，而不能显示产品列表

任何建议，可以使用什么?

Any suggestions, what can be used?

推荐答案

在Qliksense中，这是最简单的.

In my opinion in Qliksense it is easiest.

首先只需加载Store和Product表并创建简单的数据模型:

First just load Store and Product table and create simple data model:

然后添加新图表(地图)并设置位置字段:

Then add new chart (Map) and set location fields:

添加新的计算尺寸:

=Product & ', Ordered: ' & Ordered & ', Sold: ' & Sold

仅此而已.准备好了:

这篇关于创建多维度交互图的工具建议的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！