1 Reply Latest reply on Jul 6, 2018 9:39 AM by Deepak Rai

    How do I use LOD calculation so it doesnt affect my filters on my view

    Rita Bota

      Hi Team,

       

      I have a dashboard i have developed on an LOD calculation but the problem is that this LOD EXPRESSION  is cousing my filters to be inactive which is something i'm unable to fix. Please any idea on how to rewrite the syntax?? I want to get the historical avg and i want to fix it at the monthly level.

      Here is the syntax:

       

      { FIXED      DATEPART('month', [Booking Start1]): AVG(

       

      { INCLUDE     DATETRUNC('month',[Booking Start1]):COUNTD([Booking ID])})}