Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Count Distinct in visual issue

Hi all,    hope you can help me with this.  I am trying to have a card visual where I want to count product numbers from a dataset, uploaded through a query.    The issue is with the visual when...
Need Help
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi Joe, 

 

thanks for your answer! 

I tried actually to set the cross filter on single, indeed the count works fine, but then the visual won't work when I filter for example on the store number. 

the dashboard I am trying to build is an overview of the manual orders raised by stores, The visual with the count, is the number of products that have a parameter set up, what I would like to see now is that when I filter on a store number the visual will count those products for that store from the new table uploaded (called MIN_MAX) 

this is the screenshot of the relationship. 

I hope it's clear apologies if not! 

 

 

Joe_Barry's avatar
Joe_Barry
Solution Sage
1 year ago

Hi Anonymous 

 

Let's do some troubleshooting

 

  • Is your date table marked as a date table?
  • Set the Date Table relationship one to many from the Date Table. Please make sure that these columns are the same format example "Short Date"
  • In the Store Dimension Table, is the relationship with Manual Order Query with the Service Centre ID in both tables?Any mis-match will result in the table not being able to be filtered.
  • Do they have the same format? As in both columns are either Text or a Integer?
  • Double check the relationships in all the tables with the above

If it still doesn't work, are you allowed to send me a copy of your file? I will take a look.

 

Cheers

Joe