Forum Discussion

Fátima's avatar
Fátima
Helper II
3 years ago

Filter radar chart data by two separated filters

Hi!

 

I have a radar chart where I would like to show a comparison in time of the registers I have on a dataset. The expected output would be similar to this:

Is there a way where I can have the blue and the yellow area show the same column, but filtered by different dates? Right now I have on the Y axis the same column added twice, they are both overlapping on the blue area, and if I change the filter it affects both the same way. The idea is, for example, that the blue area shows the results taking into consideration all the rows of the dataset and the yellow one just the ones filtered to a determined date.

 

Thanks in advance, regards!

3 Replies

  • Hello Fátima !

     

    Create a measure that calculates the value based on a Date. Then add the measure to "Eje y" 🙂

    • Fátima's avatar
      Fátima
      Helper II

      Hi JorgePinho !

       

      But will I be able to filter the date the measure is based on? The dates it takes need to be dynamic, so the user can change them, and both areas need to be filtered separately.

       

      Regards!

      • JorgePinho's avatar
        JorgePinho
        Solution Sage

        If you want both of the measures with different dynamic dates you need to have two calendar tables.