Hi, I have problem with numbers (who I can filtering) and another number, who I can’t filtering, all in one page. Is that possible?
Example strukture tables:
What I want? Show how much is logged in this month and how much hours are billed in this billing_date.
Filters:
-
logged (time - worklog) from 2024-09-01 to 2024-09-30
-
billing_date = 2024-09-30
But if I set both filters, I show only information, where is billing_date not NULL. I want in one report page show ‘all logged’ (no filter billing date) and how buch billed in Semptember (we write to colums last day in month)
It isn’t must be table, it can by “graph” with number. But I don’t know, how work with component and no filtering with all set filters
We have free plan in Looker Studio, data from Big query db (2 table and datablend - collection 2 table - joined)
Can it free Loker Studio work with numbers and ingore some filters on page? It will be solution.
My prefer result is:
Thanks for help

