Skip to main content
Announcements
Customer Spotlight: Discover what’s possible with embedded analytics Oct. 16 at 10:00 AM ET: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Calculated Dimension in Bar chart

Hi Community,
I wnat to create a chart with two dimensions(Report Month, Category) , Category contains one calculated Value (NICO)
Now Dimensions are : Report Month
                     Category_Name(Dispute, Legal Dispute, Collectible, NICO --> Calculated value in Script as below)


For the calculated dimension i created a dummy Dimension at backend by using Inline function

Load *Inline[
CategoryName, Category
Dispute, Dispute
Legal Dispute, Legal Dispute
Collectible, Collectible
, NICO
];

So by this i can able to get the NICO in Category. But the problem arises while assigning a value for NICO.

Expression used :
=if(Category='NICO',sum({<CompanyID={'C0,'c1','C2'}>}Amount),sum(Amount))

12 Replies
Not applicable
Author

It seems, it is working. Some of the companies will fall under "NICO" Criteria. So I want to show them in Seperate Stack of Bar. As you Said if(match(CompanyID,'C0','C1','C2','C3'>0, "NICO',CategoryName)  is parfectly working as i want.

Hope it is understandable. Soon i will post .qvw file with some sample data

Not applicable
Author

Hi Team,

I have added a sample report for better understanding. Hope it helps...

Not applicable
Author

Thank you for your help