Date filter different when use list and time frame

Comments

8 comments

  • Avatar
    Michael Becker

    Hi Lihn,

    for the Last Year filter, go to custom tab at the bottom, click Test button and see what values it brings. I would also add transaction date to the Pivot to verify what is happening. 

    Michał

    1
    Comment actions Permalink
  • Avatar
    Linh Cao

    Hi Michael, 

    Last year brings right values, but 2017 doesn't.
    I add transaction date and get this when filter 2017, totally wrong.

    Thanks,
    Linh

    0
    Comment actions Permalink
  • Avatar
    Michael Becker

    H Lihn,

    is it possible that you are using two different Dates here?

    0
    Comment actions Permalink
  • Avatar
    Linh Cao

    Hi Michael,

    Could you please explain more about "two different Dates".
    I only use 1 dimension date table.

    Thanks,

    0
    Comment actions Permalink
  • Avatar
    Michael Becker

    I just wanted to ensure that the filters you used in those two calculations are based on the same Date Field from ElastiCube. It looks like those might be two different columns. Also Do you have any other filters in place that are affecting this Pivot?

    1
    Comment actions Permalink
  • Avatar
    Linh Cao

    I have only 1 date field in ElastiCube and there's no other filter.
    Thanks,

    0
    Comment actions Permalink
  • Avatar
    Michael Becker

    I'd suggest to rise a ticket with support then Lihn. It looks very strange, and from what you wrote it all should look fine with this setup. 

    2
    Comment actions Permalink
  • Avatar
    Linh Cao

    Thank you so much for helping .

     

    0
    Comment actions Permalink

Please sign in to leave a comment.