07-28-2015 05:09 PM
I have several issues regarding building and viewing custom graphs -
1. My supervisor created a custom graph and saved it in a public folder. But when I go to report designer, I am not able to open the template to be able to use it. However the "2G reports" are shareable and viewable.
2. I am trying to create a bar-line chart with 2 Y axes and X axes as time. A few issues here -
a) time is at a very granular level of data - daily. I want to able to aggregate it to weekly level and have the X axes say "week of 1/1/2015 - 1/7/2015" ....
b) How do I used shared roles? I need both the line graph and bar chart to have a common measure split by group (say spend and CPV by channel)
c) I would need the multiple line graphs to show the break down and 1 line graph to show the total CPV.
I cannot post any graphs since the size limit is 1K and my graph in zipped format is 52 KB.
07-30-2015 03:32 PM
The more I explore, most of the issues seem to go away over a period of time. I do have a custom field (CPV) that calculates the 'Actual Spend'n/'Vis to BLU'n. When I compare a very simple crosstab report in Data exploration to the original excel spreadsheet, I get this issue -
The cpv value matches at this level of aggregation -
Country Actual Spend Vis to BLU CPV
The cpv value does not match here-
Country Market Actual Spend Vis to BLU CPV
Country Market Week Actual Spend Vis to BLU CPV
08-07-2015 01:10 PM
Have you tried the aggregate calc for the xtab, your CPV is a detailed calc versus in an xtab it grouped.
Without seeing the numbers and the difference I would start there if you haven't already.