SAP SAC Widget Using C4C Data

[Karlie_C]

I am working on building a dashboard in SAP SAC, using SAP C4C data. I am trying to find the best way to build a single widget using both “Reported On” (Requestinitalrecieptdatetimecontent) and “Resolved On” (ResolvedOnDateTime) fields. However, every time I do so, the data combines the numbers skewing the data. I have tried creating new columns to reflect the “ReportedOn” and “ResolvedOn” time stamps as values, data still comes back skewed. Any suggestions on how to apply the filters/data appropriately so the numbers reflect TRUE data points?

[Karlie_C]

Hi, thank you- I have tried to do that but the data still gets skewed. I used both reported on and resolved on fields, using 2 separate measures on created tickets and completed tickets. Not sure if I'm missing something. Thank you

[N1kh1l]

kconnell

kconnellYou would need 2 separate Date type dimension to capture both "Reported on" and "Resolved on" dates. If you use only one date type dimension the metrics will get aggregated.

Hope this helps

Nikhil

[Karlie_C]

Hi, thank you- I have tried to do that but the data still gets skewed. I used both reported on and resolved on fields, using 2 separate measures on created tickets and completed tickets. Not sure if I'm missing something. Thank you