Forum Discussion
Solved
Group by columns
Hi, I have a DB table which has data as the following: Version Distance Date 5.0 12 2014-02 5.0 10 2014-03 5.2 130 2014-01 5.0 1...
Nicole You do not have to do any thing in the data model in order to accomplish this task.
Put all the three columns in a Table visual. Now drag the distance column again and drop it on table visual and chage the aggregation of this column to Count and your task is done.
Hello All,
I am facing issue in calculating Percentage value based on aggregation of dimension. Currently it shows incorrect values
Scenario is like this
CY denotes Current Year
PY denotes Previous Year
I want to calculate ((cy-py)/py)*100) as per multiple dimension i.e Gender, AGe Group, Location, State etc.
Please help me to get the solution.