How to override the filter set on cards and calculate sum on a specified period and condition
How to add hardcoded dates that the amount is summed for a period specified, even when the chard is filtered on for different dates.
e.g. I will like to always get the sum of transactions Type 1 between the period of Jan-01-2020 and Dec-31-2021, even when the filter on the card is set for Jan-01-2021 and Feb-28-2021
As seen in the image, the Budget_Total also gets filtered based on the filter applied to chart.
I have used the following formula in Beast Mode to capture Budget Total:
sum(sum(case when `Transaction Type` = 1 then `Amount` else 0 end)) over (partition by `G_L Account No_`)
Also if possible I will prefer to have a single entry for every 'G_L Account No_', not a repetition.