and([pest]=LOOKUP(โ1โ,โchoose pestโ,โmatchโ,โpestโ),[crop nr]=lookup(โ1โ,โchoose pestโ,โmatchโ,โcrop nrโ))
This formula is correct according to the expression test.
But when this slice is used to filter data in a chart, the chart returns empty and says โno data availableโ.
I want to use a detailed view where 2 columns are shown from table 1 to slice table 2 with data to show in a chart.
How to make a working row filter expression for this?
Solved! Go to Solution.
If you check your data source directly, do you see any record where these two evaluations are both correct?
Would you please check first that the slice is working correctly for example with the table view.
I tested it,
When the expression = โtextโ is used, the slice works and data is shown in the chart.
May I ask what do you mean by "Expression = โtextโ
sorry, when the expression is [pest]=โmacrolophusโ the slice works for the chart.
When you use and([pest]=LOOKUP(โ1โ,โchoose pestโ,โmatchโ,โpestโ),[crop nr]=lookup(โ1โ,โchoose pestโ,โmatchโ,โcrop nrโ)) with a table view, does it show that table view correctly?
and([pest]=LOOKUP(โ1โ,โchoose pestโ,โmatchโ,โpestโ),[crop nr]=lookup(โ1โ,โchoose pestโ,โmatchโ,โcrop nrโ)) shows an empty view, no data in it.
If you check your data source directly, do you see any record where these two evaluations are both correct?
User | Count |
---|---|
40 | |
34 | |
28 | |
23 | |
17 |