Forum Discussion

ArchiveUser's avatar
ArchiveUser
Qrew Captain
6 years ago

mutiple choice with multiple selection, multiple X values in pie chart

Hi all,

I'm new in the platform and would like to explore several capabilities of this platform.

Currently, I have issues in trying to manage the following issues:

I want to be able to log multiple Serial Numbers of my battery used for an operation. (3 is used at 1 time) Hence, I could only create 3 different fields for [Battery S/N 1], [Battery S/N 2], [Battery S/N 3]

hence in my multiple choice, there are several options.
E.g
001
002
003
004
005
006
007

When I try to build up a pie chart, I could only choose the X- axis to either be [Battery S/N 1], [Battery S/N 2] or [Battery S/N 3]. I want to be able to build a pie chart which can evaluate the total number of hours used by each battery so I can have a clear understand which one would require maintenance, etc. 

Additionally, I would want the system to prompt to my homepage whenever a Battery S/N reaches 50hours for example, how do I go about doing that?

Would appreciate any help asap!

Thanks.

8 Replies

  • You should have a table of Batterues
    You should have a table which records when the machine is used.
    Then the machine table needs to have a child table with the three battery Assignments used for that usage and you will lookup the hours used from the Parent Record.

    Then you can run all kinds of statistical reports.
  • Hi. Thanks for the clarifications! I've got it sorted out after reading your comment.

    Are there any ways I could set a notification to pop-up on my home screen?

    For example, if the batteries are used for a total of 30hours, a pop up appears on the home screen to notify me upon reaching the no. of hours required to send for maintenance. 

    Thanks!
  • No problem. Just make a report of batteries with excessive usage and put that report on your homepage.
  • How do i make a prompt/indication if the value goes above what i have set?
  • I've Made a simple formula to indicate certain texts,

    If([Total Flight Time]<=100, "Green", 

    If([Total Flight Time]<150,"Yellow","Red"))

    However, instead of just texts i want an image of [Red],[Green] & [Yellow]. Is that possible?

    Thanks.
  • hi, how do u change between numeric(reference) and text(reference) without screwing up the existing relationship between the various sheets?
  • I suggest that you post this as a new question and explain your relationships and the field you want to change.