cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
_chris_ Frequent Visitor
Frequent Visitor

Top 1 visual filter shows different results with Integer/String

Hi, I have a column called Year. Data exists from 2004-2018. Initially it was a number. However, when I used this to filter in a Top 1 visual filter it showed the values for 2017. When I switched it into a text field, it shows the values for 2018. Now I do have a solution but still do not understand why. Also with a number I expected to get the 2018 values. Want to understand this.

 

Thx

 

BR Christian

Perhaps I need to add the I want to show the revenue (which is another column) on a card always for the actual year. Instead of creating a new measure.

4 REPLIES 4
Super User
Super User

Re: Top 1 visual filter shows different results with Integer/String

Hi @_chris_, could you share your file?

 


 


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


Proud to be a Datanaut!  

Community Support Team
Community Support Team

Re: Top 1 visual filter shows different results with Integer/String

Hi @_chris_

 

I cannot reproduce the same issue as you said. Could you share more about your data sample?

1.png

 

Regards,

Cherie

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
_chris_ Frequent Visitor
Frequent Visitor

Re: Top 1 visual filter shows different results with Integer/String

Sorry for bothering you. I could not reproduce the issue. BR Chris

Community Support Team
Community Support Team

Re: Top 1 visual filter shows different results with Integer/String

Hi @_chris_

 

Do you need any other help about this question? 

 

Regards,

Cherie

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