Can I build a calculated field to find the percentage for a provided categorical dimensions. I have table with columns : DATE, LOCATION, AGE, TYPE, #UNITS.
I want to create the calculated field (say PCT_UNITS) to answer question like below, based on Filtering and Grouping dimension in visual instead of having to pre-define separate calculated fields for each combination dimensions
1- find the PCT_UNITS of certain TYPE by LOCATION?
2- find the PCT_UNITS with <40 days AGE by PERIOD?
Hello @tmpatil, welcome to the QuickSight community!
We should be able to create these calculations pretty easily in QuickSight, but let me know if you have any questions. There may be some variables depending on the way you are implementing them inside of your dashboard.
My data is a bit different than yours and I am not sure I fully understand how the 2nd option should work, but I created a demo in QuickSight Arena for both of the calculations you had in mind. Both allow for some user selections to manage the values being returned. Let me know if you have any questions: Dynamic Calculated field to find percentage of certain category