Forum Discussion

401evolr's avatar
401evolr
Icon for Helper II rankHelper II
6 years ago

Filter/slicer problems with calculated columns?

I'm trying to apply filters or slicers to my data in the report view without luck. Might have something to do with calculated columns?

 

I have one table that is a list of work for the year (2266 jobs total across all 'programs' and 'areas'):

 

 

I created a second table (with all calculated columns) to calculate how many jobs need to be done each day such that they're all complete by end of year. Then you can see how many jobs should be remaining on each calendar day. This is shown by the target 'Burndown' column:

 

 

In the report view, this target burndown line plots nicely (showing 2266 jobs on Jan 1 and 0 on Dec 31). However, I'm trying to add filters or a splicer so that I can see a burndown line only for jobs with a certain "program" or "area" attribute. As you can see, I've set up a filter to show only "south" areas and "instrument" programs - yet the burndown line remains unchanged.

 

 

Is there a reason the filters aren't applying to my calculated columns?

12 Replies

  • nandukrishnavs's avatar
    nandukrishnavs
    Icon for Community Champion rankCommunity Champion

    401evolr 

     

     

    You have to enable the relationship between these two tables.



    Did I answer your question? Mark my post as a solution!
    Appreciate with a kudos
    🙂

    • 401evolr's avatar
      401evolr
      Icon for Helper II rankHelper II

      Yes, here are the relationships I have set up:

       

      • 401evolr's avatar
        401evolr
        Icon for Helper II rankHelper II

        Thanks for the replies nandukrishnavs and amitchandak 

        Changing the relationship to "bi-directional", I'm able to filter it somewhat, but it's incorrect. It changes the date along the x-axis, whereas I'm expecting it to change the number of jobs shown along the Y-axis: