Can you put it ina simpler way what you want to acheive just tell us your expected , we have your workbook.
Thank you for your response!
What I try to achieve:
1. Calculate difference for [NPS_KTV_real] only from Critic, not from FIRST()
2. Create condition to filter [NPS_KTV_real] only to those, which calculated when Critic > 1 AND Promoter > 1.
3. MAIN THING. To build the same charts as now in dashboards, but with reference line (bullet chart), which shows average of [NPS_KTV_real] of all companies on the level (okrug, region, city) independenly of filtration.
OK Lets take first one
for NPS_KTV_real : Can you please take a example and tell me output?
Thanks for your patience
I think all three points is linked, and may be the last will lead to change the whole approach.
So, first one.
In column [NPS_KTV_type ] you can see values Critic, Promoter and so on. So, Mostly [NPS_KTV_real] is calculated right in actual workbook, but sometimes it returns 0, when there is no data for some regions. [NPS_KTV_real] is normally is difference between proportion of Promoter and proportion of Critic. In my calculated field it differs any value from the FIRST. Mostly, it is Critic and all is right, but sometimes it is Null, and all calculations are wrong.
So, in table calc I could define to differ only with Critic, but in calculated field I don't know how to do that.
If you need some more explanation, I will give some simple screenshots.
So, I solve my first two issues. But I would really appreciate help on third issue:
To build the same charts as now in dashboards, but with reference line (bullet chart), which shows average of [NPS_KTV_real] across all companies on the level (okrug, region, city) independenly of filtration.