I have a table with records of items sent, and a field that is set to a date if the item is accessed by user.
I can do various group by’s to show 2 columns - (count), and (countif accessed by date is >0)
good
How do I add a 3rd column which shows the percentage accessed
ie. (countif accessed by date is >0 ) / count *100
eg: How do I create the “% accessed column” in the example below (data grouped by Branch - 1 row for each item sent) - my current question built has the 1st 3 columns but cant figure out how to add the 4th column
Branch. Items Sent. items accessed. % accessed
xxxx. 1000 500 50%
yyyy 2000 200 10%
etc.
Thanks in advance !!
Hi @Robbo
Please post “Diagnostic Info” from Admin > Troubleshooting.
Can you post the actual Custom Expression you’re using?
I don’t see why it shouldn’t be possible.
so have a :question with a few joins
then have a "Summarise"
"Bundles Sent" = count
"Bundles Opened "= countif ([page visited at] >0). ,,, this set to a date or null
by
Branch
so sent = eg: 100; accessed = eg: 50
so need another column to dispkay bundles opened / bundles sent
so can define it (see screen shot)
I have a similar issue.
When I used v0.36.x the question worked, with the update to 0.37.x, the return is "Unknown column 'Ponto de Acesso.bairro' in 'field list'".
My join is with another saved question (Caixas por Bairro - Fco. Beltrão).
@flamber Looks like I didnt give you all the info ? I;ve updated to actually latest is 37.2 not 37.1 - edited existing question to add %opened = bundles sent/bundles open * 100 (note that bundles sent is count, bundles open is countif (field >0)) - see screen shots
still get same error "Unknown column 'source.Bundles Sent' in 'field list'"! Hope you can solve . DO i need to rebuild the question again now that I have upgraded ?? maybe that will fix ?Thx
Neil
@Robbo Okay, so you were using the Custom Expression from the metric (Summarize) in the Custom Column - there’s an issue for that, which is most likely a duplicate of an existing issue: https://github.com/metabase/metabase/issues/13857 - upvote by clicking on the first post