# How can I view and compare usage data with 3 Dates in one axis

**URL:** <https://community.amazonquick.com/t/how-can-i-view-and-compare-usage-data-with-3-dates-in-one-axis/6817>\
**Category:** Q&A\
**Tags:** visuals, date, calculations, quick-sight\
**Created:** [October 13, 2022, 2:02am UTC](https://community.amazonquick.com/t/how-can-i-view-and-compare-usage-data-with-3-dates-in-one-axis/6817 "2022-10-13T02:02:54Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![sharmagneo](https://avatars.discourse-cdn.com/v4/letter/s/8e8cbc/32.png) [@sharmagneo](https://community.amazonquick.com/u/sharmagneo)\
**Post date:** [October 13, 2022, 2:02am UTC](https://community.amazonquick.com/t/how-can-i-view-and-compare-usage-data-with-3-dates-in-one-axis/6817/1 "2022-10-13T02:02:55Z")

</div>

Hi I would like to view 3 product usage metrics in one graph in a time series line graph, e.g. product usage for A vs B vs C. each product has its own date fields, and by that I need to combine all dates in one field for me to plot it in one axis, is there a way I can do this via calculated field or in alternative way? Thanks

---

<div class="post-metadata">

**Author:** ![emilyzhu](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/emilyzhu/32/255_2.png) [@emilyzhu](https://community.amazonquick.com/u/emilyzhu)\
**Post date:** [October 13, 2022, 7:33am UTC](https://community.amazonquick.com/t/how-can-i-view-and-compare-usage-data-with-3-dates-in-one-axis/6817/2 "2022-10-13T07:33:08Z")

</div>

Hi @sharmagneo, you need to bring all three products usage data into one table. You can use the date field as the key to join the three tables, if the dates are sparse (meaning not all dates have data), then you need to think about aggregate each table to a higher granularity, such as week or month. In that case, you will have monthly usage data for each product, then you can join them together to get the line chart.

---

<div class="post-metadata">

**Author:** ![sharmagneo](https://avatars.discourse-cdn.com/v4/letter/s/8e8cbc/32.png) [@sharmagneo](https://community.amazonquick.com/u/sharmagneo)\
**Post date:** [October 13, 2022, 9:38am UTC](https://community.amazonquick.com/t/how-can-i-view-and-compare-usage-data-with-3-dates-in-one-axis/6817/3 "2022-10-13T09:38:08Z")

</div>

@emilyzhu Ok understand, but what if I also want to get the usage for daily? can I also view that on that manner? or this is only possible if there are available data for all dates?

---

<div class="post-metadata">

**Author:** ![emilyzhu](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/emilyzhu/32/255_2.png) [@emilyzhu](https://community.amazonquick.com/u/emilyzhu)\
**Post date:** [October 16, 2022, 5:36am UTC](https://community.amazonquick.com/t/how-can-i-view-and-compare-usage-data-with-3-dates-in-one-axis/6817/4 "2022-10-16T05:36:02Z")

</div>

You still can join by date, and depending on how sparse of your data, it may cause Nulls in the result table.