Forum Discussion

Petan65's avatar
Petan65
Frequent Visitor
3 years ago
Solved

RANKX always returns 1

Hello,   I went throught a lot of threads about this topic but any of the solutions hasn't work. I probably know why it's not working, but I don't know how to fix it. The reason is because all 3 cu...
Need Help
Ritaf1983's avatar
Ritaf1983
Icon for Super User rankSuper User
3 years ago

Happy to help 🙂

Petan65's avatar
Petan65
Frequent Visitor
3 years ago

Sorry to bother you again. I thought that it all works as it should and in final step it stopped :/. Do you know why card visual does not show filtered value? Istead it shows total. Thank you
This link

  • Ritaf1983's avatar
    Ritaf1983
    Icon for Super User rankSuper User
    3 years ago

    Hi Petan65 
    The card can't be filtered because it doesn't have a row context, unlike tables which are filtered by rows (categories), graphs which have this on axes, etc...
    What do you want from card to show? There is no card on the linked file...

    • Petan65's avatar
      Petan65
      Frequent Visitor
      3 years ago

      Sorry in this file is the card. I need to show in card visual same result as have the table.

      this link  

      Edit: I've run into a second problem. When I would like to show the top 2 by month in the chart visual. It only works when I change X axis from date to "customer". Do you know how to make it work?
      thank you