Forum Discussion
Arkhos94
Helper IV
Helper IVTable - show warning message if too many row
I have a report that show if my commercial team performed their sales correctly On the bottom half of the report page, there is a table showing the list of the sales that has not been performed corr...
Hi Arkhos94 ,
This might work but it's a tricky one.
1. Your measure to count the number of rows should be something like this:
CountRows = IF( COUNTROWS( 'Table' ) > 3, "Too Many Rows", "" )2. Add a card visual and lay it over the top of the table. Ensure the background is 100% transparent. Add your CountRows measures.
3. Set up conditional formatting on the card as follows:This won't necessarily replace the table but add a message overlayed on top of it.
Adescrit
Impactful Individual
Impactful IndividualHi Arkhos94 ,
This might work but it's a tricky one.
1. Your measure to count the number of rows should be something like this:
CountRows = IF( COUNTROWS( 'Table' ) > 3, "Too Many Rows", "" )
2. Add a card visual and lay it over the top of the table. Ensure the background is 100% transparent. Add your CountRows measures.
3. Set up conditional formatting on the card as follows:
3. Set up conditional formatting on the card as follows:
This won't necessarily replace the table but add a message overlayed on top of it.