I am trying to create a bar chart which has to build a bar for each dimension that I use. But I am not able to get the bars correct. I cannot post the file here due to internal security of the data.
Here is what I am trying to do
Dimensions:
if(Today()-[Scan Date]>90, 'Expired1','Not Expired1')
if(Today()-[Scan Date1]>90,'Expired2','Not Expired2')
Expressions:
Count(Distinct[Application Name]))
----------
All I need to see is two bars - one for the Scan Date and the other for the Scan Date 1 with the number of applications corresponding to the conditions. Please help me if anyone knows how do get this done.
