Sum of Values metric1 from previous week + metric2 current week

Q&A
,
1

Hi team,

I want to create a calculated field that is the value of one specific metric in week-1 (previous week) + the value of other metric in the current week.

Like this: (value_metric1_w-1 + value_metric2_w-0)

I was trying to do with “Sumif”. Does anybody has an tip or idea to give an helping hand? :slight_smile:

Does any

2

Hello @mxdenise and welcome to the Quicksight Community!

Have you tried using parameters for your calculated field?

3

Hi @mxdenise. Did @duncan’s solution work for you? I am marking their reply as, “Solution,” but let us know if this is not resolved. If we do not hear from you in three days we will archive this question.

Thanks for posting your questions on the Quick Sight Community Q&A Forum!