Calc field for different month dates

Q&A
,
1

Hi,

I have one data point for each month for example Aug - 123, Sept - 234, October - 231, these months are each individual columns.

I want to combine them into one calc field to plot them onto X axis for different data points.

For example, these months vs it’s values. how can I achieve this?

2

Hi @chaitea

If you are getting this from a database you are better served doing an UNPIVOT to convert the columns to rows as you create the dataset.

Regards,

Giri

3

Hi thank you Giri, can you share an example?

4

Hi @chaitea,
Following up here as it’s been awhile since last communication; are you still working on this case or were you able to implement a work around in the interim?

In regards to achieving through Quick Sight, QS does not allow you to plot multiple columns on same axis; so by the way it sounds like your current dataset structure is, this will not be possible.
Adding to what Giri mentioned above, the easiest way to complete this would be to edit your dataset so that all month values are within the same column.

Let us know if you have any additional questions; if we do not hear back within the next 3 business days, I’ll close out this topic.

Thank you

5

Hi @chaitea,

Since we have not heard back further, 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.

Thank you!