I currently have a set of data like this:
My aim is to create a chart with:
1 dimension (User)
and 2 expressions (sum of value) and count(distinct Journal ID) for each user.
I manage to create a chart just fine ( an example of this is attached) . However i'm having difficulty sorting the cart, I would like to sort the chart based on High value and low volume.
Does anyone know If I can achieve this?
can you be more specific , how can you combine the two measures
my only thought is you can use rank for both measures and take sort according to the sum of the two ranks
for example rank(sum(value))+rank(-count(distinct Journal ID) )
this way you get low ranks if you have high value low volume
In that case you can sort it like property > sort > sort by Y-Value - > Descending.
Thank you Vishweshwari,
Did you just sort by state and expression sum(value)?
I can see how it works perfectly on the dashboard you kindly provided but doesn't work on my dashboard. I don't know if i'm missing something or if I need to re-load my data and force the Journal ID to be numeric