As @ErikG already said and based on your latest reply, changing the granularity should work.
I will be marking this as the ‘Solution’ . If you require further assistance provide us some sample data with the expected output , use the Arena ( NEW -- QuickSight Arena -- An embedded instance of QuickSight within the QuickSight Community - #6 by sagmukhe )