Forum Discussion

AndyTrezise's avatar
AndyTrezise
Advocate IV
8 years ago
Solved

bciCalendar multi view

I'm using the bciCalendar to view information about current month's data based on two slicers that allow users to select year and month.

 

I want to create a 2nd / 3rd version of the same visual that show 1 and 2 months ahead.

 

I first created new columns in my underlying table that computed date + 1 month & date + 2 months ( Date.AddMonths([originaldate],1) ).

 

So I in essence have 3 columns - originaldate, dateplus1month, dateplus2months

 

I drop dateplus1month onto my second visual (in place of original date) and dateplus2months onto the third visual.

 

Problem is, by using the slicer I limit the results to a single month so never return any rows for display in my other two visuals.

 

I think I somehow need to disconnect all the visuals from the slicers and computer the date seperately - then somehow create 3 new datasets that can be applied to my hree visuals.

 

Not sure if this is correct or not?

 

Any help greatly appreciated.