Aggregate Dimension over a date

Anonymous — Tue, 21 Nov 2017 09:21:03 GMT

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.

Key	Date	Sales
101	1-09-2017	_
101	_	232
101	_	321
102	_	654
102	_	342
102	1-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) )??

Re: Aggregate Dimension over a date

MK_QSL — Tue, 21 Nov 2017 09:27:58 GMT

Create a Straight Table

Dimension

1) Key

2) =Aggr(Max(Date),Key)

Expression

Max(TOTAL <Key> Sales)

topic Re: Aggregate Dimension over a date in App Development

Aggregate Dimension over a date

Re: Aggregate Dimension over a date