Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 months ago
Solved

Creating a visual using several filters

Hi   Im trying to create a table or stacked bar chart which shows data for multiple criteria.   So as an example i have a dataset which has numerous contracts and some data is missing in various ...
Need Help
  • nielsvdc's avatar
    nielsvdc
    9 months ago

    Hi Anonymous,

     

    You might want to create a calculated column named IsMissingData in the table, that checks rows for missing column data. The calculated column checks every required column for missing values. If any required column is missing data, you can set the column value to TRUE. You can use this column to show any rows with missing data.

    IsMissingData =
VAR colA = IF(ISBLANK([Column A]), TRUE, FALSE)
VAR colB = IF(ISBLANK([Column B]), TRUE, FALSE)
VAR colC = IF(ISBLANK([Column C]), TRUE, FALSE)

RETURN
  AND(AND(colA, colB), colC)

     

    You can also create a create a calculated column named NumberOfColumnsMissingData in the table, that counts the number of required columns that are missing data.

    NumberOfColumnsMissingData = 
VAR colA = IF(ISBLANK([Column A]), 1, 0)
VAR colB = IF(ISBLANK([Column B]), 1, 0)
VAR colC = IF(ISBLANK([Column C]), 1, 0)

RETURN
  colA+colB+colC

     

    Hope this helps. If so, please give a Kudos 👍 and mark as Accepted Solution ✔️.

PhilipTreacy's avatar
PhilipTreacy
Super User
9 months ago

Hi Anonymous 

 

Please provide some sample data and show the desired result.

 

It's impossible to know from your description how your data looks so any answer you receive will certainly need modificartion before it works for you.

 

You say you have contract data - is there only 1 owner per contract?  Multiple owners?  Can a single owner own more than one contract?  How many columns do you have?  Can they all be missing data or just some of them?

 

When you apply filters what values do you want to see on screen?

 

Regards

 

Phil