Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I need Repeated Customers Analysis, how to write the Calculated Dimension for Only last visited Sales .
for Example,
In below mentioned table, Rank 3 is last visited sales.So, in Calculated Dimension I want display Rank 3 Record only.
Rank | DocNum | DocDate | CountyB | Brand | Segment | Sales |
1 | 1911100895 | 07-05-19 | 6374860082 | PREETHI | MIXE | 3100 |
2 | 1911100943 | 08-05-19 | 6374860082 | CROMPTON | AIRCOOLER | 5099.99 |
2 | 1911100943 | 08-05-19 | 6374860082 | VENUS | FAN | 1000 |
3 | 1911101297 | 21-05-19 | 6374860082 | CROMPTON | ACCESSORIES | 390.01 |
I have written this Expression
=Aggr(if(Rank(Total Sum(LineTotal_WithTax))/Count(distinct{<CustPhoneNo = {"=Rank(Total count(distinct DocDate))=2"}>}CustPhoneNo),'2 Times'),CustPhoneNo)
its not working.
Anybody please help me. how to write the set expression and Calculated Dimension.
Rank is not a field here?
Rank is not a field, that is the Rank function.
Hi Ram,
Did you try with Forstsortedvalue() in the expression? Is Last visited determine with DocDate? If yes, i think we can achieve this with firstsortedvalue.