Hi,
I have a problem using the calculated field ‘OnlyMaxDate’ wich is calculated like:
ifelse({max date} = {next_billing_date}, {next_billing_date}, NULL)
Where max date = maxOver({next_billing_date}, [{company_id}],PRE_AGG)
Now the problem present itself when i use OnlyMaxDate as a filter, for example por calculating the distinctcount of company_id for january 2025, when i apply the filter for that particular month, the result is 822 company_id, but when i dont use the filter at all, in the table for that month shows 842 company_id. What could be the problem, given that theres only one record for every company_id, and is the last record based in the field next_billing_date, that would mean that i use 2 restrictions and yet i still have a problem showing the right number.
Hi @Juan – Have you “included” start and end dates in your filter configuration?
Hi @awsvig, yes, both are included
Hi @Juan,
It’s been awhile since last communication took place on this thread; checking in to see if you’re still working on this or were able to find a work around in the interim?
If we do not hear back within the next 3 business days, I’ll close out this topic.
Thank you
Hi @Juan,
Since we have not heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for relevant information if needed.
Thank you!