Merge “Finds by Country“ and “Finds by State“

[thcyron]

What about merging these two tables and have them look like this:

+---------------+------------------+--------+------------+
| COUNTRY       | STATE            | FINDS  | PERCENTAGE |
+---------------+------------------+--------+------------+
| Germany       | Bayern           |     10 |      50.0% |
|               +------------------+--------+------------+
|               | Sachsen          |      5 |      25.0% |
|               +------------------+--------+------------+
|               | Berlin           |      1 |       5.0% |
+---------------+------------------+--------+------------+
| United States | New York         |      2 |      10.0% |
|               +------------------+--------+------------+
|               | Texas            |      1 |       5.0% |
+---------------+------------------+--------+------------+
| Greece                           |      1 |       5.0% |
+---------------+------------------+--------+------------+

[agorf]

Good idea. However, this way you don't have a total for countries that have states. Unless we have something like this:

+---------------+------------------+--------+------------+
| COUNTRY       | STATE            | FINDS  | PERCENTAGE |
+---------------+------------------+--------+------------+
| Germany       | Bayern           |     10 |      50.0% |
|               +------------------+--------+------------+
|               | Sachsen          |      5 |      25.0% |
|               +------------------+--------+------------+
|               | Berlin           |      1 |       5.0% |
|               +------------------+--------+------------+
|                                  |     16 |      80.0% |
+---------------+------------------+--------+------------+
| United States | New York         |      2 |      10.0% |
|               +------------------+--------+------------+
|               | Texas            |      1 |       5.0% |
|               +------------------+--------+------------+
|                                  |      3 |      15.0% |
+---------------+------------------+--------+------------+
| Greece                           |      1 |       5.0% |
+---------------+------------------+--------+------------+

What do you think?

[thcyron]

You’re right, this information isn’t present in my table. I quickly hacked your proposal into the code and came up with the following:

I’m not quite sure about this. It makes the table look a little bit complicated. Another idea is to leave the “Finds by Country“ table untouched and have a separate “Finds by State“ table for each country (if the country has states).

[agorf]

I think I like your second proposal better. Something like "Finds by State in Germany", "Finds by State in the United States of America" sounds good. :-)