I am very new to QuickSight and could not figure out how to get the dashboard to display what I need. I have an excel sheet where I have a column with numbers (money spent) that I tried formatting as numbers and currency before uploading to QuickSight. When the dataset is in QuickSight it appears as string and I am unable to create a calculated field to sum up all the rows or do an aggregate sum per year. When I tried changing the field type to integer or decimal in QuickSight none of the rows shows up so I had to leave it as a string. Any ideas on what I am doing wrong?
The calculated field I was trying to create was pretty simple sum(arr) but shows errors most likely because of the field type.
Fist you need to change the data type in your data source you are uploading. Formate the field as numbers. if any space or data formate like -, etc should not be in column. Quicksight SPICE consider it string if other than numbers in column.
Thank you all! I went back changed the file to numbers with no decimal places and uploaded again and it automatically picked up that as an integer. I really appreciate the help, it is working now!