问题描述
我对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
仅此而已.准备好了:
这篇关于创建多维度交互图的工具建议的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!