topic Re: MoM and YTD Trend.. in App Development

MoM and YTD Trend..

kavita25 — Sat, 24 Dec 2016 10:03:27 GMT

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..

MK_QSL — Sat, 24 Dec 2016 10:17:54 GMT

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,

Re: MoM and YTD Trend..

kavita25 — Sat, 24 Dec 2016 11:24:30 GMT

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..

MK_QSL — Sat, 24 Dec 2016 11:34:24 GMT

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

Re: MoM and YTD Trend..

deepakqlikview_123 — Sat, 24 Dec 2016 17:26:20 GMT

Yes, Please specify the dimension names in line chart

Re: MoM and YTD Trend..

sunny_talwar — Sat, 24 Dec 2016 17:47:15 GMT

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..

kavita25 — Mon, 26 Dec 2016 05:54:24 GMT

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..

kavita25 — Tue, 27 Dec 2016 05:57:53 GMT

stalwar1‌gwassenaar‌

PFA of the output...

Please help me with this issue...

Regards,

Kavita

Re: MoM and YTD Trend..

sunny_talwar — Tue, 27 Dec 2016 14:33:10 GMT

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..

kavita25 — Thu, 29 Dec 2016 11:22:50 GMT

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..

sunny_talwar — Thu, 29 Dec 2016 11:38:26 GMT

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..

kavita25 — Thu, 29 Dec 2016 12:16:32 GMT

Yess...

Re: MoM and YTD Trend..

kavita25 — Thu, 29 Dec 2016 12:36:07 GMT

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..

sunny_talwar — Thu, 29 Dec 2016 12:40:04 GMT

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

Re: MoM and YTD Trend..

kavita25 — Thu, 29 Dec 2016 12:55:57 GMT

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..

sunny_talwar — Fri, 30 Dec 2016 12:31:57 GMT

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..

kavita25 — Mon, 02 Jan 2017 06:56:58 GMT

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..