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)
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
