Im trying to count the rows of open errors in the table shown below (figure 1). The table shows a train computer logging errors from different trains.
Figure 1. ( table of FACT_SAP_KILDE)
I have tried doing an external table and counting the rows of open errors like figure 2 below, and i works great! problem is, i can't relate to the table above (Figure 1) and define which train or which group it belongs to.
Figure 2 ( Table of Komfort )
My question is if there is a way to make the same calulation for Figure 1 as performed in Figure 2, so the details from the train can be available?