0

Static value list for a dimension

Hello Community,

 

I am building a report for a client. I need to create a matrix grid with monthly return values(Jan to Dec) for each year starting 2017. For current year I don't have data for July and beyond, but I still need to have the future months as values in column for the matrix grid. Current grid looks like this,

 I want to have all the month names (including Jun-Dec) in the column with no values without adding dummy rows to the data. Thank you

2 replies

null
    • Senior Director of Product
    • Ian_Macdonald
    • 3 mths ago
    • Reported - view

    Hi  ,

    It comes down to how you have built your data model.

    If you are deriving your month and year dimension from your data and there are no records for months June - December in 2024, then the months June - December 2024 will not show because they do not exist.

    I suggest you read these threads from previous questions on how to show empty date / time attributes in reports. If you have any further questions, then please revert back here.

    https://community.pyramidanalytics.com/t/q6yxvb3/displaying-a-0-instead-of-a-blank-cell-where-theres-no-data-for-a-given-date 

    https://community.pyramidanalytics.com/t/h7y6mg2

    Hope that helps!

    Ian
     

      • Puneet_Mehta
      • 3 mths ago
      • Reported - view

       Thanks Ian! We would be inserting null values in the data to get the entire view for the year.

Content aside

  • Status Answered
  • 3 mths agoLast active
  • 2Replies
  • 47Views
  • 2 Following