16 Replies Latest reply: Jan 2, 2017 1:56 AM by Kavita Vishwakarma

# MoM and YTD Trend..

Hi..

I want to show below expression in line chart...

sum({<Val_Date={">=\$(vValStart)<=\$(vValEnd)"}>}if(vCalCurrentDate< Val_Date,[Net Tractor Revenue (Domestic)]))

/

sum( {<Link_Date={">=\$(vCalMinDate)<=\$(vCalCurrentDate)"}>} [Net Tractor Revenue (Domestic)])

Please help me with this issue.

Regards,

Kavita

• ###### Re: MoM and YTD Trend..

When you say line chat...

1) What are the dimension(s) you are going to use in Line Chart?

2) What exactly the logic behind this expression?

Regards,

MK

• ###### Re: MoM and YTD Trend..

My calendar is not linked with the data..

The logic is..

I want to calculate those revenue..whose validity date falls under this year... divided by total revenue..which is calculated on the basis of another field..

I have attached sample app..kindly look into it..

• ###### Re: MoM and YTD Trend..

What are the dimension(s) you are going to use for Line Chart?

• ###### Re: MoM and YTD Trend..

Yes, Please specify the dimension names in line chart

• ###### Re: MoM and YTD Trend..

I guess a lot of people before me have asked the same question about what is the dimension here. I would like to additionally ask you about what is the expected output in terms of numbers you want to see for each month and probably break it down in terms of number in the numerator and number in denominator. The more info you can provide, the easier it will be for us to play around in your sample because those are things we don't know.

Best,

Sunny

• ###### Re: MoM and YTD Trend..

Hi..I want to show Month Wise trend..

But my calendar is not linked with the data..

I have two dates Link_Date and Val_Date from data and LinkDate is from Calendar.

The calculation is...sum of revenue with the Val_Date divided by sum revenue with the Link_Date.

My filters are from Calendar.

I hope now u understand it better...

Please help me with  this issue.. I have attached the sample app also.

Kindly look into it.

Regards,

Kavita

• ###### Re: MoM and YTD Trend..

PFA of the output...

Please help me with this issue...

Regards,

Kavita

• ###### Re: MoM and YTD Trend..

I think you cannot use set analysis in your denominator because you are hoping to get it evaluated based on your dimension and set analysis is evaluated only once per chart. The expression which is working is very slow (at least for the sample), but you can give it a try

=Num(Sum({<Val_Date={">=\$(vValStart)<=\$(vValEnd)"}>} If(vCalCurrentDate < Val_Date,[Net Tractor Revenue (Domestic)]))

/

Sum(Aggr(If(Link_Date >= Min(LinkDate) and Link_Date <= Max(LinkDate), Sum([Net Tractor Revenue (Domestic)])), Link_Date, [Fiscal Month])),'##.#%')

• ###### Re: MoM and YTD Trend..

Thank You Sunny..

MoM Is done..But how Can I show YTD or QTD.. with the same expression...

For e.g

YTD: If is Select Jul then it should show Apr to Jul.

QTD:If is Select Jul then it should show only Jul.

Regards,

Kavita

• ###### Re: MoM and YTD Trend..

Have you given it a shot at your end? I don't understand your data, I will need you to give me a kick start here....

• ###### Re: MoM and YTD Trend..

Yess...

• ###### Re: MoM and YTD Trend..

I have tried the below expression for the denominator part..

Sum(Aggr(If(Link_Date >= max([Quarter Start]) and Link_Date <= Max([Quarter End]), Sum([Net Tractor Revenue (Domestic)])), Link_Date, [Fiscal Month]))

But its summing up the data...

Regards,

Kavita

• ###### Re: MoM and YTD Trend..

Do you know what are the numbers you will be seeing?

• ###### Re: MoM and YTD Trend..

Below are the values:

For QTD: if i select Jun then it should show Apr, May and June..in Trend

For YTD: If i select Jul then it should show Apr to Jul

 Apr 567.3 May 639.3 Jun 842.2 Jul 476.7 Aug 366.3 Sep 883.4 Oct 1,321.1 Nov 462.6 Dec 209.5

Regards,

Kavita

• ###### Re: MoM and YTD Trend..

Wait, these are just denominator numbers? What exactly are you looking to show now? percentage or just the denominator? You have had me completely confused now

We already had this, what do you want from this now? You need two expressions, one for QTD and one for YTD?

• ###### Re: MoM and YTD Trend..

MoM trend was successfully done..

Same i Want for Qtd and YTD...

So for testing i was using oly denominator...for Qtd and YTD..

I want that MoM trend values in QTD and YTD..