Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a field with name as "Month".It contains the data of "Jan,Feb,.......,Dec"
Month:
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
If my table structure is like this.
Tab:
Prod,
Month
How can i made upto lastmonth(i.e,Jan to Aug) as one group and remaining months like(i.e,Sep to Dec) as one group in the same filed "Month"
and my end result is, i need to plot the count of "Prod" based on the month groups in a bar chart.
Thanks for any response
Regards
Kumar
As there are only 12 months (and it is not a subject to change) I think you can just Create Inline statement to connect your Month fields with MonthGroup field.
Hi,
Some how i am achieving it like this
if(Month(DateField)*1<=9,'UptolastMonth','remainingMonths') as Group,
But i am troubling to show total months as another value in that group.
Regards
Kumar
LOAD * INLINE [
Month, ChartDimension
Jan, UptolastMonth
Feb, UptolastMonth
Mar, UptolastMonth
Apr, UptolastMonth
May, UptolastMonth
Jun, UptolastMonth
Jul, UptolastMonth
Aug, UptolastMonth
Sep, remainingMonths
Oct, remainingMonths
Nov, remainingMonths
Dec, remainingMonths
Jan, TotalMonth
Feb, TotalMonth
Mar, TotalMonth
Apr, TotalMonth
May, TotalMonth
Jun, TotalMonth
Jul, TotalMonth
Aug, TotalMonth
Sep, TotalMonth
Oct, TotalMonth
Nov, TotalMonth
Dec, TotalMonth
];