BGonline.org Forums

suggests for new XG

Posted By: eXtreme Gammon
Date: Saturday, 18 January 2014, at 2:04 a.m.

In Response To: suggests for new XG (Dmitriy Obukhov)

You can add the number of games by dragging any value such as PR then right click and use "count"

However, i do think that cross tables with multiple measures are very messy to read and I would advice to do a 2nd pivot table (you can copy/paste the existing one) and use count rather than average for the PR value.

The total decisions is not in the exported table, you can create a column, adding the checker, double and take decisions if you want.

Pivot tables are a great tool to slice and aggregate data (in my day job, one of my responsibility is to head the Data warehouse team, so I got plenty of fun designing and playing with them).

Messages In This Thread

• On the Fifth day of Christmas
  Stick -- Thursday, 16 January 2014, at 10:55 p.m.
  • On the Fifth day of Christmas
    onur alan -- Friday, 17 January 2014, at 12:45 a.m.
    • On the Fifth day of Christmas
      Taper_Mike -- Friday, 17 January 2014, at 2:27 a.m.
  • On the Fifth day of Christmas
    Taper_Mike -- Friday, 17 January 2014, at 2:22 a.m.
  • On the Fifth day of Christmas - 3Rd Roll in OB
    eXtreme Gammon -- Friday, 17 January 2014, at 3:11 a.m.
    • suggests for new XG
      onur alan -- Friday, 17 January 2014, at 11:47 a.m.
      • suggests for new XG
        Michael Nielsen -- Friday, 17 January 2014, at 12:35 p.m.
        • suggests for new XG
          onur alan -- Friday, 17 January 2014, at 1:10 p.m.
          • suggests for new XG
            Michael Nielsen -- Friday, 17 January 2014, at 1:43 p.m.
            • another suggests for new XG
              Konstantin -- Friday, 17 January 2014, at 2:02 p.m.
              • +1 *NM*
                sita -- Friday, 17 January 2014, at 2:08 p.m.
              • another suggests for new XG
                Henrik Bukkjaer -- Friday, 17 January 2014, at 11:27 p.m.
                • another suggests for new XG
                  Konstantin -- Saturday, 18 January 2014, at 10:42 a.m.
                • another suggests for new XG
                  Konstantin -- Sunday, 19 January 2014, at 11:32 a.m.
            • suggests for new XG
              onur alan -- Friday, 17 January 2014, at 4:18 p.m.
      • suggests for new XG
        eXtreme Gammon -- Friday, 17 January 2014, at 1:57 p.m.
        • suggests for new XG
          Dmitriy Obukhov -- Friday, 17 January 2014, at 2:12 p.m.
          • suggests for new XG
            eXtreme Gammon -- Friday, 17 January 2014, at 4:46 p.m.
            • suggests for new XG
              Dmitriy Obukhov -- Friday, 17 January 2014, at 11:55 p.m.
              • suggests for new XG
                eXtreme Gammon -- Saturday, 18 January 2014, at 2:04 a.m.
        • suggests for new XG
          Bob Koca -- Friday, 17 January 2014, at 9:09 p.m.
          • suggests for new XG
            eXtreme Gammon -- Friday, 17 January 2014, at 9:16 p.m.
            • suggests for new XG
              Taper_Mike -- Saturday, 18 January 2014, at 2:06 a.m.