Hey Everyone, I am using Distinctcountover function and I need to partition by a calculated field. [calc] Here Label group is a calculated field dimension. This is the error is shown on the chart visual when using this distinctcountover field The error is : Your calculated field expression co…

Ah, ok. I know this isn’t an ideal solution but can you try adding your Label Group calculation into your Data Set instead of adding it in the analysis? Does that work?

Distinctcountover not taking calculative field as partition by field

Q&A

Jesse March 28, 2022, 9:55pm 6

Agreed, it should be possible in the analysis too. Will bring this to the product team.

** Urgent ** DistinctCountOver() Function Issue

Topic		Replies	Views
Distinctcountover partition by field syntax error Q&A analysis , parameters , quick-sight , calculations , Business-Intelligence-Engineer	7	467	October 30, 2023
Distinctcountover error - Your calculated field expression contains invalid syntax Q&A analysis , quick-sight , calculations	3	2075	October 27, 2022
distinctCountOver not working with Calculated Field (DISTINCTCOUNTOVER_INVALID_ARGUMENT) Q&A formulas , error , quick-sight , Business-Intelligence-Engineer	9	82	September 6, 2025
Convert FIXED CASE WHEN tableau calculation to QS Q&A feature-request , quick-sight , calculations	16	1227	October 14, 2022
Please Contact the Quicksight Team to solve this issue Q&A analysis , quick-sight , calculations	3	996	October 14, 2022

Distinctcountover not taking calculative field as partition by field

Related topics