max date in dimension

[thanhphongle]

Hello Community,

is there a way to return in a bar chart the max(date) as dimension.

Here is an example:

OrderNo	Order_Position	Date	Order_Quantity
10001	1	01.02.2018	10
10001	2	01.02.2018	20
10001	3	03.02.2018	30
10002	1	15.02.2018	50
10002	2	15.02.2018	100
10002	3	20.02.2018	150

QV should return in the dimension and as expression this:

OrderNo	Date	sum(Order_Quantity)
10001	max(date) = 03.02.2018	60
10002	max(date) = 20.02.2018	300

[tresesco]

How is order_quantity 200 for order 10002?  Do you want quantity of max date or the entire quantity for the order?

[sumeet-vaidya · Accepted solution]

Hi Thanh,

Kindly add a calculated dimension as shown below in your chart.

Aggr(Max(Date#(Date, 'DD.MM.YYYY')),OrderNo)

Regards

Sumeet

[thanhphongle]

I m sorry it should be 300

[tresesco]

Try like:

[thanhphongle]

Thanks for your solution!