Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there,
I want a line chart which shows the sum of net amount in buckets. Bucket values : 0-30,31-60,61+ days pending, over a year starting from today. What will be the dimensions for this attached sample chart?
Hi Team,
Thank you for your support. As I dont have the reference date to calculate the week, i calculated based on ceil (age/7). I have the age bucket in my database. It resolved.Thank you for your time.
Hi Jhansi Rani,
Try Calculated dimension like below:
=if(Bucket values>= 0 and Bucket values<=30, '0-30',
if(Bucket values>= 31 and Bucket values<=60, '31-60',
if(Bucket values>= 61,'61+days',Null())))
Check Suppress When value is Null
Expression:
Sum(Attribute Name)
I don't know that whats your exact attribute name in you data model. So try based on your attribute.
hope this helps you.
Best,
Robert
Hi there,
Yes, I need the buckets.I have fields like Net Amount, Age(eg:12, 45, 60 etc..) - Bucket , how can i get the week dimension(x- axis) (52 weeks starting from today)? Hope it is clear...
Hi,
Try like below:
Dimension 1 - Week
Dimension 2 -
=if(Age>= 0 and Age<=30, '0-30',if(Age>= 31 and Age<=60, '31-60',if(Age>= 61,'61+days',Null())))
Expression:
Sum([Net Amount])
Best
Robert
Hi Team,
Thank you for your support. As I dont have the reference date to calculate the week, i calculated based on ceil (age/7). I have the age bucket in my database. It resolved.Thank you for your time.