3 Replies Latest reply on Feb 24, 2015 10:14 PM by Christian Berg

    Prompt for analysis column derived by a formula

    user1106547

      I have a dashboard that links to an analysis with various columns and prompts.

       

      i have one column in the analysis derived from a formula:

       

      CASE

      WHEN

      "Ordering department (request)"."Department code" = 'ED' then 'DEM'

      ELSE

      "Patient status"."In-/outpatient (1)"

      END

       

      The formula gives 3 options - DEM, Inpatient and Outpatient.

       

      I am not sure how to create a dashboard prompt for this  - any ideas

       

      thanks