Create toggle between date selection of by month or by quarter
I have recently been tasked with adding a quarter view to a financial application set.
Currently it is shown by month, I have read that to create a toggle i need to do =if(vToggle=0,1,0) However in this case what is the vToggle as the two date items are _MON for month and_Q for quarter. Im a little confused as how to create a proper variable to capture both. I attached a screen shot of the values.
Re: Create toggle between date selection of by month or by quarter
Keep your vToggle variable toggle and add both quarter and month as dimensions into your chart/table. In the dimension properties check the conditional show for both dimensions and adjust the show conditions as below.
For the quarter dimension your type =if($(vToggle)=1, true(), false())
For the month dimension conditional show you type =if($(vToggle)=0, true(), false())