Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to create a calculated dimension in which I need to consider (distinct max date and distinct Name_String) to conclude output_string? Note Date is in RFC format
Name_String | date | output_string |
string1 | date1 | string1_yyw3 |
string1 | date3 | string1_yyw2 |
string1 | date3 | string1_yyw1 |
string2 | date1 | string2_yyw1 |
string2 | date3 | string2_yyw2 |
string2 | date3 | string2_yyw3 |
Output:
string1 | date3 | string1_yyw1 |
string2 | date3 | string2_yyw3 |
I need the output with respect to the constant_string and date and I need both the values as they are distinct.