需要有关数据质量审核报告的建议 [英] Need advice on data quality review report

问题描述

我要求制定数据质量报告。我想展示它的视觉表现。建议我哪种是最好的图表类型。

Hi, I have a requirement to develop data quality report. I want to show visual representation of that. Suggest me which is best type of chart.

让我解释数据......它不是相关数据。每行都有唯一数据

Let me explain data...it is not related data. Each row will have unique data

数据...

id＃name  #upitlimit  #downitlimit #count

id # name  # upperlimit  # lowerlimit # count

1＃记录丢失＃100＃1  ＃101

1 # records missing # 100 # 1  # 101

2＃到期日错误＃20＃1＃18

2 # due dates are wrong # 20 # 1 # 18

3＃状态未更新＃10＃1＃25

3 # status not updated # 10 # 1 # 25

如果count不在上限/下限，则应显示为红色。建议我这样的图表类型，以便我可以容纳这些数据。

If count is not in upper / lower limits, then it should be displayed in red. Suggest me type of chart for this so i can accommodate this data.

推荐答案

嗨kdinuk，

Hi kdinuk,

根据您的描述，抱歉无法完全理解您的数据。你的意思是，这个数据集中只有三行1/2/3？

According to your description, sorry that can’t fully understand your data. Did you mean, that there are only three rows 1/2/3 in this dataset?

如果你的目标只是想象计数是否在极限范围内，我会建议你使用表和指标。

If your goal is only to visualize if the count is in the limit range or not, I would suggest you to use table and indicators.

或者，如果您想要显示限制范围和计数，我建议您使用"范围列"图表。

Or if you want to visualize both the limit range and count, I would suggest you use "Range Column" chart.

在这里查看我的设计。

See my design here.

另外我们需要设置使用表达式计算系列填充颜色（或计算系列标签颜色）：

Also we need to set the count series fill color (Or count series label color as you like) with expression:

=iif(fields!count.Value<Fields!lowerlimit.Value or fields!count.Value>Fields!upperlimit.Value,"Red","Automatic" )

查看我的测试结果。

希望这会有所帮助。

最好的问候，

Lukas

这篇关于需要有关数据质量审核报告的建议的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！