Customizing Provided LDM Dashboard Reports

Complete the following steps to customize the Orders Inflow Rate graph or the Order Completion Rate graph.

Customizing the Orders Inflow Rate Graph

You can change the order's inflow on a per minute (default), per hour, or per day scale.
  1. Click the edit button on the Orders Inflow Rate graph.
  2. Change the x-axis based on what time scale you want shown on the graph:
    • Per Minute (this is default)
      1. From the Data tab, change the query to SELECT count_distinct(orderID) AS Orders, roundOffTimestampToMinutes FROM SubmittedOrders GROUP BY roundOffTimestampToMinutes.
      2. Select the Visualization tab. From the Field drop-down menu, select roundOffTimestampToMinutes.
    • Per Hour
      1. From the Data tab, change the query to SELECT count_distinct(orderID) AS Orders, roundOffTimestampToHours FROM SubmittedOrders GROUP BY roundOffTimestampToHours.
      2. Select the Visualization tab. From the Field drop-down menu, select roundOffTimestampToHours.
    • Per Day
      1. From the Data tab, change the query to SELECT count_distinct(orderID) AS Orders, roundOffTimestampToDay FROM SubmittedOrders GROUP BY roundOffTimestampToDay.
      2. Select the Visualization tab. From the Field drop-down menu, select roundOffTimestampToDay.
  3. Update the Axis Name to Time.
  4. Click Save

Customizing the Order Completion Rate Graph

  1. Click the edit button on the Order Completion Rate graph.
  2. Change the x-axis based on what time scale you want shown on the graph:
    • Per Minute (this is default)
      1. From the Data tab, change the query to SELECT count_distinct(orderID) AS Orders, roundOffTimestampToMinutes FROM CompletedOrders GROUP BY roundOffTimestampToMinutes.
      2. Select the Visualization tab. From the Field drop-down menu, select roundOffTimestampToMinutes.
    • Per Hour
      1. From the Data tab, change the query to SELECT count_distinct(orderID) AS Orders, roundOffTimestampToHours FROM CompletedOrders GROUP BY roundOffTimestampToHours.
      2. Select the Visualization tab. From the Field drop-down menu, select roundOffTimestampToHours.
    • Per Day
      1. From the Data tab, change the query to SELECT count_distinct(orderID) AS Orders, roundOffTimestampToDay FROM CompletedOrders GROUP BY roundOffTimestampToDay.
      2. Select the Visualization tab. From the Field drop-down menu, select roundOffTimestampToDay.
  3. Update the Axis Name to Time.
  4. Click Save