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

warlock 101 Reputation points
2021-05-07T15:21:52.77+00:00

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 Monitored
Not Monitored
Tag not monitored by Microsoft.
35,355 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Erland Sommarskog 100.1K Reputation points MVP
    2021-05-07T21:41:52.027+00:00

    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.

    0 comments No comments