topic Re: Annualise Data in App Development

Annualise Data

danielnevitt — Tue, 17 Oct 2023 08:56:57 GMT

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

Re: Annualise Data

Mark_Little — Tue, 17 Oct 2023 09:36:07 GMT

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)

Re: Annualise Data

danielnevitt — Tue, 17 Oct 2023 09:55:52 GMT

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