Hello,

I understand that you are creating visualisations from a dataset of Security Hub findings loaded from Athena via Glue. You would like to verify if it is possible to extract metadata from a dataset and use them as additional dataset to incorporate them in other visuals using some field extraction functions if any. Also you would require recommendations for standard visualisations for C-suite execs.

Please allow me to inform you that, QuickSight has the following functions and operations to extract data from the provided dataset.

1. Extract- extract returns a specified portion of a date value. Requesting a time-related portion of a date that doesn't contain time information returns 0. The following example extracts the day from a date value. [1]

• extract('DD', orderDate)

2. Substring- substring returns the characters in a string, starting at the location specified by the start argument and proceeding for the number of characters specified by the length arguments. The following example returns the 13th through 19th characters in a string. The beginning of the string is index 1, so you begin counting at the first character. [2]

• substring('Fantasy and Science Fiction',13,7)

3. Also, when you are analysing data in a specific visual, you can apply table calculations to the current set of data to discover how dimensions influence measures or each other. Visualised data is your result set based on your current dataset, with all the filters, field selections, and customisations applied.

4. In order to see exactly what this result set is, you can export your visual to a file. A table calculation function performs operations on the data to reveal relationships between fields. [3]

Having said that, as a recommendation for standard visualisation for C-suite execs, QuickSight comes with a built-in suggestion engine that provides you with suggested visualisations based on the properties of the underlying datasets. Suggestions serve as possible first or next-steps of an analysis and removes the time-consuming task of interrogating and understanding the schema of your data. [4]

As you work with more specific data, the suggestions will update to reflect the next steps appropriate to your current analysis.

In order to better understand your use case, I would request you to raise a support case with AWS so that resource based troubleshooting can be done and suggest a possible workaround.

Thank you!

References:-

[1] https://docs.aws.amazon.com/quicksight/latest/user/extract-function.html

[2] https://docs.aws.amazon.com/quicksight/latest/user/substring-function.html

[3] https://docs.aws.amazon.com/quicksight/latest/user/table-calculation-functions.html

[4] https://aws.amazon.com/quicksight/resources/faqs/

[5] https://docs.aws.amazon.com/quicksight/latest/user/functions-by-category.html