Forum Discussion

paulfink's avatar
paulfink
Post Patron
4 years ago

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:

 

 

SS1SS2SS3SS4SS5SS6
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?