Help

Re: Week Number data on chart duplicates

394 0
cancel
Showing results for 
Search instead for 
Did you mean: 
pjwallace1
4 - Data Explorer
4 - Data Explorer

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)

Screenshot 2023-06-08 at 4.58.56 PM.png

Screenshot 2023-06-08 at 5.01.03 PM.png

2 Replies 2

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

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
Снимок экрана 2023-06-09 202346.png