# Can I have a dimension as a result of a calculated measure (i want to use in a donut chart)?

**URL:** <https://community.amazonquick.com/t/can-i-have-a-dimension-as-a-result-of-a-calculated-measure-i-want-to-use-in-a-donut-chart/6060>\
**Category:** Q&A\
**Tags:** calculations, quick-sight\
**Created:** [September 15, 2022, 10:04am UTC](https://community.amazonquick.com/t/can-i-have-a-dimension-as-a-result-of-a-calculated-measure-i-want-to-use-in-a-donut-chart/6060 "2022-09-15T10:04:11Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Eleri](https://avatars.discourse-cdn.com/v4/letter/e/b5e925/32.png) [@Eleri](https://community.amazonquick.com/u/Eleri)\
**Post date:** [September 15, 2022, 10:04am UTC](https://community.amazonquick.com/t/can-i-have-a-dimension-as-a-result-of-a-calculated-measure-i-want-to-use-in-a-donut-chart/6060/1 "2022-09-15T10:04:12Z")

</div>

If i use count\_distinct() in calculate measure then it returns a measure which I can’t then use in a donut chart.

e.g. i want distinct usage days per user. I have:  
userID, usage\_date  
1,‘2022-09-01’  
2,‘2022-09-02’  
1,‘2022-08-03’  
2,‘2022-09-02’  
2,‘2022-09-02’

I’d like to have it grouped so:  
userID, CF\_UsageDaysCount  
1,2  
2,1

Is the only way to have it pre-aggregated in the source dataset? As I need the same data also at detail level.

---

<div class="post-metadata">

**Author:** ![EvaB](https://avatars.discourse-cdn.com/v4/letter/e/87869e/32.png) [@EvaB](https://community.amazonquick.com/u/EvaB)\
**Post date:** [September 15, 2022, 1:28pm UTC](https://community.amazonquick.com/t/can-i-have-a-dimension-as-a-result-of-a-calculated-measure-i-want-to-use-in-a-donut-chart/6060/2 "2022-09-15T13:28:34Z")

</div>

Why can’t you use it in a donut chart ? if you use the measure as a value, you can add “userID” as a group/color. If you want to use the measure as the group/color, I think you need to do it in the dataset

---

<div class="post-metadata">

**Author:** ![Max](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/max/32/2288_2.png) [@Max](https://community.amazonquick.com/u/Max)\
**Post date:** [September 19, 2022, 6:26pm UTC](https://community.amazonquick.com/t/can-i-have-a-dimension-as-a-result-of-a-calculated-measure-i-want-to-use-in-a-donut-chart/6060/3 "2022-09-19T18:26:19Z")

</div>

@Eleri

Yes @EvaB is correct.

Here is how it might look for your use case. You don’t have to make a count\_distinct calculated field. You just need to add the usage\_date as the value and take the count distinct value of it.

 ![image](https://d1wl4jav5dp96l.cloudfront.net/original/2X/3/3da2fc21abe41867d32b4f78dc4a7c9d26da3536.png)