detailed tooltip is not working. I am getting error saying that table table calculation attribute reference are missing in field wells. I am creating a bar chart which shows two years information month wise and putting this tooltip which displays YOY value in the bar chart
Hi @bhumika18s
you are trying to put a field into tooltip without the calculation reference.
E.g. if you are using “customer” in the calculation QS expects “customer” in the visual as well to know what to calculate.
BR
Let me give more details here 
I have a column called order_date, in the chart I am displaying sales for each month year-wise. The expectation is to see sales for each month every year…so there will be two bars side by side let’s say for Jan month in different colors- one for 2022 and another for 2023. So, I have created two separate calculated fields where I am extracting month and year from the order date. In a verticle bar chart- put sales in the measures field, month in the dimension field, and year in the group-by field. Now, when creating a calculated field for the tooltip to display sales change in last year’s month and this year’s month. created a formula PeriodoverPeriodLastValue(sum(sales),order_date, YEAR,1) but when I put this field in the tooltip then get an error table calculation attribute references are missing in field wells.
Hi @bhumika18s, It sounds like you don’t have direct reference to the order date column in the visual/chart. You have derived month and year as two independent columns and PeriodoverPeriod is referring the base order date column.
Can you add month, year and sales columns to a table view and share a screenshot? Also share how you derived month and year value from order date.
Regards,
Karthik
I cannot add base order date in the visual as the vertical bar chart (visual) can only accept one field … Like I mentioned earlier - on Measures I am putting amount, on the x-axis I am putting months and in the group, by field, I am putting Year. Formula to derive Month and Year:-
Month = Extract(‘MM’,Order_date)
Year=Extract(‘YYYY’,Order_date)
YOY = PeriodOverPeriodLastValue(sum(amount),Order_Date,YEAR,1)
diff= Sum(amount)-YOY
Table view looks like below
Hello @bhumika18s , @ErikG , and @Karthik_Tharmarajan !
@bhumika18s were you able to find a solution for this or are you still working on this problem? I agree with @Karthik_Tharmarajan, that because you are adding a field that reference Order_date to the bar chart , you need to have Order_date in your visual. The extract function returns an integer value, not a date value.
Hello @bhumika18s , @ErikG , and @Karthik_Tharmarajan!
It has been some time since there has been activity on this thread. If there is no new activity in the next 3 business days this topic will be archived.