Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Alias for clients

Hi, I am using direct query to source client information from Azure Databricks.

 

In a table I am showing the top 10 clients by loss and then showing some additional measures as well.

Is there away that instead of the client code, I can show the top 10 clients as client 1, client 2 etc 

 

 

Thanks,

Jake 

Need Help

3 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    3 years ago

    Anonymous , That would require bucketing of the Rank measure

     

    Dynamic segmentation -Measure to Dimension conversion: https://youtu.be/gzY40NWJpWQ

     

    as rank will use all or allselected the post bucketed measure might require that too

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hi, Could you please explain this further as the video will not open for me. From what I understand I need to create a ranking measure and the bucket this measure to create the client 1 etc? 

       

      Regards,

      Jake