奥威软件交流社区
本帖最后由 奥威技术支持 于 2018-11-6 16:49 编辑

        刚接触OurwayBI的小伙伴或许有些晕,公共筛选、筛选控件?都是筛选,为什么要分这么多类型?各自有什么作用,该怎么用?本次BI报表工具操作课,我们将对两者进行系统的区分,从作用对象、地理位置到操作。此外还将赠送作用域、TOPN的用法讲解。

        首先,我们来系统地区分筛选控件和公共筛选。

奥威BI报表

奥威BI报表

        筛选控件

        1作用对象:

        筛选控件包括汇总筛选、维度筛选、公共筛选(小)。汇总筛选针对的是汇总度量值的筛选,维度筛选针对的是行维度的筛选。

2.jpg


        2所处位置:右上角“添加图表”下拉列“筛选”

        公共筛选(小)

        1作用对象:

        公共筛选针对的是明细的筛选



        2所处位置:右上角“添加图表”下拉列“筛选”(为了和右上角作用于整张报表的“筛选”(公共筛选)区分,我们也叫它小公共筛选)

       作用域

        简而言之,就是筛选作用范围的限定。

        当我们在一张BI报表中运用筛选,但不希望该筛选对某一张图表起作用,这是则需要作用域解除对该图表的筛选作用。又如我们不小心删除了对某张图表的筛选作用,这个时候也需要借助作用域恢复其作用。


作用域操作步骤1


作用域操作步骤2

        TOPN(筛选排名前几名)

        当我们需要在浏览状态下筛选排名前10名,前8名之类的,该如何筛选?

        这个时候就能利用TOPN来实现。

       ★    显示前几名,不是应该在条形图里排序?

        筛选排名可以采用条形图显示TOP的方式,事实上,条形图显示TOP的前提是不需要显示所有数据列表,而TOPN则是在显示所有数据列表的前提下供报表浏览者自由选择排名前8、前5等数据。两者用法稍微不太一样。



        TOPN步骤:右上角“添加图表”—TOPN—绑定数据集

        ★    怎么有两个一大一小的公共筛选?

        细心的小伙伴应该也发现了,在右上角有个大大的筛选,我们讲师往往称呼其为“公共筛选”,但在“添加图表”下拉的筛选中不是就有一个公共筛选了吗?

        其实在右上角“筛选”确实是公共筛选,不过它是一个作用于整张报表的,功能点范围更齐全的公共筛选。

        操作参看图解:


图解1


图解2

        关于BI报表的筛选的介绍就到这里,如果大家还有什么操作方面的问题,也可以通过Power-BI 技术支持群2:490470313( 验证暗号:OurwayBI)在线咨询我们的工作人员。


分享到 :
0 人收藏
kse4tt4d  会员 | 昨天 09:18

Camisetas Del Real Madrid CPCE

Guyana has lost a former Government Minister, educator, women’s rights activist,Chaussure Jordan Pas Cher Femme, community worker and psychotherapist, Dr. Faith Harding. Dr. Harding died yesterday afternoon in Guyana after a period of illness.She had been ailing for the past three weeks and was a patient at the St. Joseph Mercy Hospital, in Georgetown. She was born in Cummings Street,Maglie Milan 2018/19, Alberttown, Georgetown.? She secured a Bachelor of Education Degree; Two Master’s Degrees, one in Arts & Curriculum and the other in Education.Additionally, she held a PhD and was a qualified Psychotherapist having done extensive work on the human brain.Dr. Harding was also a Consultant with the World Bank. She was a United Nations Past Consultant. Her work extended beyond the reaches of Guyana as she was also instrumental in the formation of the world’s newest nation, South Sudan, back in 2008, during?her work with the UN.The veteran mental health practitioner was instrumental in developing the Early Childhood (Nursery) Education curriculum for the Cyril Potter College of Educatiion (CPCE) in the 1980s. She also once held the position of Assistant Chief Education Officer within the Ministry of Education.Additionally, she was employed in the Ministry of Planning and Development after which she was asked by then President Desmond Hoyte in 1985. She also restructured the Guyana Public Service after she was appointed Minister within that Ministry.In 1992, she became a Member of Parliament of the People’s National Congress/Reform (PNC/R). In 1999, Dr. Harding was then called by the United Nations (UN) to embark on a peace-keeping mission to help restore democracy and stability to war-torn East Timor. She was also the Deputy- Governor of the Central Bank in that country.In 2008 she came back to Guyana, but was called by the World Bank in 2010 while Sudan was in crisis; and helped create a new South Sudan.In 2011, she ran for the Presidential Candidate position in the PNC/R but lost. It was after the campaigning,Fc Bayern Trikot G??nstig, that Dr. Harding started to use the leftover monies from campaigning,Camiseta Fc Barcelona 2018, in various neglected and vulnerable communities, helping the impoverished and rural women acquire skills and empowerment.One of her largest groups,China Jerseys Cheap, from Long Creek, benefitted much from her assistance.Dr. Harding embarked on awarding four university scholarships. Additionally,Cheap Jerseys From China, over $100,000 in cash grants were awarded to students who needed it. Training was also provided for persons who wanted to become nurses.She instilled a sense of financial empowerment in persons who wanted make money in the agricultural sector, by starting-up a massive sorrel-planting drive. She acquired 40,000 sorrel seeds from the Mexican Embassy,Tottenham Hotspur Jersey Sale, free of cost, in exchange for 400 tonnes of dried sorrel.Just a few weeks ago, she attended a Conference in Nicaragua.Dr. Harding leaves to mourn her husband, Patrick; and her son PJ, her siblings and many, many friends across Guyana and elsewhere. She will be missed by us here at Kaieteur News.
kse4tt4d  会员 | 昨天 11:12

NCAA Jerseys Wholesale former President

A local Drug Enforcement Agency (DEA) office is set for an official opening next week Wednesday.According to an advisory issued by the United States Embassy yesterday, the DEA office will officially be opened by Ambassador Perry Holloway at the US Embassy Duke and Young Streets, Kingston, Georgetown location.The event will include remarks from the Ambassador, a DEA official and a senior Guyana Government official.At a press conference during the latter part of last year, Ambassador Holloway in speaking of the DEA presence in Guyana, disclosed that by January 15, last, an official was already selected and his team would be in place in Guyana.In July 2014,Wholesale Soccer T-shirts, former President,Jerseys NFL China, Donald Ramotar and the previous US ambassador, D. Brent Hardt, announced the establishment of a local DEA office to fight the drug trade.This was following the approval of the DEA office in Guyana by the US Senate.Measures were reportedly apace since then to ramp up activities in Guyana. In fact a number of temporary duty personnel were stationed here.Ambassador Holloway reported last year that the DEA officials have been working closely with the local authorities not only on cases, but also on training and lending of technical assistance. The agencies included the Customs Anti Narcotic Unit (CANU).There have been several high profile drug cases in both Guyana and the US.Guyana,NFL Jerseys From China, because of its geographical location in South America,Air Max Outlet Online Italia, has been a known trans-shipment point for narcotics for years now. The drugs have been making their way over the borders from Venezuela and onwards through the ports to the US or neighbouring Suriname for Europe.Ambassador Holloway himself is no stranger to the drug fight.He served in Colombia at various levels including Director of Narcotics Affairs Section and even in Washington doing work in counter narcotics.Previously,Air Max 90 Pas Cher Site Francais, before July 2014,Cheap Nike Air Max Wholesale, Guyana had to seek help from the Trinidad and Tobago-based DEA office,Terza Maglia Juve 2018/19, in the sharing of intelligence and exchange of mechanisms to tackle drug-smuggling problems.
kse4tt4d  会员 | 昨天 13:18

Jordan 10 Retro Australia 405

By Sharmain GraingerViolence is not a very far-removed characteristic from human nature. This is in light of the fact that human beings, much like animals, seem to have a knack for violence, of course some more than others.Some may be constantly inclined to perpetrate acts of violence, but somehow possess what can be described as an ingrained ability to control their emotions which often drives the desire to be violent.Violence can be demonstrated in many forms, but essentially, persons can be violent against themselves or others as well. There are some persons who have been known to be violent against animals even.But as it relates to human beings, the World Health Organisation (WHO) has defined violence as “the intentional use of physical force or power, threatened or actual,China NFL Jerseys, against oneself, another person or against a group or community, which either results in or has a high likelihood of resulting in injury, death,Cheap Nike NFL Store, psychological harm, maldevelopment or deprivation.”Research shows too that globally, violence resulted in the deaths of an estimated 1.28 million people in 2013, up from 1.13 million in 1990. Of the deaths in 2013, roughly 842,000 were attributed to self-harm, 405,000 to interpersonal violence and 31,000 to collective violence and legal intervention.The evidence certainly points to the fact that human beings are more inclined to harm themselves. This of course has long emphasized the need for increased mental health intervention.This,Hombre/Mujer Mister Cartoon x Nike Cortez QS  LA  Blancas/Rojo Universidad AA4875-002, however, does not mean that mental health intervention is not required to help address the instances that people are violent against each other.There must be cause for concern when individuals, especially adults, can’t be rational enough to deal with issues they face without being violent. But looking to the health sector is certainly not the only available option.It is however interesting that although some acts of violence that occur in our society are punishable by law, many do not even reach a domain of such intervention.Perhaps for this reason, or because of the very fact that many do not give a thought to the possible outcome, violence prevails often unabated in our society.Particularly worrying were recent reports from the Guyana Teachers’ Union (GTU) that there has been an upsurge in the incidence of violence in the public school system. Not at all surprising is it when tempers flare among peers in a classroom and violent reactions result.But when a student,Cheap Air Max Online Ireland, angered by an instruction of a teacher, opts to launch an attack, this is certainly not a situation for a nation to take lightly.It was revealed by the GTU that students have been the initiators of physical altercations with their teachers in the classroom, and in several of these cases, there has been little or no redress forthcoming.Some students have even brought along family members to help “deal with” teachers while on the school premises.Many of these complaints are reportedly brought to the attention of the GTU by teachers who constitute its membership. The GTU is tasked with representing in excess of 7,000 teachers within public schools nationwide.While violence in the school system is not one that is remotely novel,Jerseys NFL Cheap, it is understandably an immense bugbear to teachers and their ability to be effective educators.No teacher should be looking over his or her shoulder while delivering the day’s lesson because a student was not receptive of an instruction or even punished for a misdemeanour.This, however, is the disturbing case in some public schools. But this isn’t to say that there aren’t some teachers who are provocateurs. Many students have complained of excesses meted out by teachers too.When asked about this recently, GTU President Mark Lyte claimed to have no knowledge of such occurrences. In fact he,Air Jordan Pas Cher France, without hesitation, insisted that “those are allegations. We have been speaking to our teachers and we are not aware that teachers are in the habit of injuring children. We know that in many cases some of those children come from home with their injuries and that is blamed on the teachers.”Perhaps the GTU needs to give a closer look at some within its membership.Just recently one of my colleagues spoke of an incident whereby one of her young relatives was nothing less than abused by a teacher. The reason that was allegedly given by the teacher was because the student didn’t cry like the others when flogged.However, we must bear in mind that corporal punishment is not a thing of the past in the public school system and could still be administered with discretion of course, despite many arguments against it. Teachers simply can’t use this mechanism to be vindictive.There are, however, many who are of the belief that if corporal punishment is to remain a staple in the school system, more efforts should be made to make parents and guardians of students more au fait with the process.Maybe, just maybe, this is one area in which the Parent Teacher Associations have been failing.The schooling of a child should be a collaborative effort between the school, parents and of course, the child.This has long been touted as a key tactic to ensure that the delivery of education is effective. And in some cases the effective delivery of education may warrant some disciplinary measures; it certainly didn’t harm the older generation.Perhaps if stakeholders’ collaboration was enforced, the issue of violence in the school system might not have been so pervasiveness and downright worrying.So worrying it is that limited or lack of security at some schools has been called into question.It was recently pointed by the GTU at a press conference that while some schools do have in place regular security guards, some are not capable, even physically, to ward off violent situations on school premises.Addressing the capabilities of these security guards can lead to an employment issue,Man Utd New Kit 2018/19, but this of course is a whole other matter.The GTU is, however, calling on the Ministry of Education to urgently address the prevailing violence situation. Violence many not have engulfed the entire education system, but leaving a situation to fester cannot at all be the solution.As stakeholders of education, the GTU should not have needed the media to help stress the need for the Ministry to address a school-based upsurge of violence; it should have long been addressed. This has left me wondering if there are even more systemic shortcomings within the education system than meets the eye.
您需要登录后才可以回帖 登录 | 注册

本版积分规则

关闭

站长推荐上一条 /1 下一条

奥威软件|联系奥威|新手须知| ( 粤ICP备09215901号-2   

Powered by Discuz! X3.2 © 2001-2016 Comsenz Inc.

返回顶部