0

Date filter causing values to go to 0

I have recently build a dashboard and put in a couple of dropdown filters along with a date filter. However, whenever I apply the date filter to klips that have a formula in their data tab (ex. sum column/ sum column) it returns a value of zero. The date filter works for all of the klips that only reference one column of data so I know that it is working. I was wondering if anybody else has encountered this problem? 

 

1 comment

  • Avatar
    Parker Selman Official comment

    Hi Tyler, 

    Thanks for the post! 

    To get your columns working as you've described, you'll need to get rid of the SUM functions in the series that contains them. SUM returns 1 value only, and as such this 1 value will not be displayed properly across your X axis since your filters are expecting to filter on a list equal to the size of the data set in the filter. To correct this, you can set up the formula as F:F/I:I instead of the ratio of their sums. 

    This should result in the values you're looking for. 

    Hope this helps! Please let me know if you have any questions around this.

Please sign in to leave a comment.