Forum Discussion

simonroyjones's avatar
simonroyjones
Frequent Visitor
8 years ago

Card not totalling correctly

Hi 

 

I have a report which looks at profitablilty by month and the profit is stored in a field called value.

 

Value is a whole number.

 

When I create a bar chart everything looks OK and when I filter the card is fine but when I dont filer the card displays a completely incorrect figure.

 

I've displayed both states below.

 

Thanks

 

Simon

 

1 Reply

  • vivran22's avatar
    vivran22
    Community Champion

    Hello simonroyjones ,

     

    What are you using in the card visual? Is it a measure or a column?

     

    When no filter has been applied on the card, it displays the result for the entire table. 

     

    What is the expected value on the card when no filters are applied?

     

    Cheers!
    Vivek

    If it helps, please mark it as a solution. Kudos would be a cherry on the top 🙂
    If it doesn't, then please share a sample data along with the expected results (preferably an excel file and not an image)

    Blog: vivran.in/my-blog
    Connect on LinkedIn
    Follow on Twitter