Hi all,
I currently have a set of data like this:
Value | Journal ID | User |
---|---|---|
100 | 1 | isaac |
200 | 4 | isaac |
250 | 3 | isaac |
50 | 2 | joseph |
10 | 5 | joseph |
13 | 8 | luke |
12 | 9 | mary |
50 | 10 | miranda |
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?
Thanks
hi
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
Hi
do you want some thing like this
what is your expected sorted value????
Regards,
Hi Vishweshwari,
Yes please that's exactly what I am trying to achieve
In that case you can sort it like property > sort > sort by Y-Value - > Descending.
Regards,
ok
kindly find the attachment.
May be this:
Sum(Aggr(Count(Distinct JournalID),User,Value))
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
Thanks,
Isaac