topic Re: set analysis expression in Management & Governance

set analysis expression

chapil — Fri, 27 Aug 2021 13:16:46 GMT

Hello guys,

I have datas on my application, but I don't need the all datas on my sheet

So I put some filters in it like Country (FR and EN), Mag ( 1, 2, 3)

I want also to filter my datas trought the time : Time ( 12 months 012020 to 012021)

My problem is :

I want a line chart for the sales per month (according to the selection of 1 mag and one date selection) - this is working

And want on the same chart a line with the average sales (all mag) for the same duration (according to the selection). So I try with a set analysis with {1} but it's not what I want (cause I have filters on the sheet and not in the all app)

I would like to do it like this :

AVG ({1} <country = {'FR','EN'}, time= {$ an expression to say the current selection }, [Sales])

Thanks a lot

PS: if it's not possible or not clear tell me either

Re: set analysis expression

stevejoyce — Fri, 27 Aug 2021 13:19:27 GMT

you are right, {1} will ignore ALL your selections. To ignore specific fields you can do this: mag = in your set analysis.

AVG (<mag =, country = {'FR','EN'}, time= {$ an expression to say the current selection }, [Sales])

Re: set analysis expression

chapil — Fri, 27 Aug 2021 14:00:25 GMT

To explain better,

so, want to calculate average only for green datas, according to my selection mag and time

Re: set analysis expression

chapil — Fri, 27 Aug 2021 14:35:53 GMT

Perfect, all I wanted

Thanks !

Re: set analysis expression

Vegar — Fri, 27 Aug 2021 14:39:14 GMT

Consider this data set.

DATAS:
LOAD Country,Monthname(Date) as Date, Sales, Mag INLINE [
Country,Date, Sales, Mag
FR, 2020-08-01, 10, 1
FR, 2020-07-01, 20, 1
FR, 2020-07-01, 30, 2
FR, 2020-08-01, 0, 2
EN, 2020-08-01, 50, 3
EN, 2020-08-01, 100,4
EN, 2020-07-01, 0, 4
EN, 2020-07-01, 20, 3
];

You can get this chart from the two expressions (If you make selection Mag=1 and Country = EN, FR.)