Despite the COVID-19 outbreak, our team continues operating at full speed. We are always here to support and answer all your questions.

Feel free to reach out by filling this quick form.

Fill the form
Get Free Trial

Custom Datasource API – /select requests for Flat Tables involving dates

Henry asked on March 30, 2021

We had the following observation that we were not sure of. When we have dates configured in the report and the layout is that of a Flat Table, we noticed that in the /select call, there is request for the count of the dates. However, if the layout is that of a Compact View, then the /select call does not contain a request for the count of the dates. Is this the expected behavior? If so, what is the purpose of requesting the count of the dates when the layout is a Flat Table, but not when it is a Compact View? We’ve prepared a jsFiddle and some screenshots for convenience.

Please let us know if you need further details and/or clarifications!
Kind regards,

1 answer

Illia Yatsyshyn Illia Yatsyshyn Flexmonster March 31, 2021

Hello, Henry,
Thank you for reporting this observation.
On the screenshot dedicated to the compact form, the date type field is placed in rows. The aggregation is only needed for fields set to measures. This behavior is expected.
Still, the count aggregation for the date field on the flat form seems to be redundant.
Our team will research this question and get back with results ETA May 03.
Feel free to contact us in case any other questions arise.
Kind regards,

Please login or Register to Submit Answer