I have a line chart with 2 dimention month and region. and an expression average of data like below. I want to have an average line that be average of each region in each month.what should I do to get this?
hello marjan ,
we have function called column by using columns function achieved ur desired result.\
kindly try this in ur app
Thanks and regards,
in Your example data, you only have one region on each month. So if you use sum or avg as Expression doesent change anything here. Your linechart is showing you an average on each region on each month. If you add one more value for example on region 01 on month 1, then avg(Data) will gives you average for thoose 2 values on month 1.
otherwise give us some example on expected output.
Yes Its correct. But I want an average line that show average of all region in each month.for example average in month1 will be 266 and the average in month 2 will be 339.