Skip to Content
0
Former Member
Sep 11, 2007 at 07:58 AM

xMII Fixed Query - Display Template Usage

22 Views

I am totally new to xMII and trying to get a basic idea of it. Here, I am posting a small issue for which i seek your help.

I have two tables:

Table A:

<b>id city country</b>

Table B:

<b>id person city_id</b>

I am using a fixedquery which is working fine and giving me the resultdata as:

<b>TotalPersonInCity City Country</b>

(Here TotalPersonInCity is count(x) for table B inner join with Table A on city_id)

I saved this as fixedQuery1 and tried creating a display template for it.

dt_fixedQuery1:

<b>General-></b>

Chart Type: Bar

<b>Data Mapping-></b>

Value Columns: TotalPersonInCity

Label Columns: TotalPersonInCity

Description Column: Country

Datalink Column: (BLANK)

Axis Label Column: City

Axis Value Column: City

Min Range: (BLANK)

Max Range: (BLANK)

<b>Expected Outcome:</b>

X-Axis Showing City Names and Y-Axis Showing Number of People in the City.

Which obviously i am not getting 😊

Please help me out.