Serial Chart Guides based on Percentage

Question

I created a serial chart, with categories from fields.  While the chart shows record count, I'd like to include percentages of overall records, either as a label or using guides.  Is there any way to do this?

If using guides, I'd like something like this:

Neha · Answer

Have you found the solution yet?

jcarlson · Answer

And come to think of it, you could probably just use calculate to update those fields and not even bother with dataframes at all, if you use separate fields.

fs.layers[0].calculate(
    where = '1=1',
    calc_expression = [
        {"field" : "A_pct", "value" : f"A / {rowcount} * 100"},
        {"field" : "B_pct", "value" : f"B / {rowcount} * 100"},
        {"field" : "C_pct", "value" : f"C / {rowcount} * 100"}
    ]

JasonCyphers · Answer

Thanks for the info!  I'll play around with it!