If I am getting you correctly,
You can ingest Indian states kml file(as attached) rename state field as of your state field.
Somewhat like this:
Upper("India States.Name") as address_state,
FROM [lib://*****/India States.kml]
(kml, Table is [Indian_State - Copy.kml/Features]);
Please note field data of your field and kml should match (case wise)
After loading the data.
Use map as a chart > IndianState.Area (If you want to plot as area)
In Appearance, You can put your measure to colour. !
I hope this will help!
India States.kml 195.4 K