Forum Discussion

James96's avatar
James96
Frequent Visitor
2 years ago
Solved

Filter combinations

Sample dataset  Table name :- Travelers . Vehicle  Name. Bike.       A1 Car.        A2 Train.      A3 Bike,car.  A4 Flight.     A5 Flight,car A6.   Slicer Car. Train. Bike,car (Don't wan...
Need Help
  • parry2k's avatar
    parry2k
    2 years ago

    James96 because you have extra comma in car,ship value, it is like car,ship, if it is car,ship then it will work. It is an issue with data inconsistency.

parry2k's avatar
parry2k
Super User
2 years ago

James96 Based on your question the solution I gave you, should work or I'm not following your question. How far do you go after splitting? Did you use it on the slicer and select car and bike? What Name did you get? Also, how about selecting only car or bike, what names do you get?

  • James96's avatar
    James96
    Frequent Visitor
    2 years ago

    I will say with example

    "Vehicle".       "Count". "Category"

      Car.                 5.            A1

      Bike.                2.          A2

      Car,Bike.          3.          A3.

     

    Slicer.

    Bike.

    Car

    .

    When I click Bike need to show  2(sum)

    When I click car need to show  5(sum)

    When I click Bike and Car it need to show 3(sum)

     

    But if I splited like you said 

    Bike  2

    Car.   5

    Bike  3

    Car   3

    Here when I click Bike and Car it shows total sum values(13) only.

     

    I hope you got it parry2k