We are developing a Cab booking application. We want to create a graph which will display Rank based on income for each car per month in a graph.
We are calculating the total income of a car and its overallrank at end of month and keeping it in a DB table. We have created a report definition with chart which shows Month on X-axis, Rank on Y axis. Cars data with income is displayed as Bars on X -axis.
Now as the Y-Axis starts from value 1, the rank 1 car has the smallest bar and the size of bar goes on increasing as the rank increases. We want to do it exactly opposite. The bar to indicate Rank 1 should be the highest one, Rank 2 should be second highest and so on. In other words the Y-axis should go on decrementing. Is this possible to achieve in Pega?
Also as of now we are displaying Cars as bars. There is a fixed sequence of this. Can wee show it like Car with Rank 1 should be first and car with Rank 2 should be 2md so on...