Missing dates - but not

damen
damen Contributor
in Charting

Hi everyone,

We have a few cards that have quite a bit of data to them. Over 1m rows in this case. When we open up the card view and try to find the date in the scroll menu, it doesnt show up. The saving grace is when we type it in, it works and is there (plus it shows in the card it self.)

I am wondering, is there a way to sort the filters?

I know I can go into analyzer and sort the card, this is how it is currently set but as of now, I have not seen anything to change this setting.

image.png
image.png

Thanks in advance

If this helps, feel free to agree, accept or awesome it!

Tagged:

Best Answer

  • damen
    damen Contributor
    Answer ✓

    hmm. I am not sure. it is showing as a date field in analyzer. I do think having the ability to filter like that could be helpful though.

    image.png

    If this helps, feel free to agree, accept or awesome it!

Answers

  • ColemenWilson
    ColemenWilson Coach

    It looks like your date value is actually a string. You can convert it to a date with a beast mode:

    DATE(`yourDateField`)

    Once you do that, the quick filter control changes and you shouldn't have the issue you've been experiencing because your quick filter control will look like this:

    Screen Shot 2025-02-04 at 9.00.00 AM.png

    If I solved your problem, please select "yes" above

  • damen
    damen Contributor
    Answer ✓

    hmm. I am not sure. it is showing as a date field in analyzer. I do think having the ability to filter like that could be helpful though.

    image.png

    If this helps, feel free to agree, accept or awesome it!

Categories