asked on May 13, 2022
Hello,
I'm going to buy this component. I'm testing if it can do what I need. Currently I stuck on creating pivot table with custom columns. I have data:
[
{"ID": 1, "Floor": 1, "IsSold": "true"},
{"ID": 2, "Floor": 1, "IsSold": "false"},
{"ID": 3, "Floor": 2, "IsSold": "true"},
{"ID": 4, "Floor": 2, "IsSold": "true"},
]
I need table:
Floor | Total per floor | Sold | Left | %
I can not find, how can I add conditional columns, like ("Sold", "Left" and "%").
I need something like: sum(if("Sold" = "true", 1, 0))
then: count("ID") - sum(if("Sold" = "true", 1, 0))
then: sum(if("Sold" = "true", 1, 0)) / count("ID")
But condition does not work like that. How can I work with conditions, which filters data by string value, but not number?
⋅ May 13, 2022
Hello, Mantas,
Thank you for reaching out to us.
Currently, string comparison options for calculated measures are not supported in Flexmonster.
As a workaround, you could edit your data set by changing the values of the "IsSold" field. For example,
[
{"ID": 1, "Floor": 1, "IsSold": 1},
{"ID": 2, "Floor": 1, "IsSold": 0},
{"ID": 3, "Floor": 2, "IsSold": 1},
{"ID": 4, "Floor": 2, "IsSold": 1},
]
This way, you can use the new "IsSold" in your calculated values.
We hope it helps. You are welcome to write to us in case further questions arise.
Kind regards,
Nadia
⋅ May 16, 2022
I have translated file. All translations work except "Fields" window. None of English values are translated there. Is this is not translatable on purpose?
I does not work in German from https://www.flexmonster.com/doc/localizing-component/ too.
