Avatar

Gowtham Senthilkumar

  • Total activity 43
  • Last activity
  • Member since
  • Following 0 users
  • Followed by 0 users
  • Votes 1
  • Subscriptions 22

Activity overview

Latest activity by Gowtham Senthilkumar
  • Avatar

    Gowtham Senthilkumar commented,

    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 ...

  • Avatar

    Gowtham Senthilkumar commented,

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

  • Avatar

    Gowtham Senthilkumar commented,

    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...

  • Avatar

    Gowtham Senthilkumar commented,

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

  • Avatar

    Gowtham Senthilkumar commented,

    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,...

  • Avatar

    Gowtham Senthilkumar commented,

    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 [...

  • Avatar

    Gowtham Senthilkumar commented,

    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...

  • Avatar

    Gowtham Senthilkumar commented,

    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...

  • Avatar

    Gowtham Senthilkumar commented,

    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...

  • Avatar

    Gowtham Senthilkumar commented,

    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