Measure not working with total option.

  • 13 January 2022
  • 0 replies

Hi All,

We have a count distinct measure and which is working fine without total option but if we check the looker Totals option it will hits different view and looker throws invalid identifier error. 

When we check Totals option looker generates two queries. First one is to fetch all selected columns data into tabular form and second is to calculate total. First query hits on expected view but second one is hitting another view and I am wondering why such scenario happening. Is there any way to configure which view to hits on total calculation ? I am not seeing it anywhere.



0 replies

Be the first to reply!