Detailed Values by Date (No Aggregation) for Two Metrics
Overview
Build a report displaying two metrics in one workspace.
Data Source
- Tables:
bi.ex_net1.m
andbi.im_net1.m
Steps
- Drag-and-drop both tables to Canvas area
- Select
Inner Join
, specifyTime
andEntity
as equal fields:
- Click Sheet 1
- Click OK to acknowledge the warning about limitations
- Drag-and-drop
Datetime
onto the columns field (you can use any ofDatetime
), change from YEAR aggregation toExact Date
- Drag-and-drop both
Value
onto the rows field, change from SUM aggregation toDimension
- Specify color:
Marks
>Value
(you can use any ofValue
) >Color
- Specify shape:
Marks
>Value
(you can use any ofValue
) > drop-down >Shape
Results
Compare the two metrics: