Measure not working with total option.

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.

5d3f7f23-9fe8-4843-89b7-66fc7ba57f5b.png
0 0 207
0 REPLIES 0
Top Labels in this Space
Top Solution Authors