It is unclear what the exact problem is. Also, it is very difficult to provide any answer to queries without having the structure of the data or example data.
shooting in blank but may be this is something you want to achieve:
finaldata | render columnchart kind =unstacked
Please "Accept the answer" if the information helped you. This will help us and others in the community as well.