4 Replies Latest reply on Oct 7, 2018 9:13 PM by meenu choudhary

    Show sum based on current week

    Srinath Radhakrishnan

      Hi All,

      I'm, building a dashboard that would need to be refreshed everyday. I have data set with following columns [Sales id],[date]. I have target of 200 sales/week.

       

      Ultimately, I want (1 - count(# of sales in this week)/200) * 100 -> gives me percentage of sales to be achieved by this week. Kindly help as I'm a newbie to the tool with very minimal experience.