Annualise Data

[danielnevitt]

Hi,

I have a volume query covering trade data from 2018 to present data.

The expression is Count(Distinct{<trade_type_group_cd={'Swap'}>}trade_num)

Please can someone help with annualising the 2023 to show as a complete year (the data is run upto 16/10/2023).

Thanks,
Daniel

[Mark_Little]

Depends on you data model and how you want to visualise it.

Say you have a year dimension either add it to your Chart or add to your set analysis

Count(Distinct{<trade_type_group_cd={'Swap'}, Year={'2023'}>}trade_num)

[danielnevitt]

Thank you for your reply.

I have added year in the dimensions, so the graph shows count by year.

The issue I have is that I would like to show the 2023 data as a complete year. Currently it is 10.5 months (halfway through October) and I would like to divide the count by 10.5 and then multiply by 12 to show a full year.

Regards,
Daniel