In looker studio, I have one fixed sized list and one table; “List 1” has lists of Projects (Connected Workmen, Mat Route Monitor, Scrap Weighing Automation, Utility Management System, Furnace Power Opt., RPA Solutions, Product Surface Quality Inspection, Decarbonization, Traffic Management) and “Table 1” has current status of those projects. Now, currently when nothing is selected on “List 1”, “Table 1” showing all data & when a project is selected from List 1 then relevant current status on “Table 1” is visible. What I want when nothing is selected on “List 1” then nothing will be visible in “Table 1”
One option is to create a cross-join blend to add a count of entries to your data source for Table 1, and use this count to decide what to display. To do this, cross-join “Record Count” (or some other count) with whatever fields you need for Table 1 (Status?). Use this blend as a source only for Table 1 (not the List). Instead of displaying Status, create a chart-level calculated field that will only display Status if the count is 1, otherwise it displays a blank. Something like: IF(Count=1,Status,””)
Let me know if you need more info!
The IF logic is not working when I’m using Aggregate (Count = 1) and non aggregate (Table 1 “Status”)
This worked for me (my blend had Record Count on the left as a metric, cross-joined with Description on the right as a dimension)
if(Record Count>1,“”,Description)
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.