Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a question, I want to show most actual dates of a Milestone in a project in a KPI/ Textbox.
My dataset look like this but there are hundreds of data for each product_serial_no
Activity_ID | Processcode | Milestone_Text | Date | Productserial |
A1000080 | E.698 | A20 | 17.11.2021 | 100 |
A1000200 | F.598 | A30 | 26.11.2021 | 101 |
A1000300 | H.698 | A40 | 28.11.2021 | 100 |
A1000360 | I.598 | A50 | 30.11.2021 | 100 |
A1000380 | F.598 | A30 | 26.11.2021 |
102 |
Everything works well if there are not more than a unique date value but for,
= min({<Processcode = {'F.598'}, Milestone_Text = {'A30'} >} Date)
the result is ' - ' because there are two minimum dates one is for Productserial = '101' and for '102'.
But I expect ,no matter which Productserial, the most actual date and that is 26.11.2021, shown in the KPI / Textbox Diagramm.
Any Ideas how to solve this problem ? I am thankfull for any help incoming.
Best Regards
Oguzhan
Try :
min({<product_serial_no=>}Date) as measure in the KPI
That didn't work, how does this expression tells me wich Milestone is relevant. My Goal is to list the Milestone like below in a Textbox, but for milestone A30 i still get - as a result because there are two min dates for that milestone
Milestone Date Product
A20 17.11.2021 100
A30 26.11.2021 101, 102
A40 28.11.2021 100
A50 30.11.2021 100