Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
All
I need help with a expression on line chart. I want to show "=[Metric(Result)]" and need to select the following to show only those criteria's in the chart.
However I can't seem to and having errors as soon I use this =({<[Metric(Result)],IGA = {'UK_35'},[Service ID]={'PCEN06'},[SLA ID]= {'SL01.UK.BI'}>})
Can you please let me know where I am going wrong.
Thanks
Mohi
Sorry, I copied the expression too fast, it's missing the field
Only({<IGA = {'UK_35'},[Service ID]={'PCEN06'},[SLA ID]= {'SL01.UK.BI'}>} [Metric(Result)])
Hi Mohiuddin,
I guess you are trying to perform a Set Analysis, if so try similar expression as below:
SUM({$<IGA = {'UK_35'}, [Service ID]={'PCEN06'}, [SLA ID]= {'SL01.UK.BI'}>} [Metric(Result)])
You can always refer to the help here:
Can you please post your question with more details next time?
Hope this helps you...
Regards
SB
hello, I think you're not providing enough information to be able to respond correctly to your request.
what does the expression "[Metric(Result)]" stands for?
is it the metric in your fact table?
where is your aggregation expression?
Hi,
In the table I have the data in the format below
IGA Service ID SLA ID Metrics Result Month
UK_35 PCEN06 SL01.UK.BI 95% 01/04/2018
UK_36 PCEN07 SL02.UK.BI 97% 01/05/2018
Many thanks for this, however it's not a sum as data is aggregated hence using the "=[Metric(Result)]".
Data structure is similar to below
IGA Service ID SLA ID Metrics Result Month
UK_35 PCEN06 SL01.UK.BI 95% 01/04/2018
UK_36 PCEN07 SL02.UK.BI 97% 01/05/2018
UK_37 PCEN08 SL03.UK.BI 95% 01/04/2018
UK_36 PCEN09 SL04.UK.BI 97% 01/05/2018
You still need a function that will take set analysis, something like this
=Only({<[Metric(Result)],IGA = {'UK_35'},[Service ID]={'PCEN06'},[SLA ID]= {'SL01.UK.BI'}>})
Hi, Many thanks for suggesting the only function, however when i use "Only ([Metric(Result)])" it seems fine, however when I use =Only({<[Metric(Result)],IGA = {'UK_35'},[Service ID]={'PCEN06'},[SLA ID]= {'SL01.UK.BI'}>}) it gives me an error.
What dimension bases you are using Only() function, You need one dimension there?
Sorry, I copied the expression too fast, it's missing the field
Only({<IGA = {'UK_35'},[Service ID]={'PCEN06'},[SLA ID]= {'SL01.UK.BI'}>} [Metric(Result)])
I have used months as dimention