Hi, I need to create a bar chart in Good Data where there is a column named 'Count of days' and another column named 'interval' need to be created in which we need to display if the column named 'Count of days' is having count from 0 to 30 then column named 'interval' should display 1 ,if the column named 'Count of days' is having count from 30 to 60 then column named 'interval' should display 2, ,if the column named 'Count of days' is having count from 60 to 90 then column named 'interval' should display 3 and so on. How to do it in Good data?

Hi Preetham, you should be able to achieve this using a case statement

HOW TO WRITE CASE IN GOOD DATA. CAN U PLEASE SHOW ME AN EXAMPLE??? AND ARE WE WRITING IT IN METRICS???

Hi Preetham, there are examples provided in the above documentation, and yes, this is a metric that you would be creating. You would need to set definitions in the metrics for each of those number ranges. However, this all depends on your LDM and how your datasets are connected. If you are building a metric/report from scratch and have issues it would be beneficial to have screenshots, and details as to what you are seeing vs. what you are expecting to see.