Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Expand
titleClick here for steps
  • Click on the 'Edit' icon beside the dashlet title.

Image RemovedImage Added
  • Enter the new title and click on 'Update'.

...

Expand
titleClick here for steps
  • Create a query with condition as mentioned below. For more details, refer to the wiki page

Image RemovedImage Added
  • Create a bar type dashlet with cumulative count of specimen ID as the metrics (Y axis) and the collection date(X axis) as category. See the attached image below. For more details, refer to the wiki page.

Image RemovedImage Added
  • Create a query with the below conditions.

Image RemovedImage Added
  • Create a bar type dashlet with cumulative count of specimen ID as the metrics (Y axis) and the order execution date(X axis) as category. See the attached image below. For more details, refer to the wiki page.

Image RemovedImage Added
  • Refer to the export section below and download both the dashlet definition files.

  • Combine the two definition files. See the attached example

JSON File
Note

To customize the dashlet for specific collection protocols—ensuring it retrieves records from only one or two protocols—simply add the following syntax at the beginning of your criteria.

Code Block
languagejson
CollectionProtocol.shortTitle in (\"<CP_NAME_1>\",\"CP_NAME_2\") and
Code Block
{
  "name" : "dash-sys-coll-dist-lastquat",
  "title" : "Specimen Collected and Distributed in last quarter",
  "type" : "CHART",
  "dataSource" : {
    "options" : {
      "dataSources" : [ {
        "type" : "AQL",
        "options" : {
          "category" : {
            "expr" : "Specimen.createdOn",
            "title" : "Creation Time"
          },
          "metrics" : [ {
            "expr" : "c_count(Specimen.id)",
            "title" : "Collected Specimens"
          } ],
          "criteria" : "Specimen.createdOn exists and Specimen.collectionStatus = \"Collected\" and date_range(Specimen.createdOn, last_cal_qtr)"
        }
      }, {
        "type" : "AQL",
        "options" : {
          "category" : {
            "expr" : "Specimen.specimenOrders.executionDate",
            "title" : "Distribution Time"
          },
          "metrics" : [ {
            "expr" : "c_count(Specimen.id)",
            "title" : "Distributed Specimens"
          } ],
          "criteria" : "Specimen.specimenOrders.executionDate exists and   Specimen.specimenOrders.orderStatus = \"EXECUTED\" and   date_range(Specimen.specimenOrders.executionDate, last_cal_qtr)"
        }
      } ],
      "categoryType" : "date"
    },
    "type" : "SERIES_MIXER"
  },
  "chartOpts" : { },
  "activityStatus" : "Active"
}

  • The dashlets dash lets with both conditions of specimens collected and distributed will be created. See the image below

Image RemovedImage Added

Delete Dashlets

...