...
Create a performance view screen to query sales quantity/cost/amount, etc., by store and region
Goal screenTarget Screen |
|---|
 Image Removed Image Added
|
Step 1. Basic Practice
By using a pre-defined i-META file, you can create a list-style query screen with just the layout of query items.
Let's create a query screen using items such as store region, store type, and sales quantity/amount.
 Image Removed Image Added
|
| Multimedia |
|---|
| name | 3. 지점별 매출실적(List)(기본).mp4 |
|---|
| 위젯 연결기 |
|---|
| width | 920 | autostart | true
|---|
| url | https://www.youtube.com/watch?v=ZQRJsFvy248 |
|---|
| height | 100%600 |
|---|
|
|
Step 2Step2. Advanced Practice
Let's analyze the data in various ways by using features such as sorting, filtering, summing, and unit conversion on the queried data.
| 응용하기Apply | 동영상Video |
|---|
- Sorting
: Querying data with high sales performance
- Filtering
: Querying sales performance of a specific store
- Subtotal
: 매장지역, 매장구군, 매장유형별
소계 표현하기
Express subtotals by Region, SubRegion, and Store Type
- Layout
: 매장유형, 매장지역, 매장구군별
데이터 표현하기
Display data by Store Type, Region, and SubRegion
- Unit Scale
: 매출금액 백만원 단위 표시하기Display Sales Cost in millions
- Calculation
: 매출단가 계산 컬럼 추가하기
| Multimedia |
|---|
| name | 4. 지점별 매출실적(List)(응용)_수정2.mp4 |
|---|
- Add a column to calculate the sales unit price
| | 위젯 연결기 |
|---|
| width | 650 | autostart | true
|---|
| url | https://www.youtube.com/watch?v=NvK_n9OEwCc |
|---|
| height | 100%600 |
|---|
|
|