xMII Fixed Query - Display Template Usage

[Former Member]

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.

[Former Member · Accepted solution]

Blizz

Wat output did u hv from the DT? No Data or wat?

Try it as follows and tell me wat u hv in output

<b>Data Mapping</b>

Value Columns: TotalPersonInCity

Label Columns: (BLANK)

Description Column: (BLANK)

Datalink Column: (BLANK)

Axis Label Column: City

Axis Value Column: (BLANK)

Min Range: (BLANK)

Max Range: (BLANK)

Regards

Som

[Former Member · Accepted solution]

Hi,

I am getting the output but its not in the right shape.

<a href="http://lh4.google.com/mehta.dheeraj/RuZehk0zd7I/AAAAAAAAAFk/UZI-Pe5YVXY/a.gif">Output using Dynamic Page Generator</a>

& this output is with the changes you suggested.

[Former Member · Accepted solution]

Blizz

In the DT Editor, go to the tab <b>Pen Details</b>

then check the check boxes both (Auto Scale & Server Scale)

Also check the check box - Global Auto Scale

Then see wat u hv seen.

Use those scale setting to see the exact scaling in the DT

Regards

Som

[Former Member · Accepted solution]

Thanks man.. I was wondering earlier what the hell is a pen..

One more question.. Whenever I make some changes in DT and click 'Generate Page', it shows the previous details instead of the new changes. Seems like some cache trouble with the DT.

You got any idea on this?

[Former Member · Accepted solution]

Blizz

U hv to repeatedly clear the ClassLoader, then refresh the browser after making any changes in DT. Then start going to generate page with selected QT & DT.

Regards

Som

[Former Member · Accepted solution]

Thanks a lot.