I have been using periodOverPeriodPercentDifference for all my fields; however, there is one field calculated using LAC (Traffic):
sum(avg(traffic, [{metric_day},{marketplace_id},{page_type},{device_type0}])) as Traffic
What alternative method could I use to calculate the Year-over-Year percentage (%YoY)?
Hi @Phillip_Le
Include the datefield as well in the LAC ( Traffic) and use it in the Periodoverperiod functions .
sumover(avg(traffic), [Datefield,{metric_day},{marketplace_id},{page_type},{device_type0}]))
So I have to have those fields in the pivot? What if I don’t want them and just have them as filters?
VISUAL_CALC_REFERENCE_MISSING
@apjvinod Following up here! Let me know what your thoughts are?
@Phillip_Le -
If the fields are in the calculation, they have to be in the table/pivot table. But, you can hide them from view by selecting Hide from the menu on that field in the field wells. (screenshot included).
Hiding it still groups it which causes issue for my dashboard. Is there no other workaround for this? @Kellie_Burton
duncan
January 26, 2024, 3:39pm
7
Hello @Phillip_Le !
I can mark this as a feature request for the Quicksight team.