Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have Large number of Credit Card Transaction. Approximately 50,000 Transaction in one month
Some spend less than 100, some spend 20,000
I want to show the number of users and total amount spend by the users in chart.
So I am creating two charts instead of one.
CHART 1 will have x dimesnion= Amount Spend, Y dimension = Count of Users
CHART 2 will have X dimension= Amount Spend, Y dimension = Sum of amount
For X Axis I am using a Class function to form a Range.
FInal chart is displayed as follows
My Issue is
I want user to compare top and bottom chart. I want to maintain consistent sort for X Axis. So that user can compare
example X axis should sort as follows 0-42, 42-84, 84-126, 126-169, 168-210
Similarly for Y axis
Basically I want sort based on X axis instead of Y Axis
1. How do I sort?
2. Is there any better way to show the chart?
Thank you
Sort both charts the same way by enabling numerical sort for the class dimension
Sort both charts the same way by enabling numerical sort for the class dimension