Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
Hi Thanh,
Kindly add a calculated dimension as shown below in your chart.
Aggr(Max(Date#(Date, 'DD.MM.YYYY')),OrderNo)
Regards
Sumeet
How is order_quantity 200 for order 10002? Do you want quantity of max date or the entire quantity for the order?
Hi Thanh,
Kindly add a calculated dimension as shown below in your chart.
Aggr(Max(Date#(Date, 'DD.MM.YYYY')),OrderNo)
Regards
Sumeet
I m sorry it should be 300
Try like:
Thanks for your solution!