# How to Visualize Percentages of Categories Over Time?

**URL:** <https://community.amazonquick.com/t/how-to-visualize-percentages-of-categories-over-time/38353>\
**Category:** Q&A\
**Tags:** visuals, analysis, calculations, Business-Intelligence-Engineer, quick-sight\
**Created:** [November 13, 2024, 3:00pm UTC](https://community.amazonquick.com/t/how-to-visualize-percentages-of-categories-over-time/38353 "2024-11-13T15:00:21Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Marcelo\_Antonio\_Pasq](https://avatars.discourse-cdn.com/v4/letter/m/43a26b/32.png) [@Marcelo\_Antonio\_Pasq](https://community.amazonquick.com/u/Marcelo_Antonio_Pasq)\
**Post date:** [November 13, 2024, 3:00pm UTC](https://community.amazonquick.com/t/how-to-visualize-percentages-of-categories-over-time/38353/1 "2024-11-13T15:00:21Z")

</div>

Hello, everyone.

I have three columns: cd\_store\_id, cd\_cluster, and dt\_created\_at. Using these, I want to create a line chart where each line shows the percentage of each cd\_cluster relative to the total number of cd\_clusters (which matches the total count of cd\_store\_id).

Each cd\_store\_id has a unique line and a unique cd\_cluster, so I think you guys can ignore this column.

Similar to the image below, but instead of bars, I need lines for each cd\_cluster, and instead of raw counts, I need the percentage of the total for each month.

 ![image](https://d1wl4jav5dp96l.cloudfront.net/original/3X/c/9/c9222eceb7f8b211437e2b1ea971cea41d15c24e.png)

---

<div class="post-metadata">

**Author:** ![Giridhar.Prabhu](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/giridhar.prabhu/32/27789_2.png) [@Giridhar.Prabhu](https://community.amazonquick.com/u/Giridhar.Prabhu)\
**Post date:** [November 13, 2024, 4:58pm UTC](https://community.amazonquick.com/t/how-to-visualize-percentages-of-categories-over-time/38353/2 "2024-11-13T16:58:17Z")

</div>

Hi @Marcelo_Antonio_Pasq

Welcome to the Quick Sight Community!

There is nice article in the learning section that could guide you to computive Percentage of Total calculation and use the same in your desired visualization.

> [@Level-Aware Calculations: Tips and Best Practices](https://community.amazonquick.com/t/level-aware-calculations-tips-and-best-practices/17936):
>
> 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 by this article is a dataset of product orders placed by customers. Each order can contain multiple products and each product in an order has a unique Line Item ID. Each row of our dataset represents one line item but we want to pe…

Regards,  
Giri

---

<div class="post-metadata">

**Author:** ![Brett](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/brett/32/36494_2.png) [@Brett](https://community.amazonquick.com/u/Brett)\
**Post date:** [November 27, 2024, 4:26pm UTC](https://community.amazonquick.com/t/how-to-visualize-percentages-of-categories-over-time/38353/3 "2024-11-27T16:26:43Z")

</div>

Hi @Marcelo_Antonio_Pasq,  
It’s been awhile since we last heard from you, did you have any additional questions regarding your post?

If we do not hear back within the next 3 business days, I’ll close out this topic.

Thank you!

---

<div class="post-metadata">

**Author:** ![Brett](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/brett/32/36494_2.png) [@Brett](https://community.amazonquick.com/u/Brett)\
**Post date:** [December 2, 2024, 7:11pm UTC](https://community.amazonquick.com/t/how-to-visualize-percentages-of-categories-over-time/38353/4 "2024-12-02T19:11:25Z")

</div>

Hi @Marcelo_Antonio_Pasq,  
Since we haven’t heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for relevant information if needed.

Thank you!