I think this should be easy, but I'm struggling at some point that I´m not aware of. I'm trying to show the total cost of Googls Ads campaigns at a specific date range in a Gauge component. Here is what I'm doing:
Current Value = SUM(@Cost)
- To this Current Value I added a Hidden Data = @Day (this column is in Input Format "yyyy-M-d")
- To this Hidden Data I created a date filter: Star Date = on and after $gAdsStartDay AND End Date = on and before $gAdsEndDay
Target Value = 100,000
Min Value = 0
Max Value = Sum(@Cost)
User Input Control:
- Date Start: Control Type = Date Picker | Output Format = Unix time (as seconds) | Variable = gAdsStartDay
User Input Control 2:
- Date End: Control Type = Date Picker | Output Format = Unix time (as seconds) | Variable = gAdsEndDay
At this point the Gauge meter shows 0.00 value and nothing happens when a try to change the Filters.
I've tried to change de Input Format of the Hidden Data to Unix time, but didn't work. Also tried to change de Output Format of the Filters (Date pickers) to "yyyy-M-d" and got nothing too.
Any ideas? As I said this might be easy, but I can't figure it out.
Thanks a lot!