Visualisation for 100,000 customers

[mickartik]

H‌i Experts,

Recently in an interview, I was asked to suggest a chart; except straight table; for showing profit and sales for customer dimension, with customer count more than 100,000.

Any siggestions.

Regards,

Kartik

[tajmohamed30]

You can say the chart type: Pivot Table which has no limit

If asked for difference then,

Straight table: Good for sorting

Pivot table: used for grouping and sub-totals of the expression and can make column to rows and vice versa

Regards

Taj Mohamed

[its_anandrjs]

You can use the Dynamic table for this (adhoc Table) where you can bucket this customers in particular categories

Ex:- age group, Region of the customer etc it depends on your data base.

Hope this helps

Regards

Anand