How add multiple dimensions and measures in a table

kuntal_bhowmick

Hi All,

I need to show data like below table in a dashboard:

Country	City	Population(MM)	Country_Population(MM)	Avg_Salary(K)
UK	London	35	90	200
	Manchester	25	90	150
	Liverpool	30	90	165
India	Mumbai	100	200	125
	Chennai	75	200	100
	Indore	25	200	55

I have tried Pivot Table/Cross Tables which is available in Charts section but those do not allow to add mutiple dimensions such as Country and City both. And I am not able to add multiple measures (Population and Avg_sal) and show them in plain tabular format.

Could you please let me know how I can create this in Dataiku

Clément_Stenac

Hi,

Dataiku does not support multiple levels of dimensions on pivot tables.

You would need to do that using a custom webapp for example, or by exporting data to another visualization software