how to add calculated filters in Charts ?

Wala
Wala Registered Posts: 4 ✭✭

I want to embed calculated filters (if x >1 set display color to blue, if x > 1.15 set color to yellow etc…) in a chart. Let's say Bar chart for example.

I know how to add static filters but is there a way to add filter based on a calculation.

here in this chart , each color is a parameter. I want to change parameter color depending on its value

image.png

Operating system used: Linux

Operating system used: Linux

Operating system used: Linux

Answers

  • elenabrunner
    elenabrunner Registered Posts: 3
    edited July 22

    A calculated field or measure that specifies the filtering logic must normally be created before being applied as a filter to your chart in order to add calculated mwst rechner filters. This allows you to filter based on conditions that aren't directly available in your data.
    1. Create a Calculated Field or Measure: Create a new calculated field or measure in your data visualization program (such as Tableau, Power BI, or Looker). The reasoning for your filter will be in this area. To decide which data points should be included or left out, it may entail performing calculations, comparing values, or using functions.

  • elenabrunner
    elenabrunner Registered Posts: 3

    You usually construct a new calculated field with the logic for your filter (for example, using IF statements to return TRUE or FALSE) and then put it on the Filters shelf or use it to filter the data directly in your data source in order to add a calculated filter to a chart. By using this method, you can apply sophisticated conditions that go beyond straightforward text or number filters, like filtering based on table computation results or combining numerous conditions Bidsest.

    .

Setup Info
    Tags
      Help me…