Reverse Action & Add Most Frequent Price Calculation, Create Price Buckets

Answered
Jennifer Phillips asked on February 11, 2022

I have multiple questions I thought I would address in one ticket. 

  • Is there a way to reverse an action? (Similar to control z to go back)
  • Can we create a calculated value for 'Most Frequent' price point?
  • Can you create price buckets i.e. $0.00 - 5.00, $5.01 - 10.00?

Regards, Jennifer

1 answer

Public
Nadia Khodakivska Nadia Khodakivska Flexmonster February 14, 2022

Hello, Jennifer,
 
Thank you for reaching out to us.
 
Please find our answers below:
 

  • Currently, Flexmonster does not provide an option of reversing the action. As a workaround, you can create your own function of undoing the action using getReport and setReport API calls. Please check the following JSFiddle for reference: https://jsfiddle.net/flexmonster/p8rg9nhz/
  • There's no option to add such calculated value, but instead, we recommend creating a new report. Select Price value as a measure with count aggregation and at the same time add Price to the rows. Then filter, for example, the top 5 frequent values and see the results. The described approach is illustrated in the following JSFiddle: https://jsfiddle.net/flexmonster/bkwt3vsx/
  • We recommend achieving such functionality by preprocessing data the desired way before passing it to Flexmonster. Consider creating a new "Price bucket" column based on the "Price" field. If the "Price" value is, e.g., 3.99, then "Price bucket" has string value "$0.00 - $5.00".

 
We hope it helps. You are welcome to write to us in case further questions arise.
 
Kind regards,
Nadia

Please login or Register to Submit Answer