Filtering on a whole dashboard

[St_ef]

Hi

I have got several charts in a dashboard that I would like to filter globally. I’d like to add a filter on dates, to view only the datas of the last day. Actually dates are stored as strings, and I convert and filter it on each chart (hardcoded) ; il would like to deport this filter on the dashboard and print it as a parameter.

If I understand this post :

MongoDB Charts: Filter Dashboards by Field Values

Is [Filter Dashboards by Field Values] in MongoDB Charts (https://docs.mongodb.com/charts/master/dashboard-filtering/#filter-dashboards-by-field-values) is available only in Atlas? This is very important feature of Charts and looks like it’s not available in Charts on-premises. Is there any work-around to have filter applied on Dashboards on charts in on-premises version? Thanks!

Those 2 functionnalities are only available on a single chart and not on the dashboard :

Filter Chart Results — Atlas Charts

Convert Field Data Types — Atlas Charts

Is that exact or am I missing something ?

Thanks

[tomhollander]

Hi @St_ef -

When you add a dashboard filter, the types of each field will be the original type, and it doesn’t take any chart-level type conversions into account. To do what you’re looking for, you should create a “Charts View” (from the Data Sources page) that converts the string field to a date, and then use the View instead of the raw collection for each chart.

Note that while this will achieve your functional outcome, the performance may be poor if you have a lot of data, as Atlas will need to convert every string field to dates each time and it won’t be able to use any indexes. To improve the performance you should store your dates as the correct type and index the field.

HTH
Tom

[St_ef]

@tomhollander

you should store your dates as the correct type and index the field.

Great @tomhollander, that’s it !

db.getCollection('mycollection').updateMany(
   {
      "mdate":{
         "$type":"string"
      }
   },
   [
      {
         "$set":{
            "mdate":{
               "$dateFromString":{
                  "dateString":"$mdate"
               }
            }
         }
      }
   ]
)

The mdate attribute is now a date and filter works !
Many thanks