Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I would like to have number of reports in above table wise. ReportID is unique. Can anyone help on this.
Thanks!
you can use expression as
Count(Distinct ReportID)
and Month & Year as Dimensions
Hi Shraddha,
If i do in suggested way, I will get the all previous year data in same column. I am looking for the values as shown above.
Thanks..
You will have to create Pivot Table.
you can have Row dimension as Month & Year as Column Filter
It is coming in the above way...
in this Table you have Month-Year as One field.
You need to have Year as a Separate Field & Month as Separate one.
then you can create chart as required.
Hi,
do you have year and month field as 2 different field in back end.
If not then create it and use that field as dimension.
there is another way using calculated dimension.
1: subfield(MonthYear,'-',1)
2:subfield(MonthYear,'-',2)
Expression
Write your eexpression
Reards