2 Replies Latest reply on Nov 29, 2018 2:47 PM by Naren Deevakonda

    Display nothing when selecting multiple dates from date range filter

    Naren Deevakonda

      Hello all,


      I have created a dashboard for example with 3 worksheets from 2 different datasets. I am using a date filter from one of the worksheet and applying it to filter all the other in the dashboard. Everything works well until now.


      worksheet-1 displays shirts added to inventory each day which is coming from column - shirts added

      worksheet -2 displays shirts sold each day which is coming from column - shirts sold

      worksheet -3 displays total items left each day which is coming from column - total items


      Now the issue is that i'm using a relative date filter for the users to select a single day or a range of days.


      When a date range is selected workseet 1 and 2 show a cumulative of shirts added and sold which is right but worksheet 3 displays a cumulative total of each day which isn't a right number.


      So for worksheet 3, I'm trying to only display numbers when a single date is selected and nothing when a range of dates are selected. Is there a calculation I can use which counts the days selected by the filter. (i.e) when filter date range > 1 then display nothing.


      Hope it makes sense. Looking forward to hearing from anyone.