AnsweredAssumed Answered

Data Count in RTReports

Question asked by VAshok on Mar 4, 2020

Hi ,

I have data in the below format recieved in PI Tags, the data is delimited by "/".

DateTime                          Value
04/03/2020 10:00:00        A1/B1/C1
04/03/2020 10:00:01       A2/B2/C2
04/03/2020 10:00:02       A1/B1/C1
04/03/2020 10:00:03       A3/B3/C3
04/03/2020 10:00:04       A2/B2/C2
04/03/2020 10:00:05       A1/B1/C1
04/03/2020 10:00:06       A2/B2/C2
04/03/2020 10:00:07       A1/B1/C1
04/03/2020 10:00:08       A3/B3/C3

I would like to generate a report with the following table

Desc1       Desc 2       Desc 3       Count
   A1             B1             C1                4
   A2             B2             C2                3
   A3             B3             C3                2

   Total Count: 9


Currently I have done this by getting data into SQL (Using PI OLEDB) and running stored procedure and configuring them in the RTReports. Do we have a way of doing this without using SQL ?

Thank you,
Vinayak

Outcomes