4 Replies Latest reply: Jul 11, 2017 3:58 AM by Juraj Misina RSS

    How to use KPIs (calculations) as filter

    Philipp Sauren

      Hi Guys,

       

      I'm currently calculating some values, used as KPIs; in this case I have to count invoices with specific number of line items to create several categories. This works well, when setting it up as a KPI. But I would like to have this as a clickable filter; when clicking the KPI, I would like to filter the related invoices. This would allow me to understand the purchasing structure of my customers. Below you can see an example calculation:

      COUNT(DISTINCT {<[Invoice ID] ={"=COUNT([Invoice row-nr])>2 and COUNT([Invoice row-nr])<=5 "}>} [Invoice ID])

       

      Any idea how I could set this up? Or any work around available?

       

      Thanks in advance!

       

      Philipp