3 Replies Latest reply: Sep 20, 2010 9:17 AM by jensfpk RSS

    Filtering values in a chart with a where type function

      Hi all,

      Ive been trying to figure out how to write an expression to only display certain data in a chart, without having to select that option from a list box.

      Lets say I have workorder table and there are 2 work types: EM and PM.

      I want the chart to only show a count of EM ones, without having to select EM from a list box anywhere.

      Ive tried to use an If: If(Worktype='EM',sum(Workordercounter)), but it didn't work.

      I also tried to use some form of where clause: sum(Workordercounter) where Worktype='EM', but this didn't work.

      Thanks