4 Replies Latest reply: Apr 4, 2016 9:32 AM by Sunny Talwar RSS

    How to filter the data to represent in graph

    Dinesh Gupta

      Hi All,

       

      I have just started working on QV couple of days back. Till now I am very much fine with Ok with creating basic visualization. But now I got stuck in one place

      Lets Suppose

       

      I have 4 columns in my data 1. Recovery State 2. Month 3. No. of transactions and 4. Total Amount.

      Recovery State have states like Write Off, Refunded, Charge back etc.

       

      I am trying to create a chart for Month wise transactions however I want chart to calculate the data only for Write Off state.

       

      I can easily do it by creating list box and select Write Off in that however I dont want to create a list box instead I want to put condition by any formula in chart only that it pick data for only given state

       

      Thanks

      Dinesh