![Contributor](/html/@7F22A031F429FE81AFED819B1E5863E0/rank_icons/Community_Gamification-Ranking-Icons_16x16-Contributor.png)
Contributor
2021-01-29
07:39 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Fixar KPI
Pessoal... Bom dia!
Tenho um KPI que precisa ser demonstrado de forma fixa, mas ele depende de um filtro.
If ([Status Atual] = 'ANÁLISE CONCLUÍDA', Count (DISTINCT [NUMERO]))
Coloquei da forma acima... mas assim ele só aparecerá a informação quando o filtro 'ANÁLISE CONCLUÍDA' estiver selecionado.
Qual a forma se fixar este valor, sem ser necessário filtrar?
3 Replies
![MVP](/html/@09D7DA47DFD811898EDA3D072B967C58/rank_icons/Community_Gamification-Ranking-Icons_16x16-MVP.png)
MVP
2021-02-01
05:50 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@FabianaMRS Maye be like :
=Count({<[Status Atual] ='ANÁLISE CONCLUÍDA'>} DISTINCT [NUMERO])
Regards,
Taoufiq ZARRA
"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "
(you can mark up to 3 "solutions") 😉
Taoufiq ZARRA
"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "
(you can mark up to 3 "solutions") 😉
693 Views
![Contributor](/html/@7F22A031F429FE81AFED819B1E5863E0/rank_icons/Community_Gamification-Ranking-Icons_16x16-Contributor.png)
Contributor
2021-02-02
12:44 PM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Preciso que o valor fique fixo e não se altere à medida dos outros filtros que for colocando.
683 Views
![MVP](/html/@09D7DA47DFD811898EDA3D072B967C58/rank_icons/Community_Gamification-Ranking-Icons_16x16-MVP.png)
MVP
2021-02-03
02:58 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
=Count({1<[Status Atual] ='ANÁLISE CONCLUÍDA'>} DISTINCT [NUMERO])
Regards,
Taoufiq ZARRA
"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "
(you can mark up to 3 "solutions") 😉
Taoufiq ZARRA
"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "
(you can mark up to 3 "solutions") 😉
663 Views
![](/skins/images/DA93A62CB05DE8EBAC29EA917B0E5CFF/responsive_peak/images/icon_anonymous_message.png)