About nishantgarg

Hi, I have a module with time and client list as dimensions. The client list looks something like this: Economy Clients - Economy Client 1 - Economy Client 2 Premium Clients - Premium Client 1 - Premium Client 2 The line item, for example, is Revenue. I published the line item as a chart by manually selecting only the Summary levels, i.e. the bar chart with bars showing revenue for Economy Clients and Premium Clients on a time axis.   However, now I added a 3rd category, so my list looks something like this: Economy Clients - Economy Client 1 - Economy Client 2 Premium Clients - Premium Client 1 - Premium Client 2 Luxury Clients - Luxury Client 1   However, the chart does not update automatically as it's not dynamic. Is it possible to dynamically select only the summary levels using a filter in the module? I want to republish the chart but want to make it dynamic so that in future if I were to add more client categories, the chart updates automatically.   Appreciate your help on this.   Best, Nishant ... View more

Hi all, could you help me how best to structure a parallel hierarchy list that we need as part of our ongoing business analysis. Here's the construct that I'm looking at. At the bottom level we have Clients that we need to be able to aggregate by different attributes. These attributes are: Client: Client 1, Client 2..... Client 10 Geography: Geo 1, Geo 2 Model: Model 1, Model 2 Category: Category 1, Category 2, Category 3 Status: Status 1, Status 2 I thought about creating flat lists with all of the above, but the issue is that with multiple parents for the same item (i.e. Clients), I can't get auto aggregation at various levels. Would greatly appreciate if someone could advise on the best way to get this done.   Many thanks, Nishant ... View more

Hello, I want to disable the editing of data in a dashboard. I would like to be able to edit the dashboard design, but not the data in the grids / charts that have been published from the saved views in the modules.   I have disabled the "edit" options in the menu but that doesn't prevent editing the data.   Appreciate your help, thanks! Nishant ... View more