‘Calculated Measures’ Inform Staff of Newest Products

Looking for an easy way to notify staff of new Product Launches? Look no further! BI includes calculated measures, which:

  • Indicate the date the Product was created;
  • Count the Number of Days from the created date.

Using these measures, you can easily create a useful report to help staff keep on top of new products hitting the stores.

Here’s how:

  1. Begin by opening template ​“100 - smp - Date Single Day.”
    Calculated_Measures_Image_1.png

  2. Choose ​“Save As” and name your report: Products Created In the Last 30 Days.

  3. Next, open the query builder.

  4. Right click on the data in view to ​“Clear Grid.”

  5. Navigate to the Product Measures. Open up that measure group and add in ​“Days Since Product Created” and ​“Product Created.”
    Calculated_Measures_Image_2.png

  6. To report by product, we will want to add Products and SKUs to the query. These items can be found under categories and products.

  7. Change the existing category and product filter to point/​default from all products to the category you would like.

  8. From within Categories and Products, add a filter for Regular products only.

  9. Choose ​“OK” to move on the design screen.
    Calculated_Measures_Image_3.png

  10. From within the design screen, drag your values onto the existing table -- removing the items you don’t need.
    Calculated_Measures_Image_4.png

  11. Filter your Days Since Product Created measure within your Row Group to include only those products you wish to include.
    Calculated_Measures_Image_5.png

And that’s it! Easy right?

To learn more, join us for weekly training and How-To’s on report building and design during our iQmetrix BI Q&A: Mondays at 2 p.m. EST.

Looking for help with report building/​creation? Contact our team at training@​iQmetrix.​com