Calculated columns as X axis in Bar charts

When we create a calculated column that gives the sum with a condition, how can I show that on x axis in bar chart. 

I want to show contracts that are expiring in next 30 days, 60 days and 90 days on a bar chart. I am able to create 3 calculated columns for this but not able to plot. 

The query I used is :

sum(

    if(

        diff_days(now(),${fact_contract.expirationdt_date}) <= 90,

        ${fact_contract.count},

        0

      )

   )

6ce8f29f-9f6d-45e1-983f-2bb5b8d5003f.png
This is my table

I want a plot that should be like:

c03ea725-ca65-4da6-9ab5-9bbe311d96da.png

Any help would be highly appreciated.
Thanks in anticipation

0 0 127
0 REPLIES 0
Top Labels in this Space
Top Solution Authors