Forum Discussion
Multiple date fields in a visual that have a shared axis from calendar table
Hi guys,
got a pick of a head scratcher.
I need to make a visual that shows how many sales have progressed in a month this year.
I have the dates in which they moved but there are different sale stages so i have 6 different columns with dates.
what i need is to put them in a stacked column chart with the Shared Axis as the Calendar Table 'Period' e.g. Dec-21.
How can i do it so that each calendar period has only the dates in which the sales entered that stage.
like this:
| SS1 | SS2 | SS3 | SS4 | SS5 | SS6 |
| 07/06/2021 | |||||
| 15/07/2021 | |||||
| 20/08/2021 | |||||
| 17/10/2021 | |||||
| 30/10/2021 | |||||
| 24/11/2021 |
i am unsure if there will be multiple dates in a single row - if there can only be 1 can simply merge the columns into one and go from there but if there is multiple in a row, what should i do
this is how the data looks - i want each of those dates to only go into the period it relates to
i want it to show like this:
how can i do this? is this possible?
1 Reply
- amitchandakSuper User
paulfink , for this one it is better to unpivot the data so that you will get stage and date as columns