Is it possible to create a calculated measure in Pygwalker?

[ddealwis09]

Wonder if measures can be created from the base values, for example market share?

thanks!

[longxiaofei]

We plan add customize measure in 0.4.x version.

You can use sql to flexibly set your measure.

Do you have any suggestions?

[353913575]

For example, if I want to calculate the efficiency of equipment, this metric would be defined as eff = sum(re_time)/sum(ty_time). This metric requires aggregation before division. I would like to create such a calculated field in Pygwalker so that when I drag different dimensions, the field will aggregate and then divide according to the dimensions I have dragged,I look forward to your reply,thanks

[longxiaofei]

Yes, This is exactly what a calculated measure does.

[353913575]

This is exhilarating news. I'm already looking forward to using this feature, thank you, super developer!!!

[fabienval]

Would we also be able to "chain" aggregation?
My example would be a dataframe of itemised sales and what I would want to be able to display is:
The average (hourly sum of sales) for each day of the week, while still being able to filter for specific products.
Thanks

[longxiaofei]

Like this? Currently it can be implemented without calculating fields, or maybe I misunderstood what you mean.

@fabienval