How can I sort the data in a table or matrix by one text/dimension and one calculated measure

[mansi]

Hi

I have a report which contains multiple text columns and measures. I am looking for the ability to sort the data in a table or matrix by one text/dimension and one calculated measure. So, the first column needs to be sorted in Ascending order and all the other subsequent columns should be sorted based on the Calculated Measure (which is the part of the report).

I am able to sort data by either that text column or calculated measure, but not able to sort by both at the same time. Any ideas on how this can be done?

Appreciate your help!

Thanks

Mansi

[vanessafvg]

@mansi can you give more detail or the logic that would trigger them to be sorted

what is the business requirement here?

[mansi]

Hi @vanessafvg

The goal is to find out which link was most clicked within each email in the latest month. We have a bunch of emails in the same report.

To simplify the ask, I want to build a report (table/matrix) with Email Name, Link Name and Number of Clicks in the current month.

• Email Name should be sorted in Ascending Order. This is because some of these are nurture emailsand are sent out in a particular order.
• Link Name should appear in the descending order of Clicks. This is to ensure that for each Email, the link that is clicked most should appear on the top and then the 2nd most clicked link, and so on..
• The measure - Click is calculated for rolling 30 days.

Current issue is that if I just sort the table by descending clicks, it also sorts the Email Name and shows the one with most clicked on the top.  In the snapshot below, the Link Names are sorted in the appropriate order (descending), but the order of Email Name also changed. I want the Email1 to appear first.

Please let me know if you need further details.

[mansi · Accepted solution]

This can be achieved by adding a measure Clicks/Total Clicks and then sort descending by that.

[josipinho]

could you please elaborate on this one ? I seem to have a similar request but I didnt quite understand how you solved it and how it looks in the end ?