Hello,
I have the following data
book="title1" reader="reader1"
book="title1" reader="reader1"
book="title1" reader="reader2"
book="title1" reader="reader2"
book="title2" reader="reader1"
book="title2" reader="reader3"
book="title2" reader="reader3"
book="title2" reader="reader3"
...
I'd like to represent it in a multi-series bar chart showing number of reads by reader per title as in a drawing below:
count
^
| _____________ _____________
| | | | |
| |_reader1_____| | |
| | | |_reader3_____ |
| |_reader2_____| |_reader1_____ |
----------------------------------------------------> titles
title1 title 2
Hi @pitmod ,
Should work with this simple SPL:
| chart count by book, reader
BR
Ralph
| makeresults | eval _raw="book,reader
title1,reader1
title1,reader1
title1,reader2
title1,reader2
title2,reader1
title2,reader3
title2,reader3
title2,reader3"
| multikv forceheader=1
| stats count by book,reader
| chart values(count) as count over book by reader
Note: stacked is middle option of stack mode.
Hi @pitmod ,
Should work with this simple SPL:
| chart count by book, reader
BR
Ralph