Percentage is showing the wrong data as it should be (range wise So Value /SO Value )* 100.
Note:
SO Value is already a aggregated value.
Also I want the sequence of Range Days like I am sharing in the screenshot but to have this I used Alphabets (A,b etc) . So is there a better solution other then this?
Hello @NirmalSingh, it would be beneficial if you were able to put a demo version of this visual into a QuickSight Arena analysis. That would be the easiest way for me to determine the best way you are creating these calculations and to help fix the table.
I have a few questions to try and assist you. How are you building the calculated field to get the percentage value? I am thinking you may need to use LAC-W aggregations since you are building these custom groupings with the Range Days field. This may also make it more difficult to manage the total percent displayed, but in tables you can customize the aggregation on the total.
Also, the way you have set up the range field to show them in the order you want is probably the best work-around. You can either add letters in front to display in Alphabetical order, or add a number in front. If you have 10 or more options, you would have to display number like this:
01, 02, 03, 04… etc. Unfortunately there isn’t a better way to manage that sort functionality since you are not displaying the actual date fields.