Forum Discussion

Boja's avatar
Boja
Advocate II
8 years ago
Solved

Building a Custom KPI filter

Hello,  I got stuck, so I would greatly appreciate your wisdom.   I am trying to create a metric TREND as a calculated column so i can create a filter later from it. It works well as a measure, bu...
Need Help
  • Boja's avatar
    Boja
    8 years ago

    Thanks, Prateek!

     

    I realise that this problem is solved by creating calculated table (including only yesterday values) to avoid having emtpy rows. Apparently they were the sourcse of circular dependency. It works well now. Thanks :)

prateekraina's avatar
prateekraina
Memorable Member
8 years ago

Hi Boja,

 

Please go thorugh this article which explains why Circular Dependency occurs and how you should avoid it.

 

Prateek Raina

Boja's avatar
Boja
Advocate II
8 years ago

Thanks, Prateek!

 

I realise that this problem is solved by creating calculated table (including only yesterday values) to avoid having emtpy rows. Apparently they were the sourcse of circular dependency. It works well now. Thanks :)