Question Re: SAP Analytics Cloud: Conditional Format as a Filter in Technology Q&A

SAP Analytics Cloud: Conditional Format as a Filter

djk13 — Fri, 17 Mar 2023 01:17:49 GMT

Hello Experts,

My question is, does filtering via conditional formatting exist in SAC?

I have a set of values for which I am trying to calculate the standard deviation. The only issue is the data set has some exclusions that must occur for the Std. Dev. to be correct. I have identified the criteria for the exclusions and have set them to display via conditional formatting.

When I set up my visual, I would like to exclude these data points. Can I simply filter by or the equivalent thresholds. If so, how? I have been unsuccessful so far.

Thanks!

Re: SAP Analytics Cloud: Conditional Format as a Filter

former_member838037 — Fri, 17 Mar 2023 05:37:01 GMT

After creating the Threshold, you need to create a Measure Based Dimension, based on the same measure and dimension.

And after that, you can just use the Measure Based Dimension as a filter for your table, which will do the work.

This is the unfiltered table and the threshold settings.

After that, this is the MBD that I have created which has the same setting as the threshold.

Then I used the MBD as a filter for the Table, which gives the following result, consisting of only the High Threshold values.

Thanks, hope this helps you.

Re: SAP Analytics Cloud: Conditional Format as a Filter

djk13 — Fri, 17 Mar 2023 17:02:22 GMT

Thank you so much argha2000! I appreciate it. That is working for me so far 🙂

The application of 'REO GOOD' as a filter in the corresponding charts within my story also works.

Perfect explanation, upvoted and accepted!

Re: SAP Analytics Cloud: Conditional Format as a Filter

former_member838037 — Sat, 18 Mar 2023 07:32:15 GMT

Glad it helped you djkoenig .