Take Data From Firebase And Display It

[Nur_Hasanah]

The firebase dummy data looks like this
:

 {
  "SensorData": {
    "2025": {
      "07": {
        "01": {
          "temperature": 27.5,
          "turbidity": 6.8,
          "ph": 30.2
        },
        "02": {
          "temperature": 27.8,
          "turbidity": 6.9,
          "ph": 31.2
        },
        "03": {
          "temperature": 28,
          "turbidity": 7.1,
          "ph": 30.9
        }
      }
    }
  }
}

(``` added for readability - ABG)

I want it filter data (yyyy-MM-dd) of the firebase based on label.Text that appear on that screen.. Then take the filtered data and display in Chart and Chart2D - how to call the firebase and filter it??? Help me to provide the code for the block​:sob:

[TIMAI2]

If you want to filter Firebase realtime database directly, then you will need to set indexes in you secure rules in Firebase, then write a suitable query

[ABG]

Assuming this is the flavor of Firebase that can be accessed by the AI2 Firebase component, this can be accomplished using the Clock component and two date pickers to generate a list of daily keys under ProjectBucket SensorData in the date range bounded between the two Date Pickers:

'2025/07/01',
'2025/07/02',
'2025/07/03',
...

The value obtained from each key would be a dictionary with three key/value pairs, which you could access using AI2 dictionary blocks.

Rather than machine gun Firebase with all the keys at once, I recommend keeping a global list of keys that have not yet been requested, and asking for the next after receiving a key/value. Deplete the list (remove item 1) to avoid having to deal with an extra index variable.

If still unsure, export and post your aia file.

Further thoughts:

Your filters are unwieldy. Months do not have weeks that align with calendar weeks.

Study the Clock component and its date and time conversion and formatting capabilities, especially how you can Add a Day to an Instant to get another Instant, and how to format that Instant into a date key matching your structure.

To satisfy the Chart components, use x as days from the start of the filter range, to get x = 0,1,2,3,...

[Still_Learning]

Something like this?

blocks are draggable. Remember here i have taken only one month even if you have more month in the data. since your data is semi furnished i am suggesting this.