1 Reply Latest reply: Nov 21, 2017 4:27 AM by Manish Kachhia RSS

    Aggregate Dimension over a date

    Sayyam Bhandari

      I have two dimensions Key and Date and one measure sales.Each key has one date and  null values. The problem is sales data is available only for null value.

       

      KeyDateSales
      1011-09-2017_
      101_232
      101_321
      102_654
      102_342
      1021-10-2017_

      I want to show both date(Excluding nulls) and max(sale) for the keys in the table.

       

      The issue is if i filter null values for date i get null for max (sales) because sales data is only available for null dates,How do i show both max(sales) and date together in table.

      Can i do some 'aggregation' on date over key so that i dont exclude null dates(maybe something like Aggr(Date(Max(Date)),Key)  )??