Hi Team Good Day!
I am New to Quick sight.
I have FinancialYear(Like 2024-25, 2025-26) and Month( Like April, May) and Amount filed are there.
when Financial Year Filter selects like 2025-26 needs to display current year and previous year comparison month wise.
Don’t have full date in my data.
How to achieve this.
could help me on this.
Thanks in Advance.
Welcome to the Quick Suite community!
Please refer to the following official documentation for implementing comparative financial year calculations in Quick Suite.
Thank you sharing the documentation but here i don’t have full date column, only Financial Year (Ex: 2025-26) and Month(Ex: April) are available.
How to do in that cases?
Thanks in Advance.
Since you don’t have a full date column, I recommend creating a calculated date field by combining your FinancialYear and Month fields
Create calculated field ConstrustedDate (Date type).
Note - Replace the fields from your dateset.
parseDate(concat(‘01-’, {Month}, ‘-’, substring({FinancialYear}, 1, 4)), ‘dd-MM-yyyy’)
Use this ConstructedDate field with built-in periodOverPeriodDifference functions for month or year wise comparisons.
Please refer to the below documentation this might be helpful for you.
It’s been a while since we last heard from you. If you have any further questions, please let us know how we can assist you.
If we don’t hear back within the next 3 business days, we’ll proceed with close/archive this topic.
Thank you!
Since we have not heard back from you, I’ll go ahead and close/archive this topic. However, if you have any additional questions, feel free to create a new topic in the community and link this discussion for relevant information.
Thank you!