---
# System prepended metadata

title: QuickSight Shop Detail
tags: [AWS, Quick Sight]

---

# QuickSight (Shop Detail)

# 增加計算欄位(Calculation Field)
![image](https://hackmd.io/_uploads/H15og4HNR.png)

## AC

   
-   公式的部分輸入
:::info
{營業額}/{來客數}
::: 

   


![image](https://hackmd.io/_uploads/B1vWSYuWA.png)




## 男女


-   公式的部分輸入
:::info
        ifelse({性別}=1,'男','女')
:::     

![image](https://hackmd.io/_uploads/B1q6BtOZC.png)


## 特點是把Field 從上半部移到左半部(方便拖拉)
![image](https://hackmd.io/_uploads/HJUF-BZIa.png)
## 原來的效果新的設定圖如下
### Visual 1(營業處/營業額),長條圖顯示
![image](https://hackmd.io/_uploads/HkVJzHbLp.png)
### Visual 2(男女/營業額),長條圖顯示
![image](https://hackmd.io/_uploads/HJiJmrWIa.png)
### Visual 3(男女-客層/營業額),長條圖顯示
![image](https://hackmd.io/_uploads/rkmwXS-Up.png)
### Visual 4(業績樞紐分析)
![image](https://hackmd.io/_uploads/HyykESW8a.png)
### Visual 5,地圖顯示不同營業處分店營業額
![image](https://hackmd.io/_uploads/SyTBNrZ8a.png)
#### 增加Action,點選營業處店家,顯示營業處下面的店家營業資訊
先選Action
![image](https://hackmd.io/_uploads/BkEtvDFQC.png)
在設定內容
![image](https://hackmd.io/_uploads/By9sDwKmC.png)
#### 如何重制Filter
畫面的上方有一個 Filter(在需要移除的條件上面按X)
![image](https://hackmd.io/_uploads/rkK10DKQ0.png)



### Visual 6,用圓餅圖呈現產品分層銷售業績
![image](https://hackmd.io/_uploads/SkD2VH-L6.png)
### Visual 7,用熱力圖呈現客層/營業處的購買力
![image](https://hackmd.io/_uploads/BycPSSZLp.png)

