Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I'm attempting to plot a straight table visualization to display the top clients based on their values and volumes across countries. My data is accumulative, and my intention is for the data to auto reload from the latest month's worth of data.
I'm currently stuck with this expression - Sum( Aggr(If(Rank(Sum(AUD_AMT), 1) <= 3, Sum(AUD_AMT)),outwardSeller, max(outMonthYear) ,cs.clientCode )
PS - I've attached a simple mock data for ease of referencing
hi Eric,
Based on ur sample data, its contains only one date , so do you want to add Max date in ur expression?
If so, try like below
If(Rank(Sum({<pymtDate={"$(=Date(Max(pymtDate),'M/D/YYYY'))"}>}pymtAUD))<=3, Sum({<pymtDate={"$(=Date(Max(pymtDate),'M/D/YYYY'))"}>}pymtAUD))
HI Eric,
Its works fine. Can you say the issue in details if I missed out
Hi Mayil,
This does work, but I'm planning to only factor in the current month sales/volumes. How would we add in the MonthYear variable in?
hi Eric,
Based on ur sample data, its contains only one date , so do you want to add Max date in ur expression?
If so, try like below
If(Rank(Sum({<pymtDate={"$(=Date(Max(pymtDate),'M/D/YYYY'))"}>}pymtAUD))<=3, Sum({<pymtDate={"$(=Date(Max(pymtDate),'M/D/YYYY'))"}>}pymtAUD))
Thanks Mayil,
My actual data will span across 3 years, and I'm looking to sum an entire month's worth of data for this Proof-of-Concept. Your solution is a good guide for me to expand upon this intention.