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
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