Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello.
I have create a straight chart and the data are sorting decending by the amount. Also i have a column that has record number and the name of cardholder.
I have create also an input field that you can give the step.
Step | = | 3 |
The data are like the table below
RecordNo | Cardholder | Amount |
1 | poiuy | 9876 |
2 | kkk | 4567 |
3 | Guy | 1000 |
4 | wedf | 1000 |
5 | Dav | 850 |
6 | Best | 701 |
7 | qwr | 567 |
8 | qwer | 432 |
9 | plom | 321 |
10 | Mam | 300 |
11 | jjj | 234 |
12 | Nana | 139 |
13 | llop | 123 |
14 | tyj | 98 |
15 | Devra | 80 |
16 | Gibson | 75 |
17 | fgns | 56 |
18 | plo | 56 |
19 | Kim | 50 |
20 | sdfg | 34 |
21 | Jim | 30 |
22 | Jane | 25 |
When you give the step e.g 3 in another straight chart you have the data of cardholders that have the record number 3, 6, 9, 12, 15 e.t.c
RecNo | Cardholder |
6 | Best |
9 | plom |
12 | Nana |
15 | Devra |
21 | Jim |
The problem is that i lose the data that i have the same Amount in the first table e.g i lose the record number 3 and18.
Is there somebody to help me to not lose that data ?
I attach the QVW.
Thanks in advance.
Try
=aggr(if(mod(rank(sum(Amount),4,0),Step)=0,rank(sum(Amount)),0),Cardholder)
as your calculated dimension.
Does not word correctly at all because i want in the chart
Cardholders by Step to show record 3 , 6, 9, 12 e.t.c
and not 3-4 because the results are incorrect if you see in the chart Cardholders below the chart
Cardholders by Step.
It's just a question how you sort the Cardholder having same sum(Amount), and to format the rank as number, not as text.
You are using advanced aggregation in your calculated dimension, which always sort its dimension values by load order, so you need to sort the Cardholder in your second table also by load order.
Check attached.
Thank you very much.
It works perfect.