Forum Discussion

mifrasmm's avatar
mifrasmm
Helper I
9 years ago

Stack Bar Chart

Hi    Im running SQL direct query , I having stack bar that calculating current status . is there anyway i can get available (Remaining) vechicles in stack bar. I have got PICKUP  24 , TRUCK 57 , V...
Need Help
mifrasmm's avatar
mifrasmm
Helper I
9 years ago

 

 

Hi Lydia ,

 

Thanks for replying 

 

Counting equipment type , Return status "NO" , fetching live details

 

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi mifrasmm,

Are all data stored in a single table? And do you want to count the number of each EQUIP_TYPE with "NO" status? Please help to post the expected result here.

Thanks,
Lydia Zhang

  • mifrasmm's avatar
    mifrasmm
    Helper I
    9 years ago

    HI Anonymous,

     

    I have two table

     

    Vechicle details

     

    EQUIPMENT_CODEEQUIPMENT_TYPE
    A 28587Truck
    C 84857VAN
    D 95868Truck
    E 51643Bus
    F 31655Truck
    F 48681Bus
    F 64406Truck
    F 65808Truck
    F 66304Truck

     

    Then Live data, When vechicle go it will be NO status, when its return it will change to YES

     

    Now i can see how many currently out with status of NO , I just want to see how many remaning 

     

    i think given solution will work , if i create one more table with constent value ( VAN = 36 , TRUCK = 57 , PICKUP = 24) , Any other idea 

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Hi mifrasmm,

      Where do these values (VAN = 36 , TRUCK = 57 , PICKUP = 24) come from? For example, for Van, you plus the number of "NO" status and "Yes" status, then you get 36? And do you want to count the number of "Yes" status for Van, TRUCK and PICKUP now?

      Thanks,
      Lydia Zhang