Populate Grid - flip rows and columns

[TracySchloss]

I have two years' worth of county based demographic statistics.

I have the same information for each year.  For example:  totalPopulation, PopulationOver18, Population17_44, Population45_64 etc

On a map click event for the  county layer, I've been asked to display it with years for the columns and rows for the population breakouts,  This format is my question. 

I typically use dGrid.  It seems like I can manipulate the data prior to populating it, but I can't quite wrap my brain around how to go about this.

Example:

COUNTY NAME

Statistic	Year 1	Year2
Total Population	123	145
Population Over 18	56	66

I don't know if this is a true pivot table, or if this is just a 'turning data on it's head' sort of format.  

[RickeyFight]

Tracy,

I think I understand what you are asking.

You want a way to show in the table the population that is under 18 over 18 but below 50 and so on?

If so what does your data look like?

[TracySchloss]

Not really, no.  This is the kind of data I have and typically you would show you data like this:

Field	Value
County	Cooper
TotalPopulation2015	123
TotalPopulation2030	145
2015_PopulationUnderAge17	18
2030_PopulationUnderAge17	15
2015__PopulationAge17_44	235
2030_PopulationAge_17_44	190

The question is how I can change this format to something more like I showed in my original post. 

[RickeyFight]

Are you opposed to making a new layer?

If not do something like this:

If you are I am not sure how to manipulate the data in Javascript.

[SteveCole]

Obviously you have 2 columns for the years but how many rows are we talking? You might as well create an HTML table & use SPAN tags w/ IDs to just populate the table using element.innerHTML() once you have a map click event. & access to the data values A pain in the butt to initially code but it would work.

[TracySchloss]

The client isn't quite certain about the final rows, but I'd say around a dozen, tops.  I thought about making a plain table, especially since the output format is nothing like how the data will be stored in a table.  Makes it tough to have meaningful events associated with it.

I've used row Renderers before.  I wonder if I could take advantage of that to build a table.  Generally I'm making something that looks like a paragraph with divs, but I guess there's no reason why it couldn't be a table instead as long as I had the HTML format right. 

[SteveCole]

HTML Table template:

<table border="1"  cellpadding="3" cellspacing="3">
  <tr>
  <td>County:</td>
  <td>2015</td>
  <td>2030</td>
  </tr>
  <tr>
  <td>Total Population:</td>
  <td><span id="lblPop2015"></span></td>
  <td><span id="lblPop2030"></span></td>
  </tr>
  <tr>
  <td>Population Under 17:</td>
  <td><span id="lblPopUnder17_2015"></span></td>
  <td><span id="lblPopUnder17_2030"</span></td>
  </tr>
  <tr>
  <td>Population 17-44:</td>
  <td><span id="lblPop17_44_2015"></span></td>
  <td><span id="lblPop17_44_2030"></span></td>
  </tr>
</table>

JS:

countyLayer.on("click", function(evt) {
    fullAttrib = evt.attributes;

    document.getElementById("lblPop2015").innerHTML = fullAttrib.TotalPopulation2015;
    document.getElementById("lblPop2030").innerHTML = fullAttrib.TotalPopulation2030;
    document.getElementById("lblPopUnder17_2015").innerHTML = fullAttrib.2015_PopulationUnderAge17;
    document.getElementById("lblPopUnder17_2030").innerHTML = fullAttrib.2030_PopulationUnderAge17;
    //etc etc etc
});

[SteveCole]

AAAARRRRGGGGHHHH. I *HATE* this stinking forum software.

My HTML got eaten up. Here's a screenshot of what it SHOULD have looked like:

[TracySchloss]

It seems like there's been issues with the forum the past couple of days.  Yesterday I wasn't able to reply to any thread until the end of the day and this AM it was just down.

I'm going to give that a try, along with my renderRow idea.   It seems like I might be able to stuff some of this into an array of fields names and step through it that way.  It would save hard coding all those fields.  If I have to do it that way, it would be manageable, but tedious.    I haven't tried to manipulate the output of the QueryTask with SQL, but then I've never needed to before. 

Right now, this is largely a theoretical question.  I don't have the services started up yet to code against while we finalize the specs for this project.  I'll have to remember to come back later and update this post.  I just hate to tell a customer that something is possible, when I've never done it before. 

[SteveCole]

My only other random thought was if you could use a SQL query to craft the response from your queryTask in the format you want. I know ESRI typically says "any standard SQL query" works but we all know that's not true..