Add a reference line to the analysis with the value from the Parameter in QuickSight

Question & Answer
, ,
1

Hi,
I am trying to add a reference line to my analysis from the value provided by the parameter, I have attached the screenshot of my configuration. The problem is the value is getting doubled when I use the group by functionality in the analysis. Can you help me fix the issue. I have attached the screenshot in the first 2 comments of this post.

Screen Shot 2022-04-20 at 10.03.04
Screen Shot 2022-04-20 at 10.03.041580×820 66.4 KB

2

Screen Shot 2022-04-20 at 10.05.56
Screen Shot 2022-04-20 at 10.05.56456×872 24.7 KB

3

Screen Shot 2022-04-20 at 10.07.04
Screen Shot 2022-04-20 at 10.07.041345×362 12 KB

4

Divided the calculated field based on parameter by countOver(primarykey, [casetype], PRE_AGG). Primary key is the lowest level dimension of your dataset.