Skip to main content

Hi I am trying to create a line chart to compare avg throuput time between two activities how it fluctuates between different months. 

My Dimesion is this formula: ROUND_MONTH("AE_process_dataset_with_realistic_time_variabilities"."TIMESTAMP")

 

My KPI formula is : 

PU_AVG (DOMAIN_TABLE ("AE_process_dataset_with_realistic_time_variabilities_CASES"."CASE ID" ),

 (

  CALC_THROUGHPUT (

    FIRST_OCCURRENCE U 'Arrival at A&E' ]

    TO

    LAST_OCCURRENCE _ 'Initial Assessment' ] ,

    REMAP_TIMESTAMPS (

      "AE_process_dataset_with_realistic_time_variabilities"."TIMESTAMP" ,

     MINUTES

    )

  )

)

)

 

But I only get a graph for the first month: 

 

Please can someone advise what I am doing wrong?

Be the first to reply!

Reply