Hi,
I’m trying to add a calculated field in Q. I added it in my analysis and it works
periodOverPeriodDifference({Annualised monthly churn age}, {first_day_of_month}, MONTH, 1)
However, I can’t add it in Q. I tried to sum it but that doesn’t work either
{Annualised monthly churn age} is a partitioned by age category, so I need to add that field in the chart for it to work.
Any thoughts?
Thank you
Ana
Hello @Ana_Mocanu , welcome to the Quick Sight community!
When you say it doesn’t work do you mean that it throws an error or that the values returned are incorrect?
I have seen this issue come up in the past and there are two potential workarounds: 1) Make sure that you are using the correct dataset if your analysis/Q topic uses multiple and 2) create the calculated field on the dataset layer before bringing it into your Q topic.
thank you @duncan !
Sorry I should have been more specific - it doesn’t return a result in the Q topic, even though it correctly associates the query I’m asking it with the fields
I have created the calculated field on the dataset layer. It seems to work ok and I can create a multiple line chart with the other dimensions (age category and date) in an analysis
However when I look at the calculated field in Q, it looks like it’s throwing an error - which is why I’m assuming Q doesn’t display results
I managed to make it work by creating a link to visual. But kind of pointless because it’s linked to an already published visual 
