# Technical Articles **URL:** https://community.amazonquick.com/c/learning-center/articles/18.md?page=1 [Latest](https://community.amazonquick.com/latest.md) · [Categories](https://community.amazonquick.com/categories.md) · [Tags](https://community.amazonquick.com/tags.md) **Page:** 2 --- ## [Enterprise governance in Amazon Quick using custom permissions](https://community.amazonquick.com/t/enterprise-governance-in-amazon-quick-suite-using-custom-permissions/50094)
**Author:** [@salim](https://community.amazonquick.com/u/salim)\ **Replies:** 0\ **Last updated:** [October 10, 2025, 1:40am UTC](https://community.amazonquick.com/t/enterprise-governance-in-amazon-quick-suite-using-custom-permissions/50094 "2025-10-10T01:40:09Z")
Amazon QuickSight is evolving to Amazon Quick on October 9, 2025, expanding from a single BI product to a comprehensive suite that includes AI agents for business insights, research, and automation in one integrated expe… --- ## [How to Use Custom Time Zone in Quick Sight Without Shifting Date-Only Fields](https://community.amazonquick.com/t/how-to-use-custom-time-zone-in-quicksight-without-shifting-date-only-fields/41648)
**Author:** [@robdhondt](https://community.amazonquick.com/u/robdhondt)\ **Replies:** 3\ **Last updated:** [September 26, 2025, 3:21pm UTC](https://community.amazonquick.com/t/how-to-use-custom-time-zone-in-quicksight-without-shifting-date-only-fields/41648 "2025-09-26T15:21:50Z")
How to Use Custom Time Zone in Quick Sight Without Shifting Date-Only Fields If you’ve ever enabled Custom Time Zone in Quick Sight and noticed that your date-only fields are getting shifted by a day, you’re not alone. Q… --- ## [Chrome Extension: Quick Sight Power Tools](https://community.amazonquick.com/t/chrome-extension-quicksight-power-tools/36411)
**Author:** [@robdhondt](https://community.amazonquick.com/u/robdhondt)\ **Replies:** 3\ **Last updated:** [July 31, 2025, 5:29pm UTC](https://community.amazonquick.com/t/chrome-extension-quicksight-power-tools/36411 "2025-07-31T17:29:17Z")
I’ve created Quick Sight Power Tools, a Chrome extension that provides enhancements for calculated fields, dependencies, and change management. This open-source tool makes it easier to manage and export calculated fields… --- ## [CI/CD and Quick Sight multi-account best practices](https://community.amazonquick.com/t/ci-cd-and-quicksight-multi-account-best-practices/11060)
**Author:** [@EnriqueS](https://community.amazonquick.com/u/EnriqueS)\ **Replies:** 0\ **Last updated:** [March 14, 2023, 7:56pm UTC](https://community.amazonquick.com/t/ci-cd-and-quicksight-multi-account-best-practices/11060 "2023-03-14T19:56:38Z")
Most of our users ask us for best practices for CI/CD (a.k.a. BI Ops) in Quick Sight to plan, control, validate and finally deploy changes in their Quick Sight environment. This is a pretty broad topic and hence, we rec… --- ## [Best practices for improving Q&A accuracy with Custom Instructions](https://community.amazonquick.com/t/best-practices-for-improving-q-a-accuracy-with-custom-instructions/48308)
**Author:** [@alaresch](https://community.amazonquick.com/u/alaresch)\ **Replies:** 0\ **Last updated:** [July 17, 2025, 9:25pm UTC](https://community.amazonquick.com/t/best-practices-for-improving-q-a-accuracy-with-custom-instructions/48308 "2025-07-17T21:25:40Z")
Before jumping into Custom Instruction best practices, let’s cover the definition and a few examples. What are Custom Instructions? Custom Instructions enable Author Pros to curate Q&A responses to questions by adding … --- ## [Week Numbers (1-53)](https://community.amazonquick.com/t/week-numbers-1-53/651)
**Author:** [@Jesse](https://community.amazonquick.com/u/Jesse)\ **Replies:** 15\ **Last updated:** [July 14, 2025, 9:01pm UTC](https://community.amazonquick.com/t/week-numbers-1-53/651 "2025-07-14T21:01:32Z")
Today the extract() function does not support extracting the ‘week number’ from a date field. As a workaround you can use a formula like this (may need some adjustments +/-1 for certain years, could add some ifElse logic… --- ## [Dynamic metric and format with HighCharts](https://community.amazonquick.com/t/dynamic-metric-and-format-with-highcharts/47405)
**Author:** [@Ramon\_Lopez](https://community.amazonquick.com/u/Ramon_Lopez)\ **Replies:** 0\ **Last updated:** [June 19, 2025, 12:47am UTC](https://community.amazonquick.com/t/dynamic-metric-and-format-with-highcharts/47405 "2025-06-19T00:47:47Z")
How I Built a Smart Highcharts Widget That Adapts to Any Metric Ever been frustrated with creating multiple chart configurations for different data types? Yeah, me too. So I built this nifty Highcharts widget that autom… --- ## [Administration and BIOps Solutions of QS](https://community.amazonquick.com/t/administration-and-biops-solutions-of-qs/45587)
**Author:** [@Ying\_Wang](https://community.amazonquick.com/u/Ying_Wang)\ **Replies:** 0\ **Last updated:** [April 29, 2025, 9:56pm UTC](https://community.amazonquick.com/t/administration-and-biops-solutions-of-qs/45587 "2025-04-29T21:56:12Z")
Below is a summary of the key topics Administration and BIOps Solutions of Quick Sight, including four main areas: Quick Sight asset and user management – Who creates, owns, or has viewer permissions for an asset? (Ass… --- ## [Converting dates and timestamp fields in Quick Sight](https://community.amazonquick.com/t/converting-dates-and-timestamp-fields-in-quicksight/10006)
**Author:** [@abacon](https://community.amazonquick.com/u/abacon)\ **Replies:** 13\ **Last updated:** [May 6, 2025, 9:57am UTC](https://community.amazonquick.com/t/converting-dates-and-timestamp-fields-in-quicksight/10006 "2025-05-06T09:57:46Z")
Date and timestamp fields can be represented in a seemingly endless number of formats. Many of these are automictically recognised by Quick Sight, but if your date and timestamp fields use some of the more complex or non… --- ## [Displaying multiple number formats using a single measure](https://community.amazonquick.com/t/displaying-multiple-number-formats-using-a-single-measure/10767)
**Author:** [@Kellie\_Burton](https://community.amazonquick.com/u/Kellie_Burton)\ **Replies:** 3\ **Last updated:** [April 28, 2025, 9:00pm UTC](https://community.amazonquick.com/t/displaying-multiple-number-formats-using-a-single-measure/10767 "2025-04-28T21:00:48Z")
Displaying multiple number formats using a single measure Kellie Burton, Senior Quick Sight Solutions Architect, AWS This article focuses on how Amazon Quick Sight provides the flexibility to build dynamic calculated f… --- ## [Edit field colors not saving in Quick Sight visuals](https://community.amazonquick.com/t/edit-field-colors-not-saving-in-quick-sight-visuals/45503)
**Author:** [@BTuser](https://community.amazonquick.com/u/BTuser)\ **Replies:** 0\ **Last updated:** [April 28, 2025, 8:59pm UTC](https://community.amazonquick.com/t/edit-field-colors-not-saving-in-quick-sight-visuals/45503 "2025-04-28T20:59:34Z")
When editing field colors to customizable hex codes, I’m finding that the assigned colors are not being saved; even though the editing is being made in the field well. I’ve been having to re-assign the hex codes and it … --- ## [Programmatically obtaining the SPICE capacity consumed by each dataset in Amazon Quick Sight](https://community.amazonquick.com/t/programmatically-obtaining-the-spice-capacity-consumed-by-each-dataset-in-amazon-quicksight/43766)
**Author:** [@mahaswin](https://community.amazonquick.com/u/mahaswin)\ **Replies:** 0\ **Last updated:** [March 14, 2025, 5:46pm UTC](https://community.amazonquick.com/t/programmatically-obtaining-the-spice-capacity-consumed-by-each-dataset-in-amazon-quicksight/43766 "2025-03-14T17:46:58Z")
This article provides a python code which utilizes boto3 Application Programming Interfaces (API’s) to programmatically obtain the list of Amazon Quick Sight datasets, calculates the SPICE capacity consumed by each da… --- ## [Enable full object access for admin](https://community.amazonquick.com/t/enable-full-object-access-for-admin/990)
**Author:** [@ArunSanthosh](https://community.amazonquick.com/u/ArunSanthosh)\ **Replies:** 5\ **Last updated:** [February 18, 2025, 5:39pm UTC](https://community.amazonquick.com/t/enable-full-object-access-for-admin/990 "2025-02-18T17:39:28Z")
There has been multiple customer requests to provide a script that enables admin to see all the objects in their account (data sources, data sets, analyses, dashboards, themes etc) from UI. The below python script itera… --- ## [Choosing the right type of embedding for your use case](https://community.amazonquick.com/t/choosing-the-right-type-of-embedding-for-your-use-case/15236)
**Author:** [@abacon](https://community.amazonquick.com/u/abacon)\ **Replies:** 0\ **Last updated:** [June 29, 2023, 11:37am UTC](https://community.amazonquick.com/t/choosing-the-right-type-of-embedding-for-your-use-case/15236 "2023-06-29T11:37:55Z")
If you want to embed Quick Sight into your application, you’ll find that Amazon Quick Sight provides a variety of options: You can embed a whole dashboard, Or just a single visual, Or the Quick Sight Q bar to allow you… --- ## [CloudFormation Templates of the administrative console in Amazon Quick Sight](https://community.amazonquick.com/t/cloudformation-templates-of-the-administrative-console-in-amazon-quicksight/2296)
**Author:** [@Ying\_Wang](https://community.amazonquick.com/u/Ying_Wang)\ **Replies:** 7\ **Last updated:** [January 16, 2025, 2:44pm UTC](https://community.amazonquick.com/t/cloudformation-templates-of-the-administrative-console-in-amazon-quicksight/2296 "2025-01-16T14:44:09Z")
Authors: Ying Wang, Ian Liao, Maitri Brahmbhatt One year ago, Ying Wang published a big data blog and the relative open source solution of an Administrative Console Dashboard to analyze usage metrics in Quick Sight. Aft… --- ## [Quicksight and CDK](https://community.amazonquick.com/t/quicksight-and-cdk/15979)
**Author:** [@Georgios\_Mournos](https://community.amazonquick.com/u/Georgios_Mournos)\ **Replies:** 2\ **Last updated:** [December 31, 2024, 10:36am UTC](https://community.amazonquick.com/t/quicksight-and-cdk/15979 "2024-12-31T10:36:58Z")
Hi, I finished automating the generation of the Dashboards of my projects and I wrote an article in Medium to help others doing so. I also published a lot of utilities for this automation in my Github repo: I hope t… --- ## [Dynamic date hierarchy selection](https://community.amazonquick.com/t/dynamic-date-hierarchy-selection/8596)
**Author:** [@AnwarAli](https://community.amazonquick.com/u/AnwarAli)\ **Replies:** 8\ **Last updated:** [December 26, 2024, 9:28pm UTC](https://community.amazonquick.com/t/dynamic-date-hierarchy-selection/8596 "2024-12-26T21:28:05Z")
Use Case for Dynamic Date Hierarchies In Quick Sight, analysts (authors) can create dashboards with multiple visuals, which are consumed by Quick Sight end users (readers). Readers can interact with dashboards by applyi… --- ## [Time Zone Adjustments](https://community.amazonquick.com/t/time-zone-adjustments/652)
**Author:** [@Jesse](https://community.amazonquick.com/u/Jesse)\ **Replies:** 9\ **Last updated:** [December 3, 2024, 11:16pm UTC](https://community.amazonquick.com/t/time-zone-adjustments/652 "2024-12-03T23:16:56Z")
Most databases (including SPICE) store timestamps in UTC time. If you want to be able to dynamically adjust the time zone of the data displayed in your visuals for different users, we can do this using parameters and cal… --- ## [Improvements to Percent of Total Questions for Q in Quick Sight Q&A](https://community.amazonquick.com/t/improvements-to-percent-of-total-questions-for-q-in-quicksight-q-a/37784)
**Author:** [@alaresch](https://community.amazonquick.com/u/alaresch)\ **Replies:** 0\ **Last updated:** [November 4, 2024, 9:18am UTC](https://community.amazonquick.com/t/improvements-to-percent-of-total-questions-for-q-in-quicksight-q-a/37784 "2024-11-04T09:18:45Z")
Percent of total questions are a valuable way to better understand your data. For example, a call center manager might want to see what percent of calls are resolved in under 5 minutes for different cities. This can help… --- ## [Next Evolution of Q&A: V3 Model Interprets Natural Questions with Precision](https://community.amazonquick.com/t/next-evolution-of-q-a-v3-model-interprets-natural-questions-with-precision/39322)
**Author:** [@alaresch](https://community.amazonquick.com/u/alaresch)\ **Replies:** 0\ **Last updated:** [December 3, 2024, 4:28pm UTC](https://community.amazonquick.com/t/next-evolution-of-q-a-v3-model-interprets-natural-questions-with-precision/39322 "2024-12-03T16:28:38Z")
Latest LLMs powering Q model The next evolution of Q in Quick Sight Q&A is here. With the release of our V3 model, advanced large language models (LLMs) are now seamlessly integrated, delivering improved accuracy and ad… --- ## [Spice Size Estimation](https://community.amazonquick.com/t/spice-size-estimation/38792)
**Author:** [@Teepees](https://community.amazonquick.com/u/Teepees)\ **Replies:** 1\ **Last updated:** [December 3, 2024, 8:07am UTC](https://community.amazonquick.com/t/spice-size-estimation/38792 "2024-12-03T08:07:28Z")
Based on AWS documentation, to estimate Spice size each text and numeric value uses 12 bytes x no. of rows and text uses (24 bytes + text length) x no. of rows. My questions are: For text length is that the size of th… --- ## [Creating period comparisons with Quick Sight's periodOver and periodTo functions](https://community.amazonquick.com/t/creating-period-comparisons-with-quicksights-periodover-and-periodto-functions/6830)
**Author:** [@Steph](https://community.amazonquick.com/u/Steph)\ **Replies:** 32\ **Last updated:** [November 21, 2024, 12:29pm UTC](https://community.amazonquick.com/t/creating-period-comparisons-with-quicksights-periodover-and-periodto-functions/6830 "2024-11-21T12:29:53Z")
This article uses the SaaS-Sales Dataset that you can download as part of the Quick Sight Author Workshop. We will update the data to the current date so your calculations are realistic. If you do not have a Quick Sight… --- ## [Finding solutions for mismatched aggregation errors in Quick Sight calculations](https://community.amazonquick.com/t/finding-solutions-for-mismatched-aggregation-errors-in-quicksight-calculations/23425)
**Author:** [@Kellie\_Burton](https://community.amazonquick.com/u/Kellie_Burton)\ **Replies:** 3\ **Last updated:** [October 28, 2024, 10:23am UTC](https://community.amazonquick.com/t/finding-solutions-for-mismatched-aggregation-errors-in-quicksight-calculations/23425 "2024-10-28T10:23:46Z")
Finding solutions for mismatched aggregation errors in Quick Sight calculations Mismatched aggregation errors are common Quick Sight calculation errors reported by users. This error occurs when the calculated field conta… --- ## [Building Dashboards using Amazon Q in Quick Sight and Gen BI](https://community.amazonquick.com/t/building-dashboards-using-amazon-q-in-quicksight-and-gen-bi/36045)
**Author:** [@Lasantha\_Sanjeewa](https://community.amazonquick.com/u/Lasantha_Sanjeewa)\ **Replies:** 0\ **Last updated:** [September 24, 2024, 5:39pm UTC](https://community.amazonquick.com/t/building-dashboards-using-amazon-q-in-quicksight-and-gen-bi/36045 "2024-09-24T17:39:18Z")
Use Case and Problem How to build dashboards using Amazon Q in Quick Sight and Gen BI. Introduction What is Amazon Quick Sight? Amazon Quick Sight is a cloud-powered business intelligence (BI) service provided by … --- ## [Programmatically obtaining the list of Amazon Quick Sight datasets and users who have access to those datasets](https://community.amazonquick.com/t/programmatically-obtaining-the-list-of-amazon-quicksight-datasets-and-users-who-have-access-to-those-datasets/35628)
**Author:** [@mahaswin](https://community.amazonquick.com/u/mahaswin)\ **Replies:** 0\ **Last updated:** [September 20, 2024, 7:42pm UTC](https://community.amazonquick.com/t/programmatically-obtaining-the-list-of-amazon-quicksight-datasets-and-users-who-have-access-to-those-datasets/35628 "2024-09-20T19:42:28Z")
This article provides a python code which utilizes boto3 Application Programming Interfaces (API’s) to programmatically obtain the list of Amazon Quick Sight datasets and users who have access to those datasets. Our … --- ## [SPICE Usage Analytics (Dataset Sizes by User/Group/Namespace, Permissions, etc)](https://community.amazonquick.com/t/spice-usage-analytics-dataset-sizes-by-user-group-namespace-permissions-etc/15257)
**Author:** [@Neeraj](https://community.amazonquick.com/u/Neeraj)\ **Replies:** 4\ **Last updated:** [September 2, 2024, 7:28am UTC](https://community.amazonquick.com/t/spice-usage-analytics-dataset-sizes-by-user-group-namespace-permissions-etc/15257 "2024-09-02T07:28:24Z")
Use Case Customers at times have challenges in understanding and obtaining information about the SPICE consumption details for a Quick Sight account. The maximum SPICE capacity and SPICE capacity consumed in a Quick Sig… --- ## [Programmatically obtaining the list of Amazon Quicksight dashboards and users who have access to those dashboards](https://community.amazonquick.com/t/programmatically-obtaining-the-list-of-amazon-quicksight-dashboards-and-users-who-have-access-to-those-dashboards/33287)
**Author:** [@mahaswin](https://community.amazonquick.com/u/mahaswin)\ **Replies:** 0\ **Last updated:** [July 31, 2024, 8:53pm UTC](https://community.amazonquick.com/t/programmatically-obtaining-the-list-of-amazon-quicksight-dashboards-and-users-who-have-access-to-those-dashboards/33287 "2024-07-31T20:53:12Z")
Programmatically obtaining the list of Amazon Quicksight dashboards and users who have access to those dashboards Mahaswin Ramalingam Balaji, Cloud Support Engineer Use Case and Problem This article provides a python… --- ## [Level-Aware Calculations: Tips and Best Practices](https://community.amazonquick.com/t/level-aware-calculations-tips-and-best-practices/17936)
**Author:** [@David\_Wong](https://community.amazonquick.com/u/David_Wong)\ **Replies:** 7\ **Last updated:** [July 30, 2024, 3:40pm UTC](https://community.amazonquick.com/t/level-aware-calculations-tips-and-best-practices/17936 "2024-07-30T15:40:02Z")
Level-Aware Calculations (LAC) are powerful functions that allow us to perform calculations at a granularity level which is different from the granularity of our datasets and/or visuals. The sample dataset referenced… --- ## [Chrome Extension: Quick Sight Visual Performance Tuning/Debugging](https://community.amazonquick.com/t/chrome-extension-quicksight-visual-performance-tuning-debugging/32321)
**Author:** [@robdhondt](https://community.amazonquick.com/u/robdhondt)\ **Replies:** 0\ **Last updated:** [July 9, 2024, 9:17am UTC](https://community.amazonquick.com/t/chrome-extension-quicksight-visual-performance-tuning-debugging/32321 "2024-07-09T09:17:35Z")
Hi Quick Sight Community - I created this open source chrome extension to help tune and debug your Quick Sight dashboards and analyses. I hope you find it helpful! Disclaimer: This evolved from me playing with the new … --- ## [Quick Sight Dataset Joins: Explained](https://community.amazonquick.com/t/quicksight-dataset-joins-explained/32202)
**Author:** [@abacon](https://community.amazonquick.com/u/abacon)\ **Replies:** 0\ **Last updated:** [July 4, 2024, 4:18pm UTC](https://community.amazonquick.com/t/quicksight-dataset-joins-explained/32202 "2024-07-04T16:18:44Z")
In Amazon Quick Sight you can create a (child) dataset by joining existing (parent) datasets together. When joining datasets in this way, there are some key concepts to be aware of: A dataset is considered same-source … [Previous page](https://community.amazonquick.com/c/learning-center/articles/18.md) [Next page](https://community.amazonquick.com/c/learning-center/articles/18.md?page=2)