Placing YTD,MTD,QTD,PyYTD in a single set using variables

[Harry_FF]

Hi guys, 

want to place YTD,MTD,PyYTD..etc.... in to a variable Input chart, so If I select YTD then data should be filter Year to date, N MTD then Month to date.

Normal Calculation for YTD,MTD.....

YTD

 Count({< datefield 1= {“ >=$(=Yearstart(Today())) <Today()”}  >} Items )

MTD

Avg ({< datefield 2= {“ >=$(=MonthaStart(Today())) <Today()”}  >} Profits )

Prev YTD

Sum({< datefield 3= {“ >=$(=YearStart(Today(),-1))) <$(=AddYears(Today(),-1))”}  >} Sales )

Instead of writing Them separately . Now I have many charts with Different Date fields  which are Of same format. 

Now I create a empty variable (vDtselect) to place in variable input chart . Now I add Values in this chart as below 

Label YTD 

Value: ‘{“ >=$(=Yearstart(Today())) <Today()”}‘

Label MTD 

value: ‘{“ >=$(=MonthaStart(Today())) <Today()”} ‘

Label Py YTD

Value: ‘{“ >=$(=Yearstart(Today(),-1)) <=$(=Addyears(Today(),-1)”}‘

Label Alldates

Value:  null

now I place  variable in set as below 

chart1 

Count ({< Datefield 1=  $(vDtselect) >} Items) 

chart2

Sum ({< Datefield 2 = $(vDtselect) >} Sales) ........ so on  

now change the Values using Variabie input Chart to get Different Dateperiods .  Similar can Have last 6 months, QTD, Last week So on.... To filter required Date periods for the multiple Charts. I found this Useful and Posted 🙂

Regards ,

Harish .