Gowtham Senthilkumar

1. Community
2. Dashboard Design
3. How to Total Weighted Score on Pivot

Kahel,  The approach that I suggested works only when Account is there and you want the value on the Sub-total or Grand total.  For your use case, try something like this:  SUM([Account],[Weighted ...

• View comment
• Gowtham Senthilkumar
• Created August 27, 2019 19:51
• 1 vote

1. Community
2. Dashboard Design
3. How to Total Weighted Score on Pivot

Kahel,  Go to the menu of the Value "Total Weighted Score" and select "SubTotals By" and then select 'Sum'   Thanks,  Gowtham Senthilkumar BI Consultant

• View comment
• Gowtham Senthilkumar
• Created August 27, 2019 19:27
• 1 vote

1. Community
2. Dashboard Design
3. Indicator needs to show AVG for all values as secondary

Javier,  In the expression AVG(Country,SUM(Sales)) - Click on the Country and choose 'Edit filter'. Now you have many options to go about:    If you choose 'List Filter' -> Unselect all the members...

• View comment
• Gowtham Senthilkumar
• Created August 23, 2019 19:19
• 0 votes

1. Community
2. Dashboard Design
3. How to display only relevant data in filter

Dima,  For now, it doesn't work the opposite way with the Out of the box capabilities of the product.    Thanks,  Gowtham Senthilkumar

• View comment
• Gowtham Senthilkumar
• Created August 20, 2019 23:05
• 0 votes

1. Community
2. Elasticube Data Management
3. Errors trying to do a Left Join

Mike,  The below should fix it. SELECTb.CompanyCode,b.CustomerCode,b.ContractNumber,b.RevenueDate,b.Revenue,b.ContractKey,amount.amount FROM[WO_SC_RevenueSchedule] b LEFT JOIN(SELECTt.CustomerCode,...

• View comment
• Gowtham Senthilkumar
• Edited August 16, 2019 23:19
• 0 votes

1. Community
2. Elasticube Data Management
3. Errors trying to do a Left Join

Hey Mike,  The query that isn't working is due to the missing parenthesis.  Try this:  SELECT b.CompanyCode,b.CustomerCode,b.ContractNumber,b.RevenueDate,b.Revenue,b.ContractKey,amount.amountFROM [...

• View comment
• Gowtham Senthilkumar
• Created August 16, 2019 22:55
• 0 votes

1. Community
2. Dashboard Design
3. Working with time interval

Nishya,  In this case, to do any type of arithmetic operations, the final step is to convert the time interval which is in multiple units ('x' days 'y' hours 'z' minutes 'a' seconds) into the lowes...

• View comment
• Gowtham Senthilkumar
• Created August 16, 2019 19:36
• 0 votes

1. Community
2. Dashboard Design
3. YTDSUM doesn't work

Precy,  When you're using YTDSUM function, you need to have the reference of 'Days in Date' in your widget and that is how the sum, from the start of that year till the referenced date, is calculat...

• View comment
• Gowtham Senthilkumar
• Created August 15, 2019 15:35
• 0 votes

1. Community
2. Dashboard Design
3. How to display only relevant data in filter

Hello Dima,  For your use case of dashboard filters, the Dependent Filters could be a possible solution. You could first create a filter on the 'Region' and then create a dependent filter for 'Sale...

• View comment
• Gowtham Senthilkumar
• Created August 13, 2019 18:02
• 1 vote

1. Community
2. Plugins
3. Jump to Dashboard not working

Then, the one to check is the _drill_<Dashboard Name>. As I mentioned earlier, you should have atleast one dashboard with that prefix.    Thanks,  Gowtham Senthilkumar

• View comment
• Gowtham Senthilkumar
• Created August 12, 2019 22:23
• 0 votes