Uploaded image for project: 'Couchbase Server'
  1. Couchbase Server
  2. MB-47795

Date field on either X or Y axis of X-Y chart is not displayed properly on Analytics workbench

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 7.0.1
    • 7.0.2
    • analytics, UI
    • Enterprise Edition 7.0.1 build 5988

    Description

      Cluster Info -

      Number of Nodes - 2

      Node 1 services - KV (900 MB), N1QL, Index (512MB), Backup

      Node 2 services - Analytics (1472 MB)

      Browsers used - Chrome and Safari.

       

      Sample KV document-

      {
        "c_balance": 31675.94,
        "c_city": "qeywjafafyqrxqtbtmm",
        "c_credit": "GC",
        "c_credit_lim": 50000,
        "c_d_id": 1,
        "c_data": "cvdhgpvpfpickrbbnhifpktmldwasvzyqlbqlhwugogwfyyccducmcrcxnlnfavozqobljuknbxhjzedslmqyjbvyzujxfrrwhvpkjzvtapgdwkfsdhvrcccfwjrkelugfiezclfzpevcjlzipjendvfmmpkyiqmkefzhxiwouzgyostvdjybtlmjtoscawgxifvtdgnktjjuklogslyckdxxdxbvbecwbfnnnaxtumkfvdnlecwogxmpcgkavzbjgeiubzuptdakppowyzrmxkutvhysuvnrzriomhvivglhimlcjalsjcrdvypwxy",
        "c_delivery_cnt": 0,
        "c_discount": 0.3609,
        "c_first": "bgqeqi",
        "c_id": 1,
        "c_last": "BARBARBAR",
        "c_middle": "OE",
        "c_payment_cnt": 1,
        "c_phone": "9511949373027194",
        "c_since": "2017-02-10 03:27:56",
        "c_state": "s1",
        "c_street_1": "ledmgettax",
        "c_street_2": "kznuqrolqqk",
        "c_w_id": 1,
        "c_ytd_payment": 10,
        "c_zip": "411111111"
      }

      Query - "select * from Customer"

       

      Case 1 & 2 -

      After ingesting the above data into CBAS dataset and executing query, while displaying X-Y chart and selecting a column consisting of dates as either X or Y axis is not displayed properly.

      Attaching screenshots and logs.

      Steps to load KV data used for testing -

      https://docs.google.com/document/d/1_Xr3e04kTb1FAflaDL5sPAs423FZaOmxE6Xj5UUvMbQ/edit#heading=h.udjc472a857l

      Attachments

        Issue Links

          No reviews matched the request. Check your Options in the drop-down menu of this sections header.

          Activity

            A lot of fixes went into the query charts.. Analytics charts needs to be updated to include the new code. 

            isha Isha Kandaswamy (Inactive) added a comment - A lot of fixes went into the query charts.. Analytics charts needs to be updated to include the new code. 
            eben Eben Haber added a comment -

            I just merged a fix for this.

            eben Eben Haber added a comment - I just merged a fix for this.

            Build couchbase-server-7.0.1-6004 contains query-ui commit 1e0bef5 with commit message:
            MB-47795 - date problem with charts

            build-team Couchbase Build Team added a comment - Build couchbase-server-7.0.1-6004 contains query-ui commit 1e0bef5 with commit message: MB-47795 - date problem with charts

            Build couchbase-server-7.1.0-1132 contains query-ui commit 1e0bef5 with commit message:
            MB-47795 - date problem with charts

            build-team Couchbase Build Team added a comment - Build couchbase-server-7.1.0-1132 contains query-ui commit 1e0bef5 with commit message: MB-47795 - date problem with charts
            umang.agrawal Umang added a comment -

            Verified with build Enterprise Edition 7.0.2 build 6593

            umang.agrawal Umang added a comment - Verified with build Enterprise Edition 7.0.2 build 6593

            People

              umang.agrawal Umang
              umang.agrawal Umang
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Gerrit Reviews

                  There are no open Gerrit changes

                  PagerDuty