Charting

Charting

Missing dates - but not

Contributor

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.

Thanks in advance

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

Tagged:

Best Answer

  • 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.

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

Answers

  • 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:

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

  • 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.

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

Welcome!

It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
Sign In