chart year

[inam]

Hello Community,

i have a doubt in creating chart, i have column travel year 2022 & 2023 .

but when i create chart is shows only one year data but i want 2022 & 2023 also.

EXPECTED OUTPUT:-

MY OUTPUT:-

so how i get both year data in chart? 

[MayilVahanan]

Hi

Could you answer for the below questions

1. What is ur expression?

2. Is there any values for 2023 based on ur expression?

[inam]

hello MayilVahanan  thanks for the reply,

1. What is ur expression?

in dimension tab i take create_month_year column & margin

In expression tab i take only sum(invoice) & sum(margin) 

and in sort tab  create_month_year i write below script

=Only({1} Match(Create_Month_Year,'Jan-'&Create_Year,'Feb-'&Create_Year,'Mar-'&Create_Year,'Apr-'&Create_Year,'May-'&Create_Year,'Jun-'&Create_Year,'Jul-'&Create_Year,
'Aug-'&Create_Year,'Sep-'&Create_Year,'Oct-'&Create_Year,'Nov-'&Create_Year,'Dec-'&Create_Year))

[MayilVahanan]

Hi

Hope Create_Month_Year is derived from date field, if so, For sorting, you can use numeric values.

[inam]

yes Create_Month_Year is derived from date field.  i get this format .i want seprate as per my expected output.

[MayilVahanan]

Hi

It looks like, sorting is based on Invoice.. 

Make the sort based on Month Year field. 

[inam]

Hello MayilVahanan 

i sort  data based on Month Year field. 

[inam]

Hello MayilVahanan 

i want 2023 in the end

now its coming like jan 2022 jan 2023 feb 2022 feb 2023 etc

[MayilVahanan]

Hi

Uncheck all the sort by and in expression, try to include only Create_Month_Year and in ascending order.

[inam]

Thanks MayilVahanan 

its working 😊

i have one more doubt can you please help 

1) jan2022 margin is 303 but its show only 241 remaining value(62) show in the last how i correct this ?

2) and how i remove right side values ?