cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SimonGrams Regular Visitor
Regular Visitor

Numeric range slicer - YearWeek

Hello,

 

I want to use a YearWeek (201701 - 201752) column as a numeric range slicer.

Works fine, but it displays values > 201752. Values like 201753 - 201799 do not make sense in this use case.

 

I do know why these values are displayed (although they are not in the data), but I do not want them Smiley Happy

 

Is there any possbility to 'hide' values that are not in the data/to 'hide' those NULL-values?

 

Cheers

3 REPLIES 3
Super User
Super User

Re: Numeric range slicer - YearWeek

I don't know why those numbers are included. Can you provide sample data or more details?


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


SimonGrams Regular Visitor
Regular Visitor

Re: Numeric range slicer - YearWeek

Hey @Greg_Deckler

I assumed those values appear because I formatted the column as whole number (to be able to use it in a numeric slicer).

 

SampleData

 

 

Community Support Team
Community Support Team

Re: Numeric range slicer - YearWeek

Hi @SimonGrams,

 

A range slicer will display continual values. When you add a numeric field into it, it would show the min and max value as start and end point, then, any values between these two are available and selectable. Unfortunately, it is not able to change the default behaviour now.

 

Regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.