Forum Discussion

OS_Pizza's avatar
OS_Pizza
Contributor III
2 years ago

Fields inside Data unit statistics?

1. Why is the "Total number of stored records" same across all months for one year ?

 

  • NicolasArgente's avatar
    NicolasArgente
    Valued Contributor

    Hi!
    OneStreams stores data for each year in a different table. So you have the table for 2022 and another one for 2023. The number of row in the table is the number of stored records you see under GENERAL. 
    After that the data unit filters "kind of" on those Store Records. 
    If you are interested wit the statistics, please have a look at the Application Analysis Report. In this Report, there are key metrics that support Data Unit records, Data Unit sizes, and the optimization of formulas. 

    Look below I did a filter on the database and I have the same values than in my Stored Records.

     

    Press the Kudo if you like the answer !

     

    • OS_Pizza's avatar
      OS_Pizza
      Contributor III

      That means the total no of record is the row count of 2022 data table (filtering on my S#,E#,C#,Cube) and not the total no of records for a particular month.

      1) What is number of NODATA,Zero,Real,Derived cells ? And why are they all under NODATA Status ?

      2)