Forum Discussion
Yet Another grouping question
Add the column as
Has Word Count = IF( CONTAINSSTRING( Table_WordFilter[Data_Queue], Table_WordFilter[Data_Type] & "_Count") , 1, 0)Or
Has Word Count = IF( Table_WordFilter[Data_Queue] = Table_WordFilter[Data_Type] & "_Count" , 1, 0)Use this column as filter.
Add the column as
Has Word Count = IF( CONTAINSSTRING( Table_WordFilter[Data_Queue], Table_WordFilter[Data_Type] & "_Count") , 1, 0)
Or
Has Word Count = IF( Table_WordFilter[Data_Queue] = Table_WordFilter[Data_Type] & "_Count" , 1, 0)
Use this column as filter.
Thank you. This is REALLY close.
What about when my two string values are in two separate data tables?
So:
INTERACTION has a column INTERACTION_TYPE which is [ABC], [DEF], etc.
RESOURCE has a column RESOURCE_TYPE which is [ABC_Count],[ABC_Type1], etc.
If I use your filter idea, I can't cross over to a different table to compare the values. I can see that they match in the resultant visualization (which is what I showed in my initial post), but the data tables don't allow the comparison.
I feel like what you suggest gets me super close, but I'm having a major challenge, for whatever reason, getting my head around how to finish it off.
Any further thoughts?
Thank you!
Actually....this might work. I'm trying doing a Merge Query to get everything into one table, then applying this. I'll let you know.
This worked with a merged query!