Week Number data on chart duplicates

[pjwallace1]

I used a calculation to track the week (in a cal year) that a data point was input into my base so I can track my sales team meeting their weekly quota.  When I charted this in the dashboard, multiple weeks (16, 17, 17, 18, 18, etc.) showed up in the chart (pic 1).  If I spread out this report in the db, even more weeks show up (pic 2)

[TheTimeSavingCo]

Any chance you could provide a screenshot of your data as well?

[Alexey_Gusev]

Hi,
just a guess - you get floating point numbers, which are all different, but shown as integers, with some 'matches'. To check - try to change formatting to decimal, with a few digits after point. To fix - wrap result in INT( ) or other rounding function.
Note that sometimes in rollup result you can get a integer-like number, but with +-0,00...001 in 15-16th digit.  You can't see this difference even with maximum precision, but it's clearly seen when you try to filter exact number. Try to filter with week=17, week=18 etc and count. Also try week>18, week>19
For example, same issue with percent