Hi Gautham,
- 1. Bar Chart:
Comparison of similar measurements
Ex.
a) Actual vs. budget- money to money. Quarter to Quarter
b) Time to Time
c) Top N- categorized values (sales reps, customers etc) avoid: comparisons with different units ($ and Qty)
- 2. Line chart:
Measurements to follow its moments or comparisons among items
- Ex. a) Performance trends- amount of moment over time
b) Two Dimension comparisons- Annual comparisons over month
- 3. Combo Charts:
Comparisons for multi measurements Ex. Two measurements- currency amount and quantity or amount percentage two axis- different measurements on left and right axis two or more axis: split axis horizontally
- 4. Radar chart:
comparisons of high level groups one or two measurements- sales and profit avoid- a dimension with many values
5. Gauge chart:
Ratio of measurements
a)Percentages- margin, quota achieved, year-tot
b) Date vs last YTD. Avoid: actual amounts
- 6. Mekko chart:
Data using variable width bars
a) 3D measurement chart- Amount, Quantity and no. of customers
b) Market analysis.
- 7. Scatter Chart:
Measurement acts as dimensions (3D Chart)
a) 3D measurement chart- Amount, Quantity and no. of customers
b) Map chart- see sales on Geographical map
8. Grid Chart:
2 or 3 Dimensions with a measurement
a) Multi-cross dimensional measurements
b) amounts over- region and product and over time
9. Pie Chart:
Visual Distribution measurements
- Ex.
a) what contributes how to the whole- regional sales
b) yes/no analysis
- 10. Funnel chart:
Dimension that contain an expiration time line
- Ex.
A) how much is the most aging element
b) Sales opportunities
c) Product Inventory Expressions
- 11.Block chart:
Distribution measurements within multi dimensions
Ex.a) what contributes how to whole and within each segments
b) sales contribution per country
- 12. Straight Table:
One dimension with multiple measurements
Ex. a) KPI overview- cyclic group dimensions with sales Qty , margin
b) Sort in any no. of columns (no grouping)
- 13. Pivot table:
Multi dimensions with one or more measurements
a) Grouping of dimensions
b) Dimensions across the table and displaying sub totals First sorted value: It returns the first value of expression sorted by corresponding sort weight. Sort weight should be a numeric value.
Uses:
a) Get the latest field value based on time stamp
b) Bigger customer for each product category
c) Find the min/max values and extract related field
d) Compare highest and second value
e)look up min/max value within range.
Hope it will helpful
.png "Luminary Alumni"){kind=icon}