I have dataset that has date field and boolean field:
date: << date_format >>
connected: << boolean >>
team: << string >>
date: Jan 1, 2021 @ 13:05:42.000,
date: Jan 2, 2020 @ 16:53:22.000,
I would like to create a visualisation that will have the following properties:
x axis -> date histogram (1 week)
y axis -> percentage (how many entries are in given period with connected: True)
Ideally it should be one line or bar (stacked / separated) per ‘team’ field.
Can you advise how to achieve such goal? I was able to create ‘horizontal bar’ with split series on ‘connected’ field but this, as you can see is not matching exactly requirements (as showing absolute numbers, not percentage).