Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
i have a table like shown below: my requirement is in the chart i should get max date and max hour data ie 11/8/2019 and 3rd hour sales ie 108. how to write expression for this?
Country | Date | Hour | Sales |
germany | 11/6/2019 | 1 | 100 |
germany | 11/6/2019 | 2 | 101 |
germany | 11/6/2019 | 3 | 102 |
germany | 11/7/2019 | 1 | 103 |
germany | 11/7/2019 | 2 | 104 |
germany | 11/7/2019 | 3 | 105 |
germany | 11/8/2019 | 1 | 106 |
germany | 11/8/2019 | 2 | 107 |
germany | 11/8/2019 | 3 | 108 |
Try like:
Dim 1: Country
Exp 1: Date(Max(Date))
Exp 2: FirstSortedValue(Hour, -(Date*24+Hour))
Exp 3: FirstSortedValue(Sales, -(Date*24+Hour))
sorry the correct table is
Country | Date | Hour | Sales |
germany | 11/6/2019 | 1 | 100 |
germany | 11/6/2019 | 2 | 101 |
germany | 11/6/2019 | 3 | 102 |
germany | 11/6/2019 | 4 | 103 |
germany | 11/7/2019 | 1 | 103 |
germany | 11/7/2019 | 2 | 104 |
germany | 11/7/2019 | 3 | 105 |
germany | 11/8/2019 | 1 | 106 |
germany | 11/8/2019 | 2 | 107 |
germany | 11/8/2019 | 3 | 108 |
Try like:
Dim 1: Country
Exp 1: Date(Max(Date))
Exp 2: FirstSortedValue(Hour, -(Date*24+Hour))
Exp 3: FirstSortedValue(Sales, -(Date*24+Hour))
Hi
i want the output in straight table as
Country | Date | Hour | Sales |
germany | 11/8/2019 | 3 | 108 |
Did you try the solution I proposed?
Set analysis is not something that should be used everywhere. Here you don't need that.
Please close the thread by giving 'like' and/or marking 'correct answer'.