4 Replies Latest reply: Mar 16, 2018 10:33 AM by Ale Kong RSS

    Editing expression to grab QTD data

    Ale Kong

      Hi all,

       

      Newbie here trying to edit an existing expression below from a table. The current expression is grabbing data YTD. The new ask is for the data to be grabbed QTD. How would I adjust the expression to properly grab QTD data?

       

      if([_dimension2]='Volume -Percentage of expedited reviews',

      Num(sum({<Date_new={'>=$(vYTDCYStart)<$(vYTDCYEnd)'},Year_new=,Month_new=,Quarter_new=,Product=,Franchise=>}[Expedited Review Jobs])
      /
      count({<Date_new={'>=$(vYTDCYStart)<$(vYTDCYEnd)'},Year_new=,Month_new=,Quarter_new=,Product=,Franchise=>}new_job_count),'##.0%'),
      if([_dimension2]='Quality -Percentage of jobs failing QA',
      num((sum({<Date_new={'>=$(vYTDCYStart)<$(vYTDCYEnd)'},Year_new=,Month_new=,Quarter_new=,Product=,Franchise=>}[QA Failed])
      /
      (sum({<Date_new={'>=$(vYTDCYStart)<$(vYTDCYEnd)'},Year_new=,Month_new=,Quarter_new=,Product=,Franchise=>}[QA Failed])
      +sum({<Date_new={'>=$(vYTDCYStart)<$(vYTDCYEnd)'},Year_new=,Month_new=,Quarter_new=,Product=,Franchise=,[QA Review Cycle Count]={'1'}>}[QA Review Cycle Count]))
      ),'##.0%'),
      if([_dimension2]='Cycle Time -Average cycle time – Print',

      round(avg({<Date_new={'>=$(vYTDCYStart)<$(vYTDCYEnd)'},Year_new=,Month_new=,Quarter_new=,Medium={'Print/Physical'},Product=,Franchise=>}[FF - Time to AFU (Days)])),
      if([_dimension2]='Cycle Time -Average cycle time – Digital',
      round(avg({<Date_new={'>=$(vYTDCYStart)<$(vYTDCYEnd)'},Year_new=,Month_new=,Quarter_new=,Medium={'Digital'},Product=,Franchise=>}[FF - Time to AFU (Days)]))
      ))))

       

      Thanks,

      Ale