Alternative way to get YoY % for LAC calculation?

[Phillip_Le]

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)?

[apjvinod]

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}]))

[Phillip_Le]

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

[Phillip_Le]

@apjvinod Following up here! Let me know what your thoughts are?

[Kellie_Burton]

@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).

[Phillip_Le]

Hiding it still groups it which causes issue for my dashboard. Is there no other workaround for this? @Kellie_Burton

[duncan]

Hello @Phillip_Le !

I can mark this as a feature request for the Quicksight team.