Issue with Calculating Previous Month's Max Share When Applying FORMATDATE Filter for Specific Month"

Question & Answer
, , , , , , , , ,
1

Hi Team,
Step1 : Calculating the Leads - Platform Market Share community2 using the below formula
Leads - Platform Market Share community2: (sum({Client - Leads})/min({Segment - Leads sum for market}))
Step 2: Calculating the Previous Max Share using the below formula
Previous Max Share: runningMax({Leads - Platform Market Share community2},[FORMATDATESORTORDER ASC])
Now works as expected when no FORMATDATE filter is applied All. However, when I apply a FORMATDATE filter to select a specific month, the calculation doesn’t behave as expected.
Please refer below table images

image
image776×421 38.1 KB

image
image651×261 11.4 KB

I would like to know how to ensure that the calculation works properly when a particular month is selected using the FORMATDATE filter. Could anyone provide guidance or suggestions on how to resolve this issue?

Thanks,
Pradeep

1 Like
2

hi @bpradeepkumar

thank you for posting your inquiery.

I am guessing that is because the filter occured before all the aggregation. we have demo dashboard in Demo Central to trick the filter to happen after the aggregation. would you be able to see if that works for your case?

kind regards,
Wakana

1 Like
3

Hi @bpradeepkumar,
It’s been awhile since we last heard from you, did you have any additional questions regarding your initial post?

If we do not hear back within the next 3 business days, I’ll close out this topic.

Thank you!

1 Like
4

Hi @bpradeepkumar,
Since we haven’t 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!