topic Re: chart year in App Development

chart year

inam — Fri, 15 Nov 2024 21:38:48 GMT

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?

Re: chart year

MayilVahanan — Fri, 23 Jun 2023 06:45:16 GMT

Could you answer for the below questions

1. What is ur expression?

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

Re: chart year

inam — Fri, 23 Jun 2023 07:05:06 GMT

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

Re: chart year

MayilVahanan — Fri, 23 Jun 2023 08:51:56 GMT

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

Re: chart year

inam — Fri, 23 Jun 2023 09:58:41 GMT

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

Re: chart year

MayilVahanan — Mon, 26 Jun 2023 03:44:00 GMT

It looks like, sorting is based on Invoice..

Make the sort based on Month Year field.

Re: chart year

inam — Mon, 26 Jun 2023 09:47:31 GMT

Hello MayilVahanan

i sort data based on Month Year field.

Re: chart year

inam — Mon, 26 Jun 2023 11:40:00 GMT

Hello MayilVahanan

i want 2023 in the end

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

Re: chart year

MayilVahanan — Tue, 27 Jun 2023 02:52:45 GMT

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

Re: chart year

inam — Tue, 27 Jun 2023 06:38:54 GMT

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 ?

Re: chart year

MayilVahanan — Tue, 27 Jun 2023 08:02:53 GMT

1. It looks like date not available for 62 [Actual Margin], need to fix the data issue. or, make the null date values to 1st of Jan'22.

2. Go to Axes tab -> check the Hide Axis in Expression Axes