I'm doing a calculation on arcgis insigths and it's counting repeated values, I just need to count the distinct values. Conformity in the attached image, which does not have functions for calculating different values. With that, the result of the calculation is wrong, counting as duplicities.
When you create a chart like a column chart, it sums all of the records, even if they are repeating. Have you tried this workflow?
1) Create a summary table with say, a year and incident value. This cerates the summary table (obviously), but it also creates a resulting dataset that is available in the Insights data pane. You can also choose the summary statistic (sum, avg, percentile, etc)
2) Use the resulting summary table dataset (in the data pane) to create your column chart
The above will still aggregate all of the values, but the table will contain one record for each unique combination of values. If this isn't a suitable method, is it possible that you could clean the data to be one record per year?
I got around this by creating a reference table, that shows the count at bottom right. Not really what we are looking for BUT...