topic Re: i need to mom comparision in App Development

i need to mom comparision

Swathi — Fri, 15 Nov 2024 21:08:46 GMT

I need mom comparison in percentage.

i have create Line chart

Line-Month

Measures

Sum({<MonthYear,Period,tkt_Year={'$(=Max([tkt_Year]))'}>} delv_qty)

Sum({<MonthYear,Period,tkt_Year={'$(=Max(tkt_Year)-1)'}>} delv_qty)

now i need the MOM comparision percentage

for ex (Feb2023 volume-Jan2023 Volume)/jan2023 Volume ((171.54-131.71)/131.71)*100, need percentage, beside the value, i need MOM percentage increase in brackets). Kindly help me how to do. it's little urgent.

Re: i need to mom comparision

Parthiban — Tue, 02 Jan 2024 12:06:05 GMT

Hi,

Try this one

MaxYear = ((Sum({<MonthYear,Period,tkt_Year={'$(=Max([tkt_Year]))'}>} delv_qty)
-
Above(Sum({<MonthYear,Period,tkt_Year={'$(=Max([tkt_Year]))'}>} delv_qty)))
/
Above(Sum({<MonthYear,Period,tkt_Year={'$(=Max([tkt_Year]))'}>} delv_qty)))*100

PrevYear = ((Sum({<MonthYear,Period,tkt_Year={'$(=Max(tkt_Year)-1)'}>} delv_qty)
-
Above(Sum({<MonthYear,Period,tkt_Year={'$(=Max(tkt_Year)-1)'}>} delv_qty)))
/
Above(Sum({<MonthYear,Period,tkt_Year={'$(=Max(tkt_Year)-1)'}>} delv_qty)))

Need to sort month in Load order. First check in table validate the output and then proceed the Line chart

Re: i need to mom comparision

Swathi — Tue, 02 Jan 2024 15:52:33 GMT

@Parthiban , Thanks for the reply, i have got output as expected, the percentage i need to show in the same line chart.

it is two charts, i don't need two line charts, in same chart i have to give percentage in brackets beside value

for ex : 154.09k( MOM-0.7%) on each lable value or 154.09(-0.7%), Kindly chart should be same, percentage values should come in brackets in each label