SumOver Results 'Unavailable'

[jschoemig]

Hi all

When calculating the sumOver function in ‘Datasets’ > edit, a column with ‘Unavailable’ data is produced.

sumOver(
    sum({incurred}),
    [{binderId}]
)

This issue is robust for multiple datasets and columns and retrieving the data via ‘Spice’ or direct query.

Can you help?

[apjvinod]

Hi @jschoemig

Welcome to QuickSight Community .

Could you please help us with screenshot of the error.

Thanks
VInod

[jschoemig]

Hi @apjvinod, thanks for your response! Please find a screenshot of the Dataset attached after having successfully saved the calculation for the field ‘SumOver_BinderId’

[apjvinod]

Hi @jschoemig

Only the row level calculation/expressions in the dataset will be computed and displayed in dataset pre-view panel . Since sumOver is a group level calculation and hence only the expression definition gets stored in Dataset and not the computed values. Having said that even though you see the value as Unavilable but we can still use it in the analysis & visuals. And the dataset calculated expressions will get executed in analysis along with the visual context & filters .

Thanks
Vinod

[jschoemig]

Hi @apjvinod, that’s already extremely helpful - thank you for pointing this out! However, the calculations in the Visuals don’t come through correctly either. What might be going wrong?

[apjvinod]

Hi @jschoemig

You need to include the level/group field as well in the visual . Please select the Pivot table visual and include " binderId" field in the “Rows” and “sumover_binderid” in “Values”.

[jschoemig]

Thanks a lot @apjvinod ! Much appreciated!