How to show data by selectig different calender dimension

yogitamehta10 — Thu, 02 May 2019 14:11:32 GMT

Hi All,

I have a sheet which has different chart KPIs , bar and pie etc. and on top we have three selection , show data by Quarter , Month or day. As of now we are using different if condition in every chart to show the selected set of data.

if('$(vselection)'='Month',
Sum($ (suits),

if('$(vselection)'='Quarter',Sum($ (suits),

if('$(vselection)'='FY',
Sum($ (suits),
)))

is there any other way we can achieve this because I think that can improve performance.

TIA!

topic How to show data by selectig different calender dimension in App Development

How to show data by selectig different calender dimension