Creating a frequently ordered catalog item list

Modified 1 month ago

Rajesh Narayanan

Kissflow Work Platform:

  • Small Business
  • Corporate
  • Enterprise

Procurement managers typically want a list of commonly requested catalog products in order to request a better quote from vendors. 

Until now, they had to merge two tables using lookups in order to get a report combining data from both tables. 

To obtain the list, they can now create a dataview and then a report over that dataview. This method using Kissflow Analytics is simple and effective.

The following is a sample query for creating this dataview:

Select

    pr."Purchase_Request_Number",

    pr."Requester_name",

    pr."Requester_department",

    pr."Type_of_Purchase",

    pr."PR_Estimate.display_value" as Total_PR_Value,

    prcat."Item" as Catalog_Item,

    prcat."Quantity" as Catalog_Item_Quantity,

    prcat."Item_Amount.value" as Catalog_Amount,

from

    "Purchase_Request" as pr

    join "Catalog_Items" as prcat on pr."_id" = prcat."_instance_id"

In the above query, Purchase_Request is the process table, and Catalog_Items is its child table. An SQL join is performed between the process table and its child table.

After publishing the dataview, the procurement manager can finally create a chart report with the following configuration:

Measure: Catalog item

Dimension: Catalog item, Catalog item quantity

Did you find the article helpful?

Powered by HelpDocs (opens in a new tab)