line chart ignoring filtering in one field but reacting to filters in other fields

[egma]

Hi guys,

I have a table with 4 fields: reportDate, catalogue, dataset, and dataset status

from this table I generated this line chart using the fields reportDate and  count of number of datasets over a specific value of in the field datasetStatus:

Count({ <datasetStatus={"Existing dataset"}>} dataset)

In the dashboard I have 2 filter: reportDate and catalogue. What I need to achieve is that the chart changes when the user selects any couple of dates (filter reportDate) but remains unchanged (as above) in case the user select one or more values in the filter "catalogue".

I tried  to use Count({ <catalogue=, datasetStatus={"Existing dataset"}>} dataset) as found in some questions in this forum but it doesn't work. I'd really appreciated your advice on how to achieve this.

Thanks and enjoy your day 🌄,

Carlos

[Mark_Little]

Hi

Count({ <catalogue=, datasetStatus={"Existing dataset"}>} dataset) Or

Count({ <catalogue, datasetStatus={"Existing dataset"}>} dataset) 

should work, adding the field name with no set means to ignore the field on selection.  What is the change is happening? 

[egma]

Hi @Mark_Little , thanks for your suggestions. I tried both of your suggestions but there chart is still taking into account the filters I'm doing in the "catalogue" field. It's very weird this stuff. 

[Mark_Little]

yep certainly weird, you syntax was/is correct.

i would check the filter is definitely as expected i.e. is catelogue and not another field renamed.