question

warlock-1010 avatar image
0 Votes"
warlock-1010 asked MelissaMa-msft edited

How contact sql with tableau so that if there was a mistake in report he marked it as red?

Hi,can you help me? Suppose i have data source for tableau to perform report.
dbo.myreport
Also i check is the value(s) right or wrong?
Let me provide picture to be more clear
![94872-image.png][1]


i create query that check is the value(s) right or wrong. For example 6,6 is wrong and in dbo.checkmyreport i have structure
date;variable;value;right-wrong
07.05.2021;x1;6,6;wrong
how to do to if value from dbo.checkmyreport marked is wrong then it must automatically must be marked as red in tableau report.
Is there possible?




not-supported
image.png (11.3 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @warlock-1010,

Welcome to Microsoft Q&A!

Per your description, I think your issue might be related to tableau. If so, please post your issue in the corresponding forum and you will get more professional help from many experts.

If you have any issue with SQL Server or other Microsoft products, please feel free to post one question here!

Thank you for understanding!

Best regards
Melissa

0 Votes 0 ·

1 Answer

ErlandSommarskog avatar image
0 Votes"
ErlandSommarskog answered

You have labeled this with the tag sql-server-transact-sql, but this is nothing you can do in T-SQL. All you can do is return an extra column to the client (in this case Tableau) that indicates that the data should be rendered in a special way.

As for how to implement that red arrow in Tableau, you will need to ask in a Tableau forum.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.