I have an absolute delta calculated field on a weekly basis which has a value of 64,279 (table 1).
I have the same table with another row added (node) in which again I get the total values (essentially the same thing as the first table but instead I get the total values as my table 1) which now sum up correctly. How can I make sure my pivot table aggregates the ABSOLUTE DELTA correctly in table 1?
Hi @gmikay,
Can you show the calculations for all your calculated fields?
Of course, the data has a metric_type column and a value column where the metric_type column tells me what the value is referring to.
actuals : ifelse({metric_type} = ‘actual’, value, 0)
wk1_forecast: ifelse({metric_type} = ‘wk1_forecast’, value, 0)
wk1_delta: (sum(actuals-{wk1_forecast}))
wk1_abs_delta: abs(wk1_delta)
wk1_WAPE: wk1_abs_delta/sum(actuals)
Would it be better for me use a data that is more horizontal, meaning instead of metric_type, I should have a column for each value?
If you need further assistance, consider creating a sample dashboard with a sample dataset in Arena that illustrates your problem. Post it in a new thread for better visibility. You can find detailed instructions on how to use Quick Sight Arena.