Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Week Number data on chart duplicates

Topic Labels: Interface Designer
1510 2
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