Hello all !!!
i would like to apply to your experience, in order to progress with a Report development!
In this particular case, we need to count the total of CHG.ref_nums and ISS.ref_nums from some select statements.
In theory, just adding the Measure defined as =Count([Chg.Ref_num]) should return the proper counter , but instead, the resultes returned are completely far away from the reality.
I mean, for a particular time range, my Statement returns 10 different Chg.Ref_nums values/rows, but when i set a new column on my TOTAL COUNTERS report sheet, with the measure Total Chg Ref Num , the value is completely wrong, for example " 4200" ... or " 78" for the next row ...
I've also created a new variable, set as "=Count([chg.persid]), but the result is the same!
Any idea or hint?
Hi, Can you then share your select statements for the community to have a look.
Translating to SQL, i have:
chgalg.time_stamp >= PdmToday(-1, -7)
cnt.userid = chgalg.analyst_userid
chgalg.change_id = chg.id