I am trying to build a dashboard projecting Actual Vs Planned planned for a year.
Actual data is coming from My SQL whereas Planned data I am getting it from an excel.
I need to perform some calculations for the plan as in Distance * Plan . After creating those calculations ,when I load the calculated field it says " Query error Occured and Domain information not available." Did anyone face the same issue?
Can we do calculations on fields coming from excel?