Forum Discussion

afrutos's avatar
afrutos
Resolver I
4 years ago
Solved

Target visual

Hello everyone, I would like to know how I can get the following.
On my target visual, I would like it to count me how many idobra there are based on the filter of the measure "Filter ob".
Filter ob shows me: Work Complete, Work Incomplete, D Incomplete, PL Incomplete.

So I would like the card to be able to count how many different IdObras there are for PL Incomplete.

 

And I can't use Filtro Ob in the Filters panel because it's a measure.



Thank you!

  • PVO3's avatar
    PVO3
    4 years ago

    Don't share the original file. Just create an example file with the same problem. Then upload it to some upload site and share the url with the community.

11 Replies

  • PVO3's avatar
    PVO3
    Impactful Individual

    It's hard to tell with only this information. An example file would help.

    At least show the measure [Filtro Ob].

    • afrutos's avatar
      afrutos
      Resolver I

      I know, for me it's not posible to share the file.
      this is Filtro Ob: 

      Filtro Ob = SWITCH(TRUE(),
      [ComprobacioD]= "Completada" && [Comprobacio PL] = "Completada", "Obra Completa",
      [ComprobacioD]="Completada" && [Comprobacio PL]= "Incompleta", "PL Incompleta",
      [ComprobacioD]="Incompleta" && [Comprobacio PL]= "Completada", "D Incompleta",
      [ComprobacioD]="Incompleta" && [Comprobacio PL]="Incompleta", "Obra Incompleta")
       
      • afrutos's avatar
        afrutos
        Resolver I

        I try to explai better myself;
        Filtro ob tell me if my play is completed or not, and it's on a measure table.
        And I have my table AUT Agrupada, which contains idobra, it's and unic id for each play.
        Both tables are NOT conected.

        And I need to count how many idobras there are that are PL Incomplete