Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everyone,
I need Previous month COunt
Any Suggestions would be greatly appreciated.
Thanks in Advance.
HI
PFA
May | B1 | 100 |
May | B2 | 200 |
May | B3 | 300 |
May | B4 | 210 |
Jun | B1 | 90 |
Jun | B2 | 55 |
Jun | B3 | 66 |
Jun | B4 | 89 |
Do you need calculation at Script level or at front end?
Good evening, You can calculate both script and Set Analysis . You only need to match year month year month - January . Regards
Dear Manish,
Thanks for quick reponse. I need Calculation in Frontend
Regards,
A.Harish
Hi Roberto,
Thanks for response,I need this calculation in front end.Could you please tell me in detail.
Regards,
A.harish
HI,
Check this,
Hope this helps,
PFA,
Regards,
Hirish
Hi Hirish,
the above function will give above value.if you look at my requirement.I need Previous month value by Branch wise i.e.., all the four branches should take Previous month.
Thanks in Advance .
Regards,
A.Harish.
See the attached
Data:
LOAD * INLINE [
Month, Branch, Amt
Apr, B1, 100
Apr, B2, 200
Apr, B3, 300
Apr, B4, 210
May, B1, 90
May, B2, 55
May, B3, 66
May, B4, 89
Jun, B1, 85
Jun, B2, 56
Jun, B3, 66
Jun, B4, 66
];
Hi Kush,
Thanks for response.I wanted in a Line Graph,if i use same Expression in line Chart,Values are incorrect.
Below are the values for your reference.
Month | Branch | Previous Month |
Apr | 810 | - |
May | 300 | - |
Jun | 273 | - |
Please suggest how to achieve in a Line Chart.
Regards,
A.Harish.
like this?