title: How to get a pivot of a non numeric table?
body: <p>In workshop, I have a requirement of a pivot table but the columns of the aggregation dataset are non numeric. Now foundry doesnt allow aggregation over string/other values.</p>
  <p>I need to do a conditional flag like value over few of these columns(ex: case when x then 1 else 0) and then do a sum/count of the values, hence aggregating it and displaying a pivot.</p>
  <p>I am not preparing this data in the backend since i want the data to be updated at ontology level, if i include in dataset in the backend then i will have to wait for the pipeline build to run until the next day which is slowing the user process.</p>
  <p>What can be the best ways to achieve it? Kindly help.</p>