Hi,
I have dataset that has date field and boolean field:
{
date: << date_format >>
connected: << boolean >>
team: << string >>
}
e.g.
{
date: Jan 1, 2021 @ 13:05:42.000,
connected: True,
team: US
},
{
date: Jan 2, 2020 @ 16:53:22.000,
connected: False
team: EMEAR
}
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).
Thank you,
Mariusz